This Microsoft Certification Program will get you certified in Excel, PowerPoint, Word, and Outlook. The package includes seven group classes, six hours of private training, and four Microsoft certification exams. Each group class and exam comes with a free retake, and you will also receive the M...
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
