Learn essential Excel skills through a comprehensive tutorial series covering fundamental concepts and advanced techniques. Master cell referencing, data filtering, sorting, and validation. Explore time-saving features like custom workbook themes, headers and footers, and comments. Discover efficient ways to calculate percentages, use find and replace, change text case, and protect worksheets. Improve your printing skills and learn to handle large spreadsheets. Dive into crucial functions such as VLOOKUP and HLOOKUP, and gain proficiency in basic formulas. Prepare for Excel-related interview questions with practical examples and position-specific guidance.
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
