What You'll 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
Who This Course is For
- Anyone interested in becoming a proficient Excel user.
- Start from the basics and advance step by step.
Your Instructor
Click Learning
Instructor at Udemy
4.2 Instructor Rating
4,935 Reviews
175,088 Students
34 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 2 days
Microsoft Excel: Complete Excel from Beginner to Advanced
Master Excel from scratch: Formulas, Functions, Data Analysis, VBA, and More! Master Excel essentia…
Free 100% Off
Today
Expires in 2 days
Microsoft Excel Formulas and Functions: Beginner to Expert
Master Spreadsheet Skills with Step-by-Step Guidance on Formulas, Functions, and Data Analysis.
Free 100% Off
Today
Expires in 3 days
Excel - Microsoft Excel Course Beginner to Expert
Beginner to Expert Level - Fundamentals, Charts, Pivot Tables, Micro, Functions, Formula & More.
Free 100% Off
Today
Expires in 3 days
The Leadership Accelerator
From stuck to seen: Your 90-day roadmap to clarity, confidence, and the promotion you deserve.
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.