Learn formulas, functions, Pivot Tables, charts, and all the skills needed to ace the Microsoft Office Specialist: Excel Expert exam and earn a professional certification in this hands-on program. This course is designed to help you pass the Excel Expert exam and includes: Three Excel courses (21...
Overview
Syllabus
- Interface
- Rows and Columns
- Autofill
- Data Entry
- Calculations
- Autosum Functions
- Text Functions
- True False
- Absolute Cell References
- Multi Input Functions
- Formatting
- Conditional Formatting
- Line Chart
- Column Chart
- Trendlines
- Pie Chart
- Tables
- Printing
- Worksheets
- Freeze Panes
- Excel Tricks
- Tips and Fundamentals
- Navigation
- Paste Special
- Paste Special Values
- Splitting Text
- Joining Text
- Named Ranges
- Data Validation
- Remove Duplicates
- VLOOKUP
- HLOOKUP
- Sort and Filter
- Pivot Tables New
- Pivot Grouping Timelines
- Multiple Pivot Tables
- If Statements
- And Or
- COUNTIFS and SUMIFS
- Combo Charts
- Advanced Cell Lock
- Hot Keys
- Go To Special
- Date Functions
- Adv Conditional Formatting
- Nested IFs
- If AND OR
- Goal Seek
- Data Tables
- Conditional Sumproduct
- Pivot Table Variances
- Pivot Calculations
- Pivot Charts
- Match Function
- Vlookup Match
- Index Match
- Index Double Match
- Windows
- Working Across Sheets
- Macros
- MacrosReport
- Consolidation
