Excel Essentials for the Real World (Complete Excel Course)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Learn Excel from Scratch OR become more CONFIDENT.

*******************************

COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as:

  • Excel's new XLOOKUP function

  • New FILTER function in Excel

  • SORT, SORTBY & UNIQUE functions

In addition to the above, we also cover:

  1. Excel's new calculation engine and how older formulas are impacted

  2. What the Hash (#) sign is

  3. Compatibility and the at (@) sign you might see in your older files

  4. The new errors such as #SPILL and #CALC

  5. Data validation drop-down lists and dynamic array references

If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section.

*******************************

Looking to learn Microsoft Excel and improve your data analysis skills 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 that to begin with.

_________________________________________________

WHICH VERSION OF EXCEL IS USED IN THE COURSE?

The course is applicable for Excel 2019, Excel 2016 & Excel for Microsoft 365. Generally all features and formulas with exception of a few Excel charts (Histogram, Pareto, Treemap and Sunburst charts) will work on Excel 2010 & Excel 2013. For the Power Query section, you'll have to install the free Excel Power Query add-in if you have Excel 2010 or Excel 2013 to be able to follow along. Other than this, the other features and formulas shown are valid for all Excel versions.

_________________________________________________

★★★★★ "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa

★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith

★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo

★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison

★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa

________________________________________________

There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work.

The course comes with lifetime access. Buy now. Watch anytime.

Who this course is for:

  • Business professionals looking to become more confident in Excel.
  • Absolute beginners who want a structured, engaging, fun and practical Excel course.
  • Excel users who want to discover & showcase new tips and tricks from Excel MVPs.
  • Students who want to make sure they have the Excel knowledge to succeed at their next job.
  • Data analysts looking to discover new tools to help them do more in less time.

Expected Outcomes

  1. 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 Learn what's new in Excel for Microsoft 365 and how these changes impact the way you use Excel Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions Curated for the Udemy Business collection Requirements A computer or laptop with Windows (some techniques might not work on Mac) Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details) No prior Excel knowledge is needed. Willingness to learn. Let's do this! Description Learn Excel from Scratch OR become more CONFIDENT. ******************************* COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as: Excel's new XLOOKUP function New FILTER function in Excel SORT, SORTBY & UNIQUE functions In addition to the above, we also cover: Excel's new calculation engine and how older formulas are impacted What the Hash (#) sign is Compatibility and the at (@) sign you might see in your older files The new errors such as #SPILL and #CALC Data validation drop-down lists and dynamic array references If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section. ******************************* Looking to learn Microsoft Excel and improve your data analysis skills 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: Excel beginners, i.e. anyone looking to learn Excel from scratch 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 that to begin with. _________________________________________________ WHICH VERSION OF EXCEL IS USED IN THE COURSE? The course is applicable for Excel 2019, Excel 2016 & Excel for Microsoft 365 . Generally all features and formulas with exception of a few Excel charts (Histogram, Pareto, Treemap and Sunburst charts) will work on Excel 2010 & Excel 2013 . For the Power Query section, you'll have to install the free Excel Power Query add-in if you have Excel 2010 or Excel 2013 to be able to follow along. Other than this, the other features and formulas shown are valid for all Excel versions. _________________________________________________ ★★★★★ "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa ★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith ★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo ★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison ★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa ________________________________________________ There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: Business professionals looking to become more confident in Excel. Absolute beginners who want a structured, engaging, fun and practical Excel course. Excel users who want to discover & showcase new tips and tricks from Excel MVPs. Students who want to make sure they have the Excel knowledge to succeed at their next job. Data analysts looking to discover new tools to help them do more in less time. Show more Show less Featured review Michael Dickinson 65 courses 15 reviews Rating: 5.0 out of 5 a year 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. Show more Show less Course content 15 sections • 145 lectures • 11h 3m total length Expand all sections Before You Dive In 3 lectures • 4min How to Get the Most Out of This Course Preview 03:01 Download Course Files 01:10 Course Outline for Quick Reference 00:14 Quick Tour of Excel 4 lectures • 19min Excel Workbook, Worksheet, Cell Structure 08:43 Quick Tour of Excel - Ribbon & Quick Access Toolbar 03:45 Customizing the Excel Interface 06:00 Summary: Important Points to Remember (Terminology & Shortcuts) 00:58 Quiz: Excel Fundamentals 4 questions Data Input & Hidden Features to Save Time 16 lectures • 1hr 15min Overview - Data Input & Hidden Excel Features 01:40 Data Entry and Editing Excel Data 07:14 Basic Excel Formulas 09:26 Text to Speech (Hidden Excel Feature) 03:09 Correctly Input Dates and Time Stamps in Excel 04:25 Use Excel AutoFill To Do Your Work 03:56 Excel Flash Fill for Major Time Saving (Become Pro) 05:00 Custom Lists With AutoFill (Hidden Excel Feature) 02:30 Inputting & Editing Comments & Notes in Excel 08:13 Finding Excel Formulas & Input Cells with ONE Click (Become Pro) 03:59 Excel Data Validation to Reduce Time Checking Data Preview 11:04 Adding Tool Tips (Screen Tips in Excel) 02:18 Learn to Work with Pictures, Shapes & Other Objects in Excel 05:31 Quiz: Data Input in Excel 5 questions Challenge: Data Manipulation & Preparation in Excel 00:22 Solution: Data Manipulation & Preparation in Excel Preview 05:41 Summary: Key Excel Features to Impress & Save Time 00:58 Worksheet Navigation, Copying and Protecting 10 lectures • 45min Overview - Worksheet Navigation in Excel 01:07 Useful Excel Shortcuts for Navigation (Become Pro) 11:01 Copying, Moving & Hiding Worksheets 03:12 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports 03:01 Hide & Unhide, Insert, Adjust Columns & Rows in Excel 06:32 Copying and Pasting Data (Hidden Excel Paste Features) 05:55 Protecting Excel Worksheets & Specific Ranges 08:44 Challenge: Update & Protect Excel Report 00:16 Solution: Update & Protect Excel Report 03:57 Quiz: Worksheet Navigation 5 questions Summary: Important Worksheet Features & Excel Shortcuts 01:40 Excel Formulas & What to be Aware of 12 lectures • 41min Overview - Excel Formulas & What to be Aware of 02:26 How Excel Calculates - Order of Precedence 05:19 Simple but Useful Excel Formulas 05:18 Essential Excel Rule (Don't Skip!) 02:31 Absolute and Relative Cell Referencing in Excel 06:19 Improve Clarity with Range Names 05:09 Referencing other Workbooks or Worksheets 03:54 Circular References & How to Locate Them 01:40 Combine Values From Two or More Cells to ONE Cell 03:44 Challenge: Allocate Yearly Value Based on Percentages 00:21 Solution: Allocate Yearly Value Based on Percentages 03:42 Quiz: Excel Formulas 5 questions Summary: Key Points when Writing Excel Formulas 00:57 Important Excel Functions (Everything you need to become Pro) 17 lectures • 1hr 30min Overview & Finding Excel Functions from Insert Function 05:07 Important! Working with Excel Functions 00:43 COUNT, COUNTA, COUNTBLANK 04:12 COUNT based on a Condition (COUNTIFS) 09:29 SUM & AVERAGE Functions in Excel 03:10 SUM by Criteria (SUMIFS, AVERAGEIFS) 06:17 MAX & MIN (MAXIFS & MINIFS) 04:06 Rounding Values (ROUND, ROUNDUP & ROUNDOWN) 05:31 Essential Excel Date Functions 09:21 Time Calculations in Excel - Total Time Worked Preview 06:00 Handling Excel Formula Errors 05:19 IF (Then, Else) Excel Function - Conditional Formulas 13:22 VLOOKUP Function - Lookup Values from Another Place 07:48 Challenge: How Good Are you with Excel Functions? 00:30 Solution: How Good Are you with Excel Functions? 07:11 NEW 365 Functions: FILTER, SORT, UNIQUE, XLOOKUP & More 00:54 Summary: Important Excel Functions 01:14 Data Cleaning and Management: Sorting, Filtering & Replacing Data 15 lectures • 1hr 6min Overview - Data Cleaning, Analysis & Management Tools in Excel Preview 02:27 Sort Data (Organize & Create Order) in Excel 07:05 Unsort Data to Revert to Original Order 01:49 Add Subtotals to Sorted Data 06:27 Filter Data to Extract What you Need 06:00 Delete Blank or Empty Rows in Excel 03:52 Fill Empty Cells in One Go (Become Pro) 03:26 Remove Duplicates to Get a Unique List in Excel 03:01 Excel Find Feature, Select & Emphasize 07:10 Find and Replace Values & Formatting (Hidden Excel Feature) 05:09 Why Excel Tables Can be a Time Saver (Become Pro) 10:21 Challenge: Data Management in Excel 00:24 Solution: Data Management Challenge in Excel 05:31 Summary: Tools for Organizing, Cleaning & Managing Data in Excel 01:01 Special Message - You've Got This! 02:14 Formatting including Conditional & Number Formatting in Excel 10 lectures • 37min Overview - All About Formatting Preview 01:29 Excel Formatting Tips - Alignment, Borders & More 05:27 Better Than Merge (Become Pro) 03:24 Justify Text Length (Hidden Excel Feature) 02:37 Excel Number Formatting Options (& Special Formatting) 03:39 Excel Conditional Formatting (Top Bottom Analysis & More) Preview 06:20 Icons & Data Bars with Conditional Formatting in Excel 06:39 Quiz: Excel Formatting 4 questions Challenge: Format Excel Report 00:23 Solution: Format Excel Report Challenge 06:45 Summary: Useful Excel Formatting Tools 00:36 Printing Excel Files & Saving as PDF 9 lectures • 27min Checklist Before Printing 02:10 Useful Printing Options in Excel 04:22 Adding Page Breaks & Printing Parts of a Sheet 04:22 Printing Large Datasets (Make sure you include this!) 03:47 Header & Footer in Excel (Logo, Page Numbers, etc.) 04:00 Saving Excel Files PDF & Printing Many Sheets 03:42 Challenge: Prepare Excel Report for Printing 00:22 Solution: Prepare Excel Report for Printing 03:20 Summary: Excel Printing Checklist 00:46 Workbook Design Principles 6 lectures • 28min Good Spreadsheet Design Principles (with Examples) 05:24 Adding Hyperlinks (Plus a Smart Workaround) in Excel 06:47 Define Cell Styles & Set Defaults (e.g. for Excel Tables) 05:36 Excel Workbook Theme & Color to Save Time 05:22 Use Your Own Excel Templates 04:05 Quiz: Workbook Design 5 questions Summary: Excel Workbook Design Principles 00:58 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, 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 site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques 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 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 passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f877b92edbef',m:'72b1d4636acfee7f57d4a9f4877af8f3fb187fd3-1627840875-1800-AQlasMMFSYtptA+iEBMfvUmZstCitdQuoSZLwUz4oq1QQ8UQmSnLltrVMtQ4vBBv8cetGfiFwgyc/nqrpLzawiPJjKL0HcFtxbo9lVmFil61CRKt1hWnDN77CjHt7dKKnvIx3sn+/ktyNmfMEbE8MgXOU185kJ+yZPMOt9RT3SOs',s:[0xdc2dee1696,0x68a853718d],}})();
  2. 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 Learn what's new in Excel for Microsoft 365 and how these changes impact the way you use Excel Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions Curated for the Udemy Business collection Requirements A computer or laptop with Windows (some techniques might not work on Mac) Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details) No prior Excel knowledge is needed. Willingness to learn. Let's do this! Description Learn Excel from Scratch OR become more CONFIDENT. ******************************* COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as: Excel's new XLOOKUP function New FILTER function in Excel SORT, SORTBY & UNIQUE functions In addition to the above, we also cover: Excel's new calculation engine and how older formulas are impacted What the Hash (#) sign is Compatibility and the at (@) sign you might see in your older files The new errors such as #SPILL and #CALC Data validation drop-down lists and dynamic array references If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section. ******************************* Looking to learn Microsoft Excel and improve your data analysis skills 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: Excel beginners, i.e. anyone looking to learn Excel from scratch 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 that to begin with. _________________________________________________ WHICH VERSION OF EXCEL IS USED IN THE COURSE? The course is applicable for Excel 2019, Excel 2016 & Excel for Microsoft 365 . Generally all features and formulas with exception of a few Excel charts (Histogram, Pareto, Treemap and Sunburst charts) will work on Excel 2010 & Excel 2013 . For the Power Query section, you'll have to install the free Excel Power Query add-in if you have Excel 2010 or Excel 2013 to be able to follow along. Other than this, the other features and formulas shown are valid for all Excel versions. _________________________________________________ ★★★★★ "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa ★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith ★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo ★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison ★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa ________________________________________________ There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: Business professionals looking to become more confident in Excel. Absolute beginners who want a structured, engaging, fun and practical Excel course. Excel users who want to discover & showcase new tips and tricks from Excel MVPs. Students who want to make sure they have the Excel knowledge to succeed at their next job. Data analysts looking to discover new tools to help them do more in less time. Show more Show less Featured review Michael Dickinson 65 courses 15 reviews Rating: 5.0 out of 5 a year 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. Show more Show less Course content 15 sections • 145 lectures • 11h 3m total length Expand all sections Before You Dive In 3 lectures • 4min How to Get the Most Out of This Course Preview 03:01 Download Course Files 01:10 Course Outline for Quick Reference 00:14 Quick Tour of Excel 4 lectures • 19min Excel Workbook, Worksheet, Cell Structure 08:43 Quick Tour of Excel - Ribbon & Quick Access Toolbar 03:45 Customizing the Excel Interface 06:00 Summary: Important Points to Remember (Terminology & Shortcuts) 00:58 Quiz: Excel Fundamentals 4 questions Data Input & Hidden Features to Save Time 16 lectures • 1hr 15min Overview - Data Input & Hidden Excel Features 01:40 Data Entry and Editing Excel Data 07:14 Basic Excel Formulas 09:26 Text to Speech (Hidden Excel Feature) 03:09 Correctly Input Dates and Time Stamps in Excel 04:25 Use Excel AutoFill To Do Your Work 03:56 Excel Flash Fill for Major Time Saving (Become Pro) 05:00 Custom Lists With AutoFill (Hidden Excel Feature) 02:30 Inputting & Editing Comments & Notes in Excel 08:13 Finding Excel Formulas & Input Cells with ONE Click (Become Pro) 03:59 Excel Data Validation to Reduce Time Checking Data Preview 11:04 Adding Tool Tips (Screen Tips in Excel) 02:18 Learn to Work with Pictures, Shapes & Other Objects in Excel 05:31 Quiz: Data Input in Excel 5 questions Challenge: Data Manipulation & Preparation in Excel 00:22 Solution: Data Manipulation & Preparation in Excel Preview 05:41 Summary: Key Excel Features to Impress & Save Time 00:58 Worksheet Navigation, Copying and Protecting 10 lectures • 45min Overview - Worksheet Navigation in Excel 01:07 Useful Excel Shortcuts for Navigation (Become Pro) 11:01 Copying, Moving & Hiding Worksheets 03:12 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports 03:01 Hide & Unhide, Insert, Adjust Columns & Rows in Excel 06:32 Copying and Pasting Data (Hidden Excel Paste Features) 05:55 Protecting Excel Worksheets & Specific Ranges 08:44 Challenge: Update & Protect Excel Report 00:16 Solution: Update & Protect Excel Report 03:57 Quiz: Worksheet Navigation 5 questions Summary: Important Worksheet Features & Excel Shortcuts 01:40 Excel Formulas & What to be Aware of 12 lectures • 41min Overview - Excel Formulas & What to be Aware of 02:26 How Excel Calculates - Order of Precedence 05:19 Simple but Useful Excel Formulas 05:18 Essential Excel Rule (Don't Skip!) 02:31 Absolute and Relative Cell Referencing in Excel 06:19 Improve Clarity with Range Names 05:09 Referencing other Workbooks or Worksheets 03:54 Circular References & How to Locate Them 01:40 Combine Values From Two or More Cells to ONE Cell 03:44 Challenge: Allocate Yearly Value Based on Percentages 00:21 Solution: Allocate Yearly Value Based on Percentages 03:42 Quiz: Excel Formulas 5 questions Summary: Key Points when Writing Excel Formulas 00:57 Important Excel Functions (Everything you need to become Pro) 17 lectures • 1hr 30min Overview & Finding Excel Functions from Insert Function 05:07 Important! Working with Excel Functions 00:43 COUNT, COUNTA, COUNTBLANK 04:12 COUNT based on a Condition (COUNTIFS) 09:29 SUM & AVERAGE Functions in Excel 03:10 SUM by Criteria (SUMIFS, AVERAGEIFS) 06:17 MAX & MIN (MAXIFS & MINIFS) 04:06 Rounding Values (ROUND, ROUNDUP & ROUNDOWN) 05:31 Essential Excel Date Functions 09:21 Time Calculations in Excel - Total Time Worked Preview 06:00 Handling Excel Formula Errors 05:19 IF (Then, Else) Excel Function - Conditional Formulas 13:22 VLOOKUP Function - Lookup Values from Another Place 07:48 Challenge: How Good Are you with Excel Functions? 00:30 Solution: How Good Are you with Excel Functions? 07:11 NEW 365 Functions: FILTER, SORT, UNIQUE, XLOOKUP & More 00:54 Summary: Important Excel Functions 01:14 Data Cleaning and Management: Sorting, Filtering & Replacing Data 15 lectures • 1hr 6min Overview - Data Cleaning, Analysis & Management Tools in Excel Preview 02:27 Sort Data (Organize & Create Order) in Excel 07:05 Unsort Data to Revert to Original Order 01:49 Add Subtotals to Sorted Data 06:27 Filter Data to Extract What you Need 06:00 Delete Blank or Empty Rows in Excel 03:52 Fill Empty Cells in One Go (Become Pro) 03:26 Remove Duplicates to Get a Unique List in Excel 03:01 Excel Find Feature, Select & Emphasize 07:10 Find and Replace Values & Formatting (Hidden Excel Feature) 05:09 Why Excel Tables Can be a Time Saver (Become Pro) 10:21 Challenge: Data Management in Excel 00:24 Solution: Data Management Challenge in Excel 05:31 Summary: Tools for Organizing, Cleaning & Managing Data in Excel 01:01 Special Message - You've Got This! 02:14 Formatting including Conditional & Number Formatting in Excel 10 lectures • 37min Overview - All About Formatting Preview 01:29 Excel Formatting Tips - Alignment, Borders & More 05:27 Better Than Merge (Become Pro) 03:24 Justify Text Length (Hidden Excel Feature) 02:37 Excel Number Formatting Options (& Special Formatting) 03:39 Excel Conditional Formatting (Top Bottom Analysis & More) Preview 06:20 Icons & Data Bars with Conditional Formatting in Excel 06:39 Quiz: Excel Formatting 4 questions Challenge: Format Excel Report 00:23 Solution: Format Excel Report Challenge 06:45 Summary: Useful Excel Formatting Tools 00:36 Printing Excel Files & Saving as PDF 9 lectures • 27min Checklist Before Printing 02:10 Useful Printing Options in Excel 04:22 Adding Page Breaks & Printing Parts of a Sheet 04:22 Printing Large Datasets (Make sure you include this!) 03:47 Header & Footer in Excel (Logo, Page Numbers, etc.) 04:00 Saving Excel Files PDF & Printing Many Sheets 03:42 Challenge: Prepare Excel Report for Printing 00:22 Solution: Prepare Excel Report for Printing 03:20 Summary: Excel Printing Checklist 00:46 Workbook Design Principles 6 lectures • 28min Good Spreadsheet Design Principles (with Examples) 05:24 Adding Hyperlinks (Plus a Smart Workaround) in Excel 06:47 Define Cell Styles & Set Defaults (e.g. for Excel Tables) 05:36 Excel Workbook Theme & Color to Save Time 05:22 Use Your Own Excel Templates 04:05 Quiz: Workbook Design 5 questions Summary: Excel Workbook Design Principles 00:58 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, 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 site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques 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 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 passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f877b92edbef',m:'72b1d4636acfee7f57d4a9f4877af8f3fb187fd3-1627840875-1800-AQlasMMFSYtptA+iEBMfvUmZstCitdQuoSZLwUz4oq1QQ8UQmSnLltrVMtQ4vBBv8cetGfiFwgyc/nqrpLzawiPJjKL0HcFtxbo9lVmFil61CRKt1hWnDN77CjHt7dKKnvIx3sn+/ktyNmfMEbE8MgXOU185kJ+yZPMOt9RT3SOs',s:[0xdc2dee1696,0x68a853718d],}})();
  3. 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 Learn what's new in Excel for Microsoft 365 and how these changes impact the way you use Excel Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions Curated for the Udemy Business collection Requirements A computer or laptop with Windows (some techniques might not work on Mac) Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details) No prior Excel knowledge is needed. Willingness to learn. Let's do this! Description Learn Excel from Scratch OR become more CONFIDENT. ******************************* COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as: Excel's new XLOOKUP function New FILTER function in Excel SORT, SORTBY & UNIQUE functions In addition to the above, we also cover: Excel's new calculation engine and how older formulas are impacted What the Hash (#) sign is Compatibility and the at (@) sign you might see in your older files The new errors such as #SPILL and #CALC Data validation drop-down lists and dynamic array references If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section. ******************************* Looking to learn Microsoft Excel and improve your data analysis skills 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: Excel beginners, i.e. anyone looking to learn Excel from scratch 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 that to begin with. _________________________________________________ WHICH VERSION OF EXCEL IS USED IN THE COURSE? The course is applicable for Excel 2019, Excel 2016 & Excel for Microsoft 365 . Generally all features and formulas with exception of a few Excel charts (Histogram, Pareto, Treemap and Sunburst charts) will work on Excel 2010 & Excel 2013 . For the Power Query section, you'll have to install the free Excel Power Query add-in if you have Excel 2010 or Excel 2013 to be able to follow along. Other than this, the other features and formulas shown are valid for all Excel versions. _________________________________________________ ★★★★★ "Leila has an extraordinary way of breaking down complex formulas to understand how the mechanics actually work so you start to imagine on your own different combinations of formulas to solve complex questions.” Lisa ★★★★★ “The instructor's explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith ★★★★★ "It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great "hacks" for excel." Teo ★★★★★ "Lots of tips and techniques. Already using them in my own work!" Alison ★★★★★ "I am really enjoying the course, Leila is a great instructor. Every lesson I learn something useful to improve my day to day with excel." Alisa ________________________________________________ There's a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work. The course comes with lifetime access. Buy now. Watch anytime. Who this course is for: Business professionals looking to become more confident in Excel. Absolute beginners who want a structured, engaging, fun and practical Excel course. Excel users who want to discover & showcase new tips and tricks from Excel MVPs. Students who want to make sure they have the Excel knowledge to succeed at their next job. Data analysts looking to discover new tools to help them do more in less time. Show more Show less Featured review Michael Dickinson 65 courses 15 reviews Rating: 5.0 out of 5 a year 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. Show more Show less Course content 15 sections • 145 lectures • 11h 3m total length Expand all sections Before You Dive In 3 lectures • 4min How to Get the Most Out of This Course Preview 03:01 Download Course Files 01:10 Course Outline for Quick Reference 00:14 Quick Tour of Excel 4 lectures • 19min Excel Workbook, Worksheet, Cell Structure 08:43 Quick Tour of Excel - Ribbon & Quick Access Toolbar 03:45 Customizing the Excel Interface 06:00 Summary: Important Points to Remember (Terminology & Shortcuts) 00:58 Quiz: Excel Fundamentals 4 questions Data Input & Hidden Features to Save Time 16 lectures • 1hr 15min Overview - Data Input & Hidden Excel Features 01:40 Data Entry and Editing Excel Data 07:14 Basic Excel Formulas 09:26 Text to Speech (Hidden Excel Feature) 03:09 Correctly Input Dates and Time Stamps in Excel 04:25 Use Excel AutoFill To Do Your Work 03:56 Excel Flash Fill for Major Time Saving (Become Pro) 05:00 Custom Lists With AutoFill (Hidden Excel Feature) 02:30 Inputting & Editing Comments & Notes in Excel 08:13 Finding Excel Formulas & Input Cells with ONE Click (Become Pro) 03:59 Excel Data Validation to Reduce Time Checking Data Preview 11:04 Adding Tool Tips (Screen Tips in Excel) 02:18 Learn to Work with Pictures, Shapes & Other Objects in Excel 05:31 Quiz: Data Input in Excel 5 questions Challenge: Data Manipulation & Preparation in Excel 00:22 Solution: Data Manipulation & Preparation in Excel Preview 05:41 Summary: Key Excel Features to Impress & Save Time 00:58 Worksheet Navigation, Copying and Protecting 10 lectures • 45min Overview - Worksheet Navigation in Excel 01:07 Useful Excel Shortcuts for Navigation (Become Pro) 11:01 Copying, Moving & Hiding Worksheets 03:12 Freeze Panes (Lock Rows, Columns) & Split Screen for Long Excel Reports 03:01 Hide & Unhide, Insert, Adjust Columns & Rows in Excel 06:32 Copying and Pasting Data (Hidden Excel Paste Features) 05:55 Protecting Excel Worksheets & Specific Ranges 08:44 Challenge: Update & Protect Excel Report 00:16 Solution: Update & Protect Excel Report 03:57 Quiz: Worksheet Navigation 5 questions Summary: Important Worksheet Features & Excel Shortcuts 01:40 Excel Formulas & What to be Aware of 12 lectures • 41min Overview - Excel Formulas & What to be Aware of 02:26 How Excel Calculates - Order of Precedence 05:19 Simple but Useful Excel Formulas 05:18 Essential Excel Rule (Don't Skip!) 02:31 Absolute and Relative Cell Referencing in Excel 06:19 Improve Clarity with Range Names 05:09 Referencing other Workbooks or Worksheets 03:54 Circular References & How to Locate Them 01:40 Combine Values From Two or More Cells to ONE Cell 03:44 Challenge: Allocate Yearly Value Based on Percentages 00:21 Solution: Allocate Yearly Value Based on Percentages 03:42 Quiz: Excel Formulas 5 questions Summary: Key Points when Writing Excel Formulas 00:57 Important Excel Functions (Everything you need to become Pro) 17 lectures • 1hr 30min Overview & Finding Excel Functions from Insert Function 05:07 Important! Working with Excel Functions 00:43 COUNT, COUNTA, COUNTBLANK 04:12 COUNT based on a Condition (COUNTIFS) 09:29 SUM & AVERAGE Functions in Excel 03:10 SUM by Criteria (SUMIFS, AVERAGEIFS) 06:17 MAX & MIN (MAXIFS & MINIFS) 04:06 Rounding Values (ROUND, ROUNDUP & ROUNDOWN) 05:31 Essential Excel Date Functions 09:21 Time Calculations in Excel - Total Time Worked Preview 06:00 Handling Excel Formula Errors 05:19 IF (Then, Else) Excel Function - Conditional Formulas 13:22 VLOOKUP Function - Lookup Values from Another Place 07:48 Challenge: How Good Are you with Excel Functions? 00:30 Solution: How Good Are you with Excel Functions? 07:11 NEW 365 Functions: FILTER, SORT, UNIQUE, XLOOKUP & More 00:54 Summary: Important Excel Functions 01:14 Data Cleaning and Management: Sorting, Filtering & Replacing Data 15 lectures • 1hr 6min Overview - Data Cleaning, Analysis & Management Tools in Excel Preview 02:27 Sort Data (Organize & Create Order) in Excel 07:05 Unsort Data to Revert to Original Order 01:49 Add Subtotals to Sorted Data 06:27 Filter Data to Extract What you Need 06:00 Delete Blank or Empty Rows in Excel 03:52 Fill Empty Cells in One Go (Become Pro) 03:26 Remove Duplicates to Get a Unique List in Excel 03:01 Excel Find Feature, Select & Emphasize 07:10 Find and Replace Values & Formatting (Hidden Excel Feature) 05:09 Why Excel Tables Can be a Time Saver (Become Pro) 10:21 Challenge: Data Management in Excel 00:24 Solution: Data Management Challenge in Excel 05:31 Summary: Tools for Organizing, Cleaning & Managing Data in Excel 01:01 Special Message - You've Got This! 02:14 Formatting including Conditional & Number Formatting in Excel 10 lectures • 37min Overview - All About Formatting Preview 01:29 Excel Formatting Tips - Alignment, Borders & More 05:27 Better Than Merge (Become Pro) 03:24 Justify Text Length (Hidden Excel Feature) 02:37 Excel Number Formatting Options (& Special Formatting) 03:39 Excel Conditional Formatting (Top Bottom Analysis & More) Preview 06:20 Icons & Data Bars with Conditional Formatting in Excel 06:39 Quiz: Excel Formatting 4 questions Challenge: Format Excel Report 00:23 Solution: Format Excel Report Challenge 06:45 Summary: Useful Excel Formatting Tools 00:36 Printing Excel Files & Saving as PDF 9 lectures • 27min Checklist Before Printing 02:10 Useful Printing Options in Excel 04:22 Adding Page Breaks & Printing Parts of a Sheet 04:22 Printing Large Datasets (Make sure you include this!) 03:47 Header & Footer in Excel (Logo, Page Numbers, etc.) 04:00 Saving Excel Files PDF & Printing Many Sheets 03:42 Challenge: Prepare Excel Report for Printing 00:22 Solution: Prepare Excel Report for Printing 03:20 Summary: Excel Printing Checklist 00:46 Workbook Design Principles 6 lectures • 28min Good Spreadsheet Design Principles (with Examples) 05:24 Adding Hyperlinks (Plus a Smart Workaround) in Excel 06:47 Define Cell Styles & Set Defaults (e.g. for Excel Tables) 05:36 Excel Workbook Theme & Color to Save Time 05:22 Use Your Own Excel Templates 04:05 Quiz: Workbook Design 5 questions Summary: Excel Workbook Design Principles 00:58 5 more sections Instructor Leila Gharani Microsoft MVP, Bestselling Instructor 4.7 Instructor Rating 66,575 Reviews 214,882 Students 9 Courses Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, 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 site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques 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 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 passion is learning, sharing and solving difficult data analysis problems. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780f877b92edbef',m:'72b1d4636acfee7f57d4a9f4877af8f3fb187fd3-1627840875-1800-AQlasMMFSYtptA+iEBMfvUmZstCitdQuoSZLwUz4oq1QQ8UQmSnLltrVMtQ4vBBv8cetGfiFwgyc/nqrpLzawiPJjKL0HcFtxbo9lVmFil61CRKt1hWnDN77CjHt7dKKnvIx3sn+/ktyNmfMEbE8MgXOU185kJ+yZPMOt9RT3SOs',s:[0xdc2dee1696,0x68a853718d],}})();
  4. 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 Learn what's new in Excel for Microsoft 365 and how these changes impact the way you use Excel Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions Curated for the Udemy Business collection Requirements A computer or laptop with Windows (some techniques might not work on Mac) Microsoft Excel 2016, Excel 2019 or Microsoft 365 (You mostly follow along with ALL Excel versions though - see course description for more details) No prior Excel knowledge is needed. Willingness to learn. Let's do this! Description Learn Excel from Scratch OR become more CONFIDENT. ******************************* COURSE UPDATED to Include the BRAND NEW Excel Functions available in Microsoft 365 such as: Excel's new XLOOKUP function New FILTER function in Excel SORT, SORTBY & UNIQUE functions In addition to the above, we also cover: Excel's new calculation engine and how older formulas are impacted What the Hash (#) sign is Compatibility and the at (@) sign you might see in your older files The new errors such as #SPILL and #CALC Data validation drop-down lists and dynamic array references If you have Excel for Microsoft 365 and you'd like to discover how you can take advantage of these new functions, make sure you check out this new section. ******************************* Looking to learn Microsoft Excel and improve your data analysis skills 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: Excel beginners, i.e. anyone looking to learn Excel from scratch 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