Microsoft Excel Basic to Advanced: A Complete Learning Path

Course Overview

• 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

Curriculum Highlights

• 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

Course Format

• Duration: 6 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion