Microsoft Excel Basic to Advanced: A Complete Learning Path

Master Microsoft Excel from the ground up, covering essential basics to advanced techniques in this comprehensive course

Created by: Click Learning
Instructor at Udemy

What Will I Learn?

• 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
• Proetect Worksheet and Worksheet
• Freeze and Split Panes
• Headers and Footers
• Page settings
• Set Print Area

Requirements

• No Prior Experience Required

Target audience

• Anyone interested in becoming a proficient Excel user.
• Start from the basics and advance step by step.