This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel In English
Module 1 Basic Terminology of Excel
Introduction (2:03)
Understanding GUI (0:42)
Sort and Filter (2:10)
Save (1:12)
Open (1:05)
Things to Know Before You Start Excel (2:37)
Data Formatting in Excel (3:43)
Spreadsheet basics (7:03)
Formatting (5:26)
Editing spreadsheets (5:51)
30 Basics Shortcuts (14:35)
Working with Excel Templates (4:19)
Basic Skills( Status bar) (3:02)
Module 2 Layout Formatting and Page Setup
Exploring Page Layout Methods (0:31)
Page Setup And Printing Controls (1:30)
Print Size (2:14)
Print Set Area (2:26)
Print (3:13)
Formatting Data in an Excel Worksheet (4:31)
Inserting Images and Shapes into an Excel Worksheet (10:56)
How To Split Data In To Multiple Columns (0:48)
Group and Ungroup (1:55)
Paste Special (4:35)
Module 3 Managing Tables
Create Table By 4 Way (1:23)
Managing Tables (5:22)
Module 4 Sorting and Filtering Data
Sort Basic (0:32)
Sort by Color (0:21)
Multi level Shorting (0:39)
Custom Sorting (1:15)
Sort and Filter (2:10)
Advance Filter (1:35)
Module 5 Conditional Formatting
Custom Conditional Formatting (1:11)
Conditional Formats with Data bar, Color Scale And Icon Set (2:53)
Conditional Formatting with Highlight cell and Top Bottom Rules (7:36)
Manage Edit and Delete Rules (1:13)
Module 6 Data Validation
Data Validation with Number (5:48)
Data Validation with Text (2:38)
Data Validation with Date (1:12)
Data Validation with Time (0:56)
Data Validation with Dynamic List (1:15)
Custom Validation - Remove Extra Space (1:41)
Module 7 Master in Data Manipulation and Security
How To Add Comments (1:13)
Consolidating Data (1:12)
How To Split Data In To Multiple Columns (0:48)
How To Insert Subtotals (0:30)
AutoFill Data Entry Methods (3:16)
Linking Worksheets (2:17)
Adding a Workbook Password (1:57)
Protect Worksheet (1:48)
Protecting the Structure of a Workbook (1:34)
Protecting Specific Cells in a Worksheet (2:50)
Allow Edit Range (2:39)
Undo and Redo (0:54)
Remove duplicate (1:16)
Module 8 Excel Tools
Trace Precedents and Dependents (1:32)
Formula Auditing (3:34)
Flash Fill (0:41)
Quick Access Toolbar (0:52)
Go to Function Tab – F5 Special (0:24)
Data From Access (1:21)
Freezing of Panes –Freeze Top Row, Freeze First Column, Freeze Customization (1:40)
Hide Row & Columns,Worksheets,Workbook (3:26)
Sparklines (2:34)
Splitting (1:17)
Inserting Text and Special Symbol (3:36)
Window View (2:08)
Proofing (2:26)
Nested IF (3:31)
Match (1:38)
Index and Match (3:06)
Module 9 Expertise in Dynamic Presentation and Visualization
Pie Chart (2:21)
Column Chart (3:48)
Bar Chart (0:36)
Area Chart (0:54)
Combo Chart (0:47)
Line Chart (1:24)
Scatter Chart (1:34)
Bubble Chart (0:47)
Pareto Chart (5:46)
Module 10 Pro in Pivot Table And Chart
Pivot Table (10:13)
Field Values (3:16)
Slicer (3:26)
Timeline Slicer (2:07)
Drill Down Pivot Data (1:51)
Pivot Chart Example (2:26)
7. Design in Pivot Chart in English (1:27)
Pivot Chart with Slicer (1:36)
Pivot Chart Template (3:30)
Conditional Formatting with Pivot table (7:52)
Start Macros (2:32)
First Basic Macros (4:24)
Data Filter Using Macros (5:56)
Assign Macros with QAT (1:53)
Pivot Table Grouping (2:26)
Module 11 Shortcuts
Basic Shortcuts (14:35)
Shortcuts With ALT KEY (9:53)
Shortcut with Ctrl Key (20:26)
Shortcut with Function (5:31)
Shortcut with Tabs (2:13)
Extra Shortcut (3:42)
Module 12 Deep Dive in Lookups
VlookUp-Syntax (3:17)
Basic Vlookup (2:52)
HlookUp (3:59)
Vlookup With Define Name (2:20)
Vlookup with Absolut Reference (2:37)
Vlookup with IFERROR(Find Duplicate) (1:53)
Vlookup with IF and ISERROR(Find Duplicate) (2:01)
Vlookup with Wide Card (2:13)
Vlookup Duplicate (2:10)
Vlookup with Approx Match (2:19)
Vlookup with MultipleSheets (2:09)
Vlookup with Match Function (2:43)
Vlookup with Multicolumn (3:05)
Vlookup with Image (5:26)
Module 13 Xlookup(NEW IN 2019)
Xlookup-Syntax and First Example (2:01)
Xlookup- Different Columns (0:51)
Vlookup Vs XlookUp (1:35)
Index Match VS Xlookup (0:56)
Hlookup Vs Xlookup (1:39)
Xlookup with Search (1:32)
Xlookup Search mode (1:22)
Module 14 Working with Range Names
Define Name (2:03)
Another Way to Define Name Range (1:17)
Define name Use with Formula (0:32)
Edit Name Range (0:55)
Delete Define Name (0:32)
Module 15 Using Formulas & Functions
Text Functions (26:04)
Logical Functions (8:38)
Lookup Functions (18:23)
Date Functions (15:18)
Maths and Trig Functions (23:37)
Statistical Functions (9:41)
Information Functions (10:41)
Module 16 Working with Reports
Basic Rules for Starting Pivot Table (4:02)
Create and Change Data Source (2:40)
Pivot Table Field (2:15)
Report Filter (1:18)
Layout group in Pivot (3:06)
Field Values (3:16)
Sorting data (0:37)
Pivot Chart Example (2:26)
Design in Pivot Chart (1:27)
Pivot Chart with Slicer (1:36)
Pivot Chart Template (3:30)
Slicer (3:26)
Slicer Design (1:38)
Slicer Property (2:09)
Consolidating Data from Multiple Sheets and Files using Pivot tables (3:45)
Module 17 What-IF Analysis
Scenario Manager (2:26)
Goal Seek (1:45)
Data Table (1:42)
Module 18 Interactive Dashboard Mastery
Exercise Do It By Yourself (0:18)
How to Create Dashboard (10:40)
Monthly Sales Revenue- Infographic Chart (6:12)
Weekly Sales Chart- Infographic Chart (7:35)
Module 19 Absolute and Relative Cell Reference
Relative Cell Reference (1:28)
Absolute Cell Reference (1:58)
Mixed Cell Reference (3:06)
Module 20 Automating Repetitive Tasks in Excel with Macros
Macros (4:36)
Macros with Pivot Table (12:53)
Macros - Relative Reference with Button (2:40)
Macros with Conditional Formatting Macros (2:23)
Macros with Data Validation (2:52)
Practice Workbooks
Functions
macro with data vallidation
consolidate AND subtotal
Pareto Analysis and gantt chart
dashboard
marks
macro with Conditional
index and match
if else
sort and filter
Data Validation
Xlookup- examples stud
What if Analysis
conditinal formatting
Pivot Table New
sparklines
vlookup-hlookup function
date formatting
Charts
Maths and Trig Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock