My lessons Sign in on VTC

Advanced Excel 2016 / Advance Formulas & Functions

Loading…

Functions, Formulas and VBA

Advance Formulas & Functions

← Previous lesson Next lesson →

Course content

Introduction
The New Look of Spreadsheets
Visualizing Worksheets
Manipulating Data
Adding Special Effects
Validation and Protection
Manipulating Data
Cell References
Advance Formulas & Functions
Tables and Scenarios
Creating Dashboard
Charts and Graphics
Creating a Specialty Chart
Working with Pivot Tables
Understanding Power Pivot
Automation & Macros
The VBA Screen
Conclusion
- Wrap Up Review1 credit or ad
- About Lauri1 credit or ad