Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master intermediate to advanced Excel techniques through this comprehensive 18-hour 54-minute course covering calculations, data analysis, and business intelligence. Develop effective and efficient solutions for typical business problems with emphasis on numeric, logical, and text calculations while converting raw data into useful information. Learn Excel file structure including cells, worksheets, sheet tabs, and workbooks, plus keyboard shortcuts for quick task completion. Understand number formatting as façade and utilize style formatting, number formatting, and page setup for effective information presentation. Create proper data sets with correct data types to leverage Excel's full capabilities and build efficient formulas for calculations and data analysis, including extensive coverage of formula types, elements, lookup formulas, and array formulas. Perform data analysis and business intelligence using Excel's built-in features such as Sort, Filter, Power Query, PivotTables, and Power Pivot while learning to import, clean, and transform data from multiple sources to build refreshable reports and dashboards. Automate tasks using recorded macros and VBA code from the internet, and apply finance functions, statistical functions, and rounding functions for specific calculations. The course covers 26 comprehensive classes including Excel fundamentals, formula lessons, PivotTables, Power Query, data models, references, array formulas, conditional calculations, text and date functions, data validation, lookup functions, charts, conditional formatting, dashboard building, data transformation, advanced filtering, Power BI Desktop introduction, financial functions, rounding functions, and macro recorder basics.
