Xlookup + transpos
- equations
- _Xlookup + transpos
- _VSTACK-UNIQUE
- _(Fill in the blanks)
- _(Filter)
- Data visualization
- _(1st Session)
- _(2nd Session)
- Course Excel 2016
- _Excel 2016 Basics
- __1.Getting Started with Excel
- __ 2.Understanding OneDrive
- __ 3.Creating and Opening Workbooks
- __ 4.Saving and Sharing Workbooks
- _Working with Cells and Sheets
- __ 5.Cell Basics
- __ 6.Modifying Columns, Rows, and Cells
- __ 7.Formatting Cells
- __ 8.Understanding Number Formats
- __ 9.Working with Multiple Worksheets
- __ 10.Using Find & Replace
- __ 11.Checking Spelling
- __ 12.Page Layout and Printing
- _Formulas and Functions
- __ 13.Intro to Formulas
- __ 14.Creating More Complex Formulas
- __ 15.Relative and Absolute Cell References
- __ 16.Functions
- _Working with Data
- __ 17.Basic Tips for Working with Data
- __ 18.Freezing Panes and View Options
- __ 19.Sorting Data
- __ 20.Filtering Data
- __ 21.Groups and Subtotals
- __ 22.Tables
- __ 23.Charts
- __ 24.Conditional Formatting
- _Doing More with Excel
- __ 25.Track Changes and Comments
- __ 26.Inspecting and Protecting Workbooks
- __ 27.Intro to PivotTables
- __ 28.Doing More with PivotTables
- __ 29.What-if Analysis
- _Extras
- __ 30.Buying Office 2016
- __ 31.New Features in Office 2016
- __ 32.What are Reference Styles?
- __ 33.More Resources
- __ 34.Excel Quiz
- _AND
- Average
- Get Pricing