Excel essential training – Excel Masters

About Course

Master Excel with this step-by-step course designed for all skill levels! Learn the essentials of data entry, formulas, and formatting, then dive into advanced topics like PivotTables, VLOOKUP, and data management. Each section includes hands-on exercises to help you apply your skills to real-world scenarios. With short, focused lessons, you’ll quickly become an Excel expert. Join now and unlock your full potential!

Course Content

Welcome to the course

Course Introduction

00:00

Section 1 – Getting started with excel

Section 2 – Entering Data

Section 3 – Creating Formulas and Functions

Section 4 – Formatting

Section 5 – Adjusting worksheet layout and data

Section 6 – Adjusting worksheet views

Section 7 – Security

Section 8 – IF function

Section 9 – Vlookup

Section 10 – Count family

Section 11 – data management features

Section 12 – Pivot tables

Conclusion

About Course

Course Content

Welcome to the course

Course Introduction

Section 1 – Getting started with excel

Download exercise file

01-Menu system

02-Quick access toolbar

03-Formula bar

04-Status bar

Section 2 – Entering Data

Download exercise file

01-Entering data.

02-Autofill

03-Dates and times

04-Comments

Section 3 – Creating Formulas and Functions

Download exercise file

01-Creating simple formulas

02-Copy formula

03-Working with relative, absolute references

04-Autosum

05-Excel Basic functions

Section 4 – Formatting

Download exercise file

01-Fonts

02-Align wrap merge

03-Border

04-Numbers

05-Date and time format

06-Condtional formatting

07-Tables

Section 5 – Adjusting worksheet layout and data

Download exercise file

01-Insert delete

02-Hide-Unhide

03-Move copy replace

Section 6 – Adjusting worksheet views

Download exercise file

01-Freeze panes

02-Spiliting

03-Collapsing and expanding data views with outlining

Section 7 – Security

Download exercise file

01-Unlocking cells and protecting worksheets

02-Assigning passwords to workbooks

03-Protecting workbooks

Section 8 – IF function

Download exercise file

01-Simple If

02-Nested If

03-Compound If

Section 9 – Vlookup

Download exercise file

01-Vlookup exact match

02-Vlookup approximate match

Section 10 – Count family

Download exercise file

01-Count family

02-Count family

Section 11 – data management features

Download exercise file

01-Sorting

02-Filter

03-Subtotal

04-Splitting data

05-Flashfill

06-Remove duplicates

07-Data validation

Section 12 – Pivot tables

Download exercise file

01-Crearting pivot tables

02-Manipulating Pivot able data

03-Grouping by date and time

04-Other grouping

Conclusion

Conclusion

Student Ratings & Reviews