{"product_id":"excel-data-analysis-course","title":"Excel Data Analysis Course","description":"\u003cdiv\u003e\n\u003cp\u003eThis hands-on \u003cstrong\u003eExcel data analysis course\u003c\/strong\u003e will expand your ability to analyze large amounts of data and professionally present your results. Gain the knowledge and skills to build more sophisticated spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better business decisions. \u003c\/p\u003e\r\n\u003cp\u003eIn this excel data analysis course, you use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform \"What-If\" analyses, leverage features and apply functions, manipulate PivotTables to analyze large amounts of data, and present your results to make better business decisions for planning and budgeting. You also learn how to automate processes and enhance worksheet models. \u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eExcel Data Analysis Course Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Excel Data Analysis course, you will learn to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eLeverage features of Microsoft Excel to facilitate business decisions.\u003c\/li\u003e\n\u003cli\u003eDevelop intelligent worksheets to identify KPIs quickly.\u003c\/li\u003e\n\u003cli\u003ePerform \"What-If\" analyses for developing budget and project plans.\u003c\/li\u003e\n\u003cli\u003eSummarize and analyze large amounts of data using PivotTables and Excel features.\u003c\/li\u003e\n\u003cli\u003eAutomate Excel processes.\u003c\/li\u003e\n\u003cli\u003eContinue learning and face new challenges with after-course one-on-one instructor coaching.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eExcel Data Analysis Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should have experience with Excel fundamentals at the level of Microsoft Excel Training Course.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eExcel Data Analysis Instructor-Led Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Troubleshooting and Enhancing Professional Workbooks\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eDeciphering and correcting functions for data integrity \u003c\/li\u003e\n\u003cli\u003eAccurately interpreting calculations \u003c\/li\u003e\n\u003cli\u003eImplementing Names to enhance your workbook model \u003c\/li\u003e\n\u003cli\u003eMonitoring KPIs (key performance indicators) using conditional formatting \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Analyzing Data with Functions\u003c\/h4\u003e\n\u003cp\u003eSummarizing business data with functions  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIdentifying the correct statistical function to aid analysis \u003c\/li\u003e\n\u003cli\u003eApplying basic financial functions \u003c\/li\u003e\n\u003cli\u003eDifferentiating serial dates and date presentations \u003c\/li\u003e\n\u003cli\u003eCalculating the number of working days \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eControlling calculations and nested formulas  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInterpreting data variations with the IF function \u003c\/li\u003e\n\u003cli\u003eStreamlining calculations with referencing \u003c\/li\u003e\n\u003cli\u003eDeveloping nested functions for multiple conditions \u003c\/li\u003e\n\u003cli\u003eCapturing information with lookup functions \u003c\/li\u003e\n\u003cli\u003eApplying techniques to implement and troubleshoot nested calculations \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Optimizing Workbook Models with \"What-If\" Analysis\u003c\/h4\u003e\n\u003cp\u003ePlanning for contingencies  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eManaging variables in worksheets with Scenarios \u003c\/li\u003e\n\u003cli\u003eComparing and contrasting different data sets with Scenarios reports \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eQuantifying variables in a workbook model  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDetermining the magnitude of a variable with Goal Seek to achieve an end value \u003c\/li\u003e\n\u003cli\u003eCalculating the optimum variable values in a worksheet model with Solver \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Summarizing Business Information\u003c\/h4\u003e\n\u003cp\u003eOrganizing workbooks and links  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eArranging multiple workbooks with Workspaces \u003c\/li\u003e\n\u003cli\u003eManaging external links \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eConsolidating ranges  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding 3D formulas to analyze worksheet data \u003c\/li\u003e\n\u003cli\u003eSummarizing multiple sources of Excel information into one worksheet \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Formulating Decisions from Database Information\u003c\/h4\u003e\n\u003cp\u003eDistilling data sets for data analysis  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining the architecture of an Excel data set \u003c\/li\u003e\n\u003cli\u003eManaging multiple data sets on a single worksheet with the Table feature \u003c\/li\u003e\n\u003cli\u003eExtracting unique lists of records from an Excel data set with the Advanced Filter \u003c\/li\u003e\n\u003cli\u003eAnalyzing data sets with filters and aggregation \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eInterpreting and refining data with PivotTables  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDefining data summaries interactively \u003c\/li\u003e\n\u003cli\u003eSummarizing data sets with grouping and aggregation \u003c\/li\u003e\n\u003cli\u003eComparing related totals dynamically \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eVisualizing and exploring PivotTable reports  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eFiltering details with Report Filters and Slicers \u003c\/li\u003e\n\u003cli\u003ePresenting PivotTable reports effectively with Pivot Charts \u003c\/li\u003e\n\u003cli\u003eExamining data patterns with Sparklines \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Enhancing Excel Usage with Macros\u003c\/h4\u003e\n\u003cp\u003eAutomating repetitive tasks  \u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying complex tasks and reducing errors \u003c\/li\u003e\n\u003cli\u003eBulletproofing routine editing and formatting \u003c\/li\u003e\n\u003cli\u003eInvoking macros with Form controls \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"267A83US \/ 2026-07-13T09:00:00 \/ Herndon, VA","offer_id":47534175322331,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"269A19CN \/ 2026-09-28T09:00:00 \/ Ottawa","offer_id":47634346541275,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"266A67CN \/ 2026-06-29T09:00:00 \/ Online","offer_id":48216539005147,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB30US \/ 2026-10-05T09:00:00 \/ Austin","offer_id":48216539037915,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BB56US \/ 2026-11-24T09:00:00 \/ Herndon, VA","offer_id":48216539070683,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"272A07CN \/ 2027-02-01T09:00:00 \/ Ottawa","offer_id":48216539103451,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273B26US \/ 2027-03-01T09:00:00 \/ Austin","offer_id":48309393981659,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B13US \/ 2027-04-26T09:00:00 \/ Herndon, VA","offer_id":48669350756571,"sku":"US-195-IL","price":1640.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/excel-data-analysis-course","provider":"Learning Tree International","version":"1.0","type":"link"}