Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Beginners to Advanced Level Training
Rating: 4.7 out of 5(477 ratings)
5,752 students

Microsoft Excel Beginners to Advanced Level Training

Learn Excel Formatting, Excel functions, Excel charts, Excel pivot tables and creating Interactive Reports
Created byRamzan Rajani
Last updated 7/2023
English

What you'll learn

  • Learn the most common Excel functions used in the Office
  • Create Interactive and Dynamic reports by mastering one of the most popular tools Pivot Table and Table Mode
  • Create Beautiful & Stunning Dynamic Charts
  • Writing IF Conditions and Nested IFs
  • Mastering Vlookup (Basic to Advanced Level)
  • Conditional Formatting with 12+ Sub options
  • Learn CountIFs & SumIFs functions which is used to create Summary Reports
  • Macros (Recording & Running) to Automate your regular task

Course content

27 sections • 100 lectures • 9h 0m total length

  • Download Practice Files for Excel Basic Level Topics0:02

    Download Practice Files for Excel Basic Level Topics

  • Introduction to Excel and Basic Excel Shortcut Part 113:38
  • Excel Shortcuts - Speed Booster - Part 210:14
  • Excel Shortcuts - Speed Booster - Part 35:39
  • Excel Basic Formulas Part 110:59
  • Excel Basic Formulas Part 212:28
  • Excel Basic Formulas Part 37:10
  • Excel Basic Formulas Part 46:01
  • Excel Challenge Exercise6:57
  • Sorting (Arranging Data in Proper Order)10:50
  • Filtering Data6:34
  • Adding Comment in Cell3:03
  • SubTotal (Creating Basic Summary Report)7:23
  • Conditional Formatting (Coloring Data on the basic of Conditions)8:02
  • PageSetup10:05
  • Text to Column6:19
  • Left Right & Mid Formulas7:04
  • Freeze UnFreeze Row and Column3:55

Requirements

  • No Prior Excel Knowledge Required
  • Desktop / Laptop with MS Excel Installed to Follow Along with Instructor

Description

Excel skills are in high demand by most of the organizations. 

Microsoft Excel is the greatest productivity software the world has seen so far.

However, it’s essential that you learn how to work with it effectively.


In this course you will learn Step by Step how to create Summary reports, formulas from basic to advanced level including Vlookup, IF Condition, Multiple IFs and lot many which you can use in your reporting.


What makes this course different from the rest of the Excel courses out there ?

  • You will be trained by Microsoft Certified Trainer + Excel Specialist

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours

  • Downloadable materials : This Course comes with a complete set of downloadable materials

This course is suitable for people with basic working knowledge in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as Vlookup functions, IF Conditions, Pivot Tables, Conditional Formatting, Excel Charts, and other tools that are often used for the purposes for regular reporting.


This course will teach you how to save time and be productive. 

You should Pause the video, rewatch, and repeat exercises until you mastered them.

Happy Learning ! 

See you in the Session

Who this course is for:

  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Report abuse