Name: Microsoft Excel Basic to Advanced: A Complete Learning Path
Availability: InStock
Rating: 4.3 (3,619 students reviews)

Course Title: Microsoft Excel Basic to Advanced: A Complete Learning Path
Instructor: Click Learning
Target Audience:
- Beginners
- Professionals aiming to enhance Excel skills
- Individuals requiring advanced Excel techniques for work
Prerequisites: No Prior Experience Required

Key Topics Covered:
- Excel Fundamentals
- Formulas and Functions
- Data Visualization
- PivotTables and PivotCharts
- Data Analysis and Validation
- Macros and Automation
- Advanced Excel Techniques
- Create and Open Workbook
- Tabs and Ribbon
- Errors Functions
- AND, OR, XOR, SWITCH, CELL Functions
- IF and Nesting IF() Functions
- Filter Functions
- DATE and DATEVALUE Functions
- Convert Time Hours, Minutes and Seconds
- COUNT, ROUND, SUM, AVERAGE Functions
- Subtotal and Power Functions
- INT & TRUNC Function
- Find and Replace
- LEN, MID, REPT, SPLIT, TEXT and TRIM
- INDEX, MATCH, EXACT Functions
- VLOOKUP, HLOOKUP and XLOOKUP Functions
- Exact match vs Approximate match
- Import Data Web to Excel
- Convert Number to Word
- Dynamic dropdown List
- Dependent dropdown List
- Charts & Graphs
- Sort and Filter Functions
- Protect Worksheet and Worksheet
- Freeze and Split Panes
- Headers and Footers
- Page settings
- Set Print Area
Key Skills Learned:
- Navigate Excel interface
- Perform basic tasks (data entry, formatting, calculations)
- Master core formulas and functions (SUM, AVERAGE, VLOOKUP, IF statements)
- Create charts and graphs
- Apply conditional formatting
- Use PivotTables and PivotCharts
- Apply data analysis tools (Goal Seek, Solver, Data Validation)
- Automate tasks with macros
- Perform What If Analysis
- Handle large datasets with Power Query