Excel Formulas & Functions, PivotTables, Slicers & Charts

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive 1-hour 14-minute tutorial on Excel's powerful features, including worksheet formulas, functions, PivotTables, slicers, charts, and Excel tables. Learn essential calculations, formula elements, and functions like ROUND, TEXTBEFORE, and IFNA. Master number formatting, logical formulas, and Excel's "Golden Rule" for efficient modeling. Explore data analysis techniques, including Excel Tables and PivotTables, with practical examples of grouping dates, changing report layouts, and applying conditional formatting. Discover how to create and format charts, implement slicers for dynamic visualizations, and understand best practices for data presentation. Perfect for both beginners and intermediate users looking to enhance their Excel skills for data analysis and reporting.

Syllabus

) Introduction.
) Calculations in Excel.
) Worksheet formulas definition and elements.
) Example of Number Formula.
) ROUND function.
) How Number Formatting Interacts with Numbers and Formulas.
) Example of Text Formula.
) TEXTBEFORE function.
) FORMULATEXT function.
) IFNA function.
) Show Nothing with a Formula using Zero Length Text String “”.
) Example of Logical Formula using Comparative Operators.
) Don’t Get Tricked By Number Formatting.
) Alt Keyboard Shortcuts.
) Excel’s Golden Rule = Most Important Formula Tip.
) Excel Models.
) Percentage Number Format.
) Style Formatting.
) “Old School” Formula that Requires a Relative Cell Reference and a Manual Copy action..
) Angry Rabbit Copy Cursor.
) “New School” Formula that Spills Results.
) Dynamic Spilled Array Formula.
) Beauty of Excel. Bricklin and Frankston and VisiCalc..
) Summary of Worksheet Formulas and Excel Models.
) Define Data Analysis.
) Define Data, Table, Field, Record.
) Tools for Data Analysis.
) Data Analysis Goals for Video.
) Excel Table feature.
) Define PivotTable .
) PivotTable feature.
) Grouping Dates to create Month Report.
) PivotTable Cache.
) Change Report Layout, Manually and Default Settings.
) Calculations in Values Area of PivotTable.
) Number Formatting for PivotTable.
) Conditional Formatting in PivotTable.
) Add New Data to Excel Table and Refresh PivotTable.
) Default Settings For Expanding Excel Tables.
) Excel Line Chart to Show Sales Trends from a PivotTable.
) Formatting Chart.
) Rules for Visualizing with Charts.
) Add Slicer To PivotTable and Chart to visualize Sales Rep Sales Trends.
) Excel Data Analysis Tools Summary.
) Summary of Video.
) Closing and Video Links.