Excel Essentials for the Real World (Complete Excel Course) (Udemy.com)

Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, Formulas... (Excel 2019, Excel 2016, O365)

Created by: Leila Gharani

Produced in 2020

icon
What you will learn

  • Master the ESSENTIAL Excel formulas and features to accelerate your career
  • Learn Excel from scratch or fill in the gaps to become immediately confident
  • Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports
  • Hacks and hidden Excel features from a Microsoft MVP with 15+ years of Experience
  • Explore the potential of Power Query. You'll be surprised at what you achieve with a bit of Power Query knowledge.
  • Get lifetime access to a proven and state-of-the-art Excel course including challenges, quizzes & exercises

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 98 / 100

icon
Course Description

Learn Excel from Scratch OR become more CONFIDENT.
Looking to learn Excel but don't know where to start?
OR, you've been using Microsoft Excel for a while but don't feel 100% confident?
There is so much information out there. What do you need to succeed at work?
I've picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
________________________________________________
WHY TAKE THIS SPECIFIC EXCEL COURSE?
Yes. There are many Microsoft Excel courses out there teaching you the important Excel functions and features you need to master.
BUT, can you apply what you learnt to your own files?
Do you get enough practice and challenges to remember all the new information?
This course will get you confident and comfortable designing simple to complex spreadsheets. You'll go beyond Excel basics. As you go through the course, you'll be able to apply what you learnt immediately to your job.
You'll master new formulas and find better ways to setup your existing spreadsheets. Management loves efficiency.
In this course you'll solve dozens of practical real-world examples. They'll help you think outside the box so you can work smarter not harder.
_________________________________________________
IS THIS ONLINE EXCEL COURSE FOR BEGINNERS ONLY?
This Complete Excel Course is for two types of people:
  1. Excel beginners, i.e. anyone looking to learn Excel from scratch
  2. Excel intermediate and Excel advanced users who want to make sure their skills cover all the essentials. This includes many Excel tricks and hidden features few data analysts know of.
The Excel Essentials for the Real World Course covers ALL the fundamentals an Excel beginner needs to know. BUT it also fills in the gaps for Excel Intermediate and Advanced users. It's for corporate professionals who feel comfortable with Excel but not 100% confident.
This is more than an Excel Basics Course. It starts off easy and adds in tips and tricks many Excel advanced users don't know of.
________________________________________________
WHAT YOU'LL BE ABLE TO ACHIEVE
By the end of the course you'll be confident showcasing your new Excel skills at work, allowing you to:
  • Input data and navigate large spreadsheets
  • Apply Excel hacks to get your work done faster
  • Be able to choose the right Excel formula to automate your data analysis (Excel VLOOKUP, IF Function, ROUND and more)
  • Use hidden Excel features to transform messy data to proper data sets
  • Get answers from your data
  • Organize, clean and manage large data
  • Create compelling Excel reports by following the set of spreadsheet design principles
  • Turn messy data into helpful charts
  • Create interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Time Lines
  • Import and transform data with tools like Get & Transform (Power Query)
We start from Microsoft Excel basics to make sure we have the right fundamentals. We them move on to more advanced topics like Conditional Formatting, Excel Pivot Tables and Power Query. We cover important formulas like VLOOKUP, SUMIFS and nested IF Functions.
I don't just cover the purpose of a feature or formula but how you can take advantage of it using practical examples.
There are challenges and quizzes along the way to test your new Excel skills.
Your downloadable Excel Course Notes are available as a PDF file. These cover the most important points. Keep them handy and refer to them when you need to.
________________________________________________
WHAT ARE SOME EXCEL FEATURES AND FUNCTIONS I WILL LEARN IN THIS COURSE
You'll learn:
  • How to customize the Microsoft Excel interface so you so you can easily find the files and features you use often.
  • To apply formatting correctly for cleaner and more professional reports.
  • To use important features like drop-down lists in Excel and add data validation to the cells. This way you can restrict the type of data which can be input in each cell.
  • How to add comments and notes to cells.
  • Add time stamps to your reports.
  • Automate data entry with Auto-Fill and Flash-fill.
  • How to best navigate large data and large spreadsheets.
  • Useful Excel shortcuts for data entry and navigation.
  • How to Protect your Excel files and worksheets properly.
  • Excel's essential rule when it comes to writing formulas.
  • How to write basic to advanced Excel formulas - also formulas that reference other workbooks or other worksheets.
  • The most useful Excel functions like, COUNTIFS, COUNT, SUMIFS, AVERAGEIFS, VLOOKUP, IF and many more.
  • How to convert raw Excel data into information you can use to create reports on.
  • Excel features that will help you to organize and structure data so it makes analysis easier (Sort, Filter, Search & Replace Go to Special etc...)
  • Useful Excel printing options which you'll need specially before you send your file to your boss or save as PDF.
  • Design principles for optimal spreadsheets.
  • Excel charts that go beyond column and bar charts. You'll learn how to create a Pareto chart, Histogram, Treemap, Sunburst charts and more.
  • Excel Pivot Tables so you can quickly get insights from your data.
  • What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets.
  • Use Power Query to transform messy data to tabular data.

    _________________________________________________
WHY WOULD YOU CHOOSE TO LEARN EXCEL?
Excel in itself can do so much for your career. It's just one program but it's the one hiring managers are interested in.
That's why basic Excel skills is a mandatory requirement for most office-based professionals today.
Superior Microsoft Excel skills can get you a promotion. Some jobs require tha

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Leila Gharani

Leila Gharani is a Microsoft Excel MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel. Her courses are for those who want to learn Excel, accelerate their careers and achieve more in less time.
Leila' background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.
Since 5 years, Leila runs her own Excel site and has an active YouTube channel with many engaging, high quality videos. She provides customized Excel dashboard seminars, enhanced visualization techniques, and advanced Excel seminars to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.
Her courses include examples based on her experience as well as the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.
She places great value on keeping her Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.
Leila's p

icon
Students also recommend

Free

Free

$14.53

icon
Reviews

4.9

98 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Fleur Pepper on a month ago

Excellent course. Key topics expertly explained. Definitely a five star program of study. I will be able to apply the techniques learnt with confidence.

By Nithin Jacob Koilpillai on 2 months ago

Wonderful course for giving a brief work around and features of excel. This will help people to work efficiently and smartly and save time in excel.Great course for beginners to intermediary level users.Even advanced users may find lot of tips which are effective .About leila she doesn't need introduction as many people know how excellent she is with her materials and teaching.Great stuff looking forward to apply all the techniques learned here.

By Joao Beccaro on 2 months ago

Two thumbsup for Leila!!She has a way to teach that is unique and hard to find in other courses. I am reallyglad and satisfied with theExcel Essentials for the Real World course.Looking forward to complete her other courses that I have already purchased.Thank you Leila.

By Michael Dickinson on 2 months ago

Yes it was a little basic information to start. BUT a good reminder of somethings you/I forget when not using excel every day.BUT what about the next information to follow well worth spending TIME and MONEY for the knowledge gained.Finally the POWERQUERY WOW a subject, What a Course I recommend it any one wanting brush up on the knowledge of EXCEL.

By Patricia Mathieu on a month ago

Leila is an amazing instructor!! Having little knowledge on excel I know feel much more confident.Thank you!!

By Bogdan Gabriel on 2 weeks ago

The course had a good structure and interactivity. I managed to solidify what I already knew and learnt everything that I wanted from this course.Thank you Leila

By Joseph D'mello on 2 months ago

After working with Excel for so long without a proper course, I am glad I took the step of going through Leila's Excel Essentials! Excellent narration and Great problem solving examples! Thank you Leila for passing on your knowledge!

By Shel Pomerantz on a month ago

The course was enjoyable, rewarding, and easy to follow along! I have you to thank for my new job and my newfound confidence using Excel.

By Justin Byrne on a month ago

The material is well compiled and presented. The course is well structured and the presenter conveys the material in an easy to follow and understand way. I am a fairly advanced user of Excel yet still picked up a few additional tricks for my arsenal from Leila.

By Saadia Bokhari on a month ago

I'm loving this course...i'm learning so many new things and some of the material is stuff i used years ago so it's a great refresher!

By Grant Wykerd on 2 months ago

A must course for any beginner as it steers you in the correct direction from the get go!I would also go as far as to recommend it as an all in one refresher course for anyone with previous but somewhat rusty knowledge...Leila, by far is one of the top minds in MS Excel and I am a fan!Thank you for sharing and caring Leila...

By Sjur Erik Nielsen on a month ago

As always this was a great Course with Leila! I consider myself as an experienced user of Excel and this was an Essential Course. But still, there is tons of tricks and ideas learnt from this course. Great Job Leila!