4.75
(4 Ratings)

Microsoft Excel – Excel From Beginner to Advanced

Wishlist Share
Share Course
Page Link
Share On Social Media
Website Icon

About Course

Learn Microsoft Excel from beginner to advanced with this comprehensive course. This free course combines four different courses from Udemy, giving you a complete understanding of Excel. This is a free course from Udemy.

This course covers topics applicable to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023. You’ll learn:

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering Excel functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and more)
  • Creating dynamic reports with Excel PivotTables
  • Using PowerPivot
  • Auditing Excel formulas
  • Automating tasks with Macros and VBA

This course includes:

  • 18+ hours of video lectures by a Microsoft Certified Trainer (MCT)
  • Downloadable exercise files
  • Section quizzes
  • A Q&A board for asking questions

Enroll now and take the next step in mastering Excel. Go from Excel newbie to Excel guru!

Show More

What Will You Learn?

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Access to a Professional Trainer with 10+ years of Excel Training

Course Content

01 – Microsoft Excel 101 Course Introduction

  • 001 Ask Questions.mp4
    00:00
  • 002 Course Exercise Files.mp4
    00:00
  • 003 Certificate of Completion.mp4
    00:00

02 – Microsoft Excel Fundamentals

03 – Entering and Editing Text and Formulas

04 – Working with Basic Excel Functions

05 – Modifying an Excel Worksheet

06 – Formatting Data in an Excel Worksheet

07 – Inserting Images and Shapes into an Excel Worksheet

08 – Creating Basic Charts in Excel

09 – Printing an Excel Worksheet

10 – Working with Excel Templates

11 – Excel 101 – Practice What You’ve Learned (DOWNLOAD)

12 – Congratulations! You’ve Built a Solid Microsoft Excel Foundation

13 – Microsoft Excel 102 Course Introduction

14 – Working with an Excel List

15 – Excel List Functions

16 – Excel Data Validation

17 – Importing and Exporting Data

18 – Excel PivotTables

19 – Working with Excel’s PowerPivot Tools

20 – Working with Large Sets of Excel Data

21 – Excel 102 Additional Practice Exercises

22 – Congratulations! You’re an Intermediate Excel User

23 – Microsoft Excel 103 Course Introduction

24 – Working with Excel’s Conditional Functions

25 – Working with Excel’s Lookup Functions

26 – Working with Excel’s Text Based Functions

27 – Auditing an Excel Worksheet

28 – Protecting Excel Worksheets and Workbooks

29 – Mastering Excel’s What If Tools

30 – Automating Repetitive Tasks in Excel with Macros

31 – Excel 103 Additional Practice Exercises

32 – Congratulations!

33 – Microsoft Excel Macros and VBA Course Introduction

34 – Project #1 Using Excel’s Macro Recorder Tool

35 – Excel VBA Concepts

36 – Working with Excel VBA Logic Statements

37 – Project #2 Moving Beyond the Basics and into VBA

38 – Project #3 Preparing and Cleaning Up Data with Excel VBA

39 – Project #4 Using VBA to Automate Excel Formulas

40 – Project #5 Bringing it All Together and a Weekly Report

41 – Project #6 Working with Excel VBA User Forms

42 – Project #7 Importing Data from Text Files

43 – Course Wrap Up

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template

Student Ratings & Reviews

4.8
Total 4 Ratings
5
3 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
SM
2 months ago
Yeah , I am literally very thankful for this website.
it was very good experience and there is much to learn
TS
3 months ago
best course for begginers
Ahmad Mushtaq
9 months ago
Good comprehensive course. Taught almost all the important excel concepts which are required in daily use. The first module of the course is really well created and taught. Highly recommended for all students from all fields.

Want to receive push notifications for all major on-site activities?

×