This course aims to teach beginners the basics of Excel, including functions like IF, VLOOKUP, and formula tricks. Students will learn about Excel cell references, filtering data, sorting data, creating drop-down lists, setting default workbook themes, using headers and footers, working with comments, calculating percentages, finding and replacing data, changing text case, locking cells, solving printing issues, and mastering VLOOKUP and HLOOKUP functions. The course uses tutorials and examples to help learners develop essential Excel skills. The intended audience for this course is beginners who are new to Excel or those who want to enhance their existing Excel knowledge.
Overview
Syllabus
Excel Tutorial for Beginners | Excel Made Easy.
Excel Cell Reference: Absolute, Relative or Mixed?.
How Familiar Are You With Excel Cell Modes? (Ready, Enter, Point, Edit).
Excel Filter Basics (for quick data analysis).
Advanced Excel Filter (And, Or, Between conditions for criteria range).
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort.
Create SMART Drop Down Lists in Excel (with Data Validation).
Excel Custom Data Validation (Use formulas to check for text, numbers & length).
How to set Default Workbook Theme in Excel and how this could help you save time.
Excel Header & Footer (& Quickly Copy to other Sheets).
All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More.
Calculate Percentages the Right Way in Excel (% Change & Amount after % increase).
Excel's Find and Replace (surprising features).
Change CASE of text in Excel (3 ways including NO Formulas).
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!.
Your Excel Printing Problems, Solved!.
Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers).
Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples.
Basic Excel Formulas and Functions You NEED to KNOW!.
How to ACE Excel Interview Questions (Based on YOUR feedback & by Position).
Taught by
Leila Gharani
