Full Excel Course for Beginners to Advance

Excel Introduction

Lesson 1

This course covers Excel tools, formulas, functions, dashboards and real examples.

20 July 2021

Excel Interface Explained

Lesson 2

This course covers Excel tools, formulas, functions, dashboards and real examples.

20 July 2021

Excel Tool Panel Guide

Lesson 3

This course covers Excel tools, formulas, functions, dashboards and real examples.

20 July 2021

Full Excel Course for Beginners to Advance

Full Excel Course for Beginners to Advance

Learn Microsoft Excel step by step from beginner to advanced level. This course covers Excel basics, formatting, formulas, functions, charts and dashboards.

Excel Basics

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 1 – Introduction to Microsoft Excel
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 2 – Installing Microsoft Excel
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 3 – Excel Interface Overview
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 4 – Excel Ribbon and Tabs
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 5 – Workbook vs Worksheet
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 6 – Rows Columns and Cells
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 7 – Selecting Cells and Ranges
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 8 – Entering Data in Excel
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 9 – Editing Data in Excel
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 10 – Saving Excel Files

Excel Formatting

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 11 – Cell Formatting Basics
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 12 – Font Formatting
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 13 – Alignment Tools
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 14 – Number Formatting
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 15 – Currency and Percentage Format
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 16 – Borders and Cell Colors
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 17 – Format Painter Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 18 – Wrap Text Option
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 19 – Merge and Center Cells
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 20 – Conditional Cell Styles

Excel Navigation

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 21 – Moving Around Worksheets
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 22 – Excel Scroll Tools
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 23 – Using Freeze Panes
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 24 – Splitting Worksheets
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 25 – Zoom Controls

Data Entry & Editing

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 26 – Copy Paste Options
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 27 – Cut and Paste Special
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 28 – AutoFill Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 29 – Flash Fill Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 30 – Fill Series

Excel Formulas Basics

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 31 – Introduction to Excel Formulas
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 32 – Writing Your First Formula
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 33 – Mathematical Operators in Excel
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 34 – Order of Operations
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 35 – Formula Errors Explained
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 36 – Relative Cell Reference
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 37 – Absolute Cell Reference
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 38 – Mixed Cell Reference
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 39 – Formula Auditing Tools
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 40 – Trace Precedents and Dependents

Basic Excel Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 41 – Introduction to Functions
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 42 – SUM Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 43 – AVERAGE Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 44 – COUNT Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 45 – COUNTA Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 46 – MAX Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 47 – MIN Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 48 – ROUND Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 49 – ROUNDUP Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 50 – ROUNDDOWN Function

Logical Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 51 – IF Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 52 – Nested IF Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 53 – AND Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 54 – OR Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 55 – NOT Function

Text Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 56 – LEFT Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 57 – RIGHT Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 58 – MID Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 59 – LEN Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 60 – TRIM Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 61 – CONCAT Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 62 – UPPER Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 63 – LOWER Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 64 – PROPER Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 65 – TEXT Function

Date & Time Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 66 – TODAY Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 67 – NOW Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 68 – DATE Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 69 – DAY Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 70 – MONTH Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 71 – YEAR Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 72 – WEEKDAY Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 73 – EOMONTH Function

Lookup Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 74 – Introduction to Lookup Functions
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 75 – VLOOKUP Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 76 – HLOOKUP Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 77 – XLOOKUP Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 78 – LOOKUP Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 79 – INDEX Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 80 – MATCH Function
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 81 – INDEX MATCH Combination

Data Tools

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 82 – Sort Data
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 83 – Custom Sorting
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 84 – Filter Data
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 85 – Advanced Filters
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 86 – Remove Duplicate Data
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 87 – Data Validation Basics
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 88 – Dropdown Lists
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 89 – Text to Columns

Excel Tables

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 90 – Creating Excel Tables
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 91 – Table Design Options
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 92 – Table Filtering and Sorting
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 93 – Structured References

Charts and Graphs

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 94 – Introduction to Excel Charts
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 95 – Column Chart
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 96 – Bar Chart
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 97 – Line Chart
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 98 – Pie Chart
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 99 – Area Chart
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 100 – Combo Charts

Pivot Tables

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 101 – Introduction to Pivot Tables
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 102 – Creating Pivot Tables
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 103 – Pivot Table Fields
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 104 – Pivot Table Filters
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 105 – Pivot Charts

Conditional Formatting

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 106 – Introduction to Conditional Formatting
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 107 – Highlight Cell Rules
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 108 – Data Bars
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 109 – Color Scales
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 110 – Icon Sets

Date & Time Functions

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 111 – Goal Seek Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 112 – Scenario Manager
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 113 – Data Tables

Advanced Excel

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 114 – Excel Macros Introduction
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 115 – Recording Macros
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 116 – Running Macros
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 117 – Excel Power Query Basics
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 118 – Importing Data from External Sources

Excel Dashboards

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 119 – Dashboard Design Basics
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 120 – Creating Dashboard Layout
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 121 – Dashboard Charts
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 122 – Dashboard KPIs

Excel Productivity

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 123 – Excel Keyboard Shortcuts
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 124 – Excel Tips and Tricks
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 125 – Quick Analysis Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 126 – Excel Templates

Excel Data Cleaning

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 127 – Find and Replace Tool
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 128 – Removing Extra Spaces
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 129 – Handling Missing Data
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 130 – Cleaning Text Data

Excel Security

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 131 – Protecting Excel Sheets
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 132 – Protecting Excel Workbook
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 133 – Password Protecting Files

Excel Data Cleaning

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 134 – Sharing Excel Files
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 135 – Comments and Notes
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 136 – Track Changes

Real World Excel

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 137 – Sales Report Example
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 138 – Expense Tracker
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 139 – Inventory Management Sheet
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 140 – Attendance Tracker

Advanced Projects

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 141 – Financial Dashboard
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 142 – Sales Dashboard
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 143 – HR Dashboard

Excel Automation

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 144 – Introduction to Automation
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 145 – Automating Reports
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 146 – Using Templates

Final Section

Gemini Generated Image 45xlki45xlki45xl Copy Lesson 147 – Excel Best Practices
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 148 – Common Excel Mistakes
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 149 – Excel Interview Questions
Gemini Generated Image 45xlki45xlki45xl Copy Lesson 150 – Final Excel Project
More
More