Everything you need: Microsoft Excel functions, Excel formulas, Excel Macros, VBA, Pivot Tables, Microsoft Excel options
InstructorAndrea Maddes
Free
Instruction covers standard charts alongside specialized visualizations like Tree Maps, Sunbursts, and Box & Whisker plots.
The curriculum includes specific Excel files for use in each chapter to facilitate hands-on practice.
Editorial course preview
These 2 complementary views highlight concrete, legible examples from the course presentation.
The Visual Basic for Applications editor displays the Project Explorer and code window containing Sub procedures for US and EU date formats.
This Excel interface demonstrates advanced function debugging by displaying formula tracing arrows and division error indicators within a safety dataset.
Learners can move from basic calculations to recording macros and using form controls for task automation.
The curriculum introduces macro recording and VBA, but some signals suggest a desire for more extensive coverage of these topics.
One signal, created before the displayed update date, indicates that the instructor's voice volume may be too low for comfortable listening; note that the update label does not prove a correction.
The curriculum aligns with the target audience of beginners and professionals seeking essential skills.