Best Microsoft Courses

Find the best online Microsoft Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Microsoft Courses.

Microsoft PowerPoint From Beginner to Advanced

Go from Zero to Microsoft PowerPoint Presenter Extraordinaire. Downloadable Exercise file to Follow Along.

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 35368, Price: $99.99

Students: 35368, Price:  Paid

Material was recorded using Microsoft PowerPoint 2019 on a Windows machine, but is relevant to PowerPoint 2010, 2013 and 2016. MAC users, since the videos are recorded with the Windows version of Microsoft PowerPoint, the interface will be a bit different.

This Course Includes 3 Sections

  • Microsoft PowerPoint 101 - Introductory Level

  • Microsoft PowerPoint 102 - Intermediate/Advanced Level

  • Microsoft PowerPoint 103 - Tips and Tricks

Enroll now to go from beginning PowerPoint user to Advanced user. This course will take you through a comprehensive understanding of the most popular presentation tool on the market. As your instructor I will use my 20+ years of Microsoft Office training to guide you step by step as you further develop your skills in Microsoft PowerPoint. Even if you're a seasoned PowerPoint user you'll be amazed at the techniques and tools you'll pick up to help you become more productive and efficient in PowerPoint.

At completion of this course you will have mastered the most popular and sought after Microsoft PowerPoint tools and come away with confidence to complete many PowerPoint tasks with efficiency and grace. Below are just a few of the topics you will master:

  • Build and Deliver Effective PowerPoint Presentations

  • Integrate Data from other Microsoft Office Applications

  • Pick the Proper PowerPoint Slide Layouts for your Content

  • Animate PowerPoint Content without Distracting the Audience

  • Automate PowerPoint Formatting and Slide Layouts with Master Slides

  • and much, much more...

So, what are you waiting for, enroll now and take the next step in mastering Microsoft PowerPoint and go from PowerPoint Newb to PowerPoint Guru!

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 34335, Price: Free

Students: 34335, Price:  Free

During this introductory course on using Microsoft Excel 2010, we'll teach the basics of using Microsoft Excel 2010.

Your professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. You'll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.


The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

Intro to Access – Microsoft Access Basics for Beginners

Intimidated by Access? Microsoft Access Basics walks you through creating your first simple database from scratch.

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 33814, Price: Free

Students: 33814, Price:  Free

When you think about learning Microsoft Access do you feel overwhelmed or intimidated?

If so, you're in the right place. 

Microsoft Access Basics for Beginners is designed to get you started in Access by creating a very simple database from scratch. 

This is a very hands-on course where I'll walk you through it step-by-step. The lessons are short and easy to follow, and all of the steps are explained in plain English.

With this course, anyone can get started learning Access. It isn't going to make you pro, but after you finish this short course, if your boss starts talking about Queries, Forms or Reports, you'll know exactly what they're talking about. And you'll understand how to create one.

Click on into the course. I promise it'll be easier than you thought.

Microsoft Excel 2013 Course Beginners/ Intermediate Training

Learn to Master Microsoft Excel In Easy To Follow Step-By-Step Training Course. Comes With Extensive Working Files

Created by Infinite Skills - High Quality Training

"]

Students: 33594, Price: $49.99

Students: 33594, Price:  Paid

A Verifiable Certificate of Completion is presented to all students who undertake this Excel 2013 Training course.

In this Microsoft Excel 2013 training course, expert training provider InfiniteSkills takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel beginners video training.

You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.

By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.

Excellence in Excel! Create a dynamic block chart in Excel!

Excel by creating your own dynamic block chart in Excel. Discover advance dynamic chart displaying tactics in Excel!

Created by Nicky Wong - Data Analyst, Market Researcher, Data Visualizer!

"]

Students: 32883, Price: $19.99

Students: 32883, Price:  Paid

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Do you want to create those cool looking infographic block charts?
  3. Do you want to know a more impressive way to display data professionally?
  4. Do you want to see instantly the most value information by using a graph?
  5. Do you struggle with too much facts and tool less visuals?

If any of these are a yes, than this course is for you!

This course will teach you how to use Excel functions and create a useful block chart. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.

Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!

If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.

This course is active, and you have to do the exercises and follow along.

Yes you have to do something! I truly want to do it! Learning is 50% of the success! The other 50% is taking the necessary action to master what you learn. I will show you what I do and how you need to do it step by step. And I give you a challenge ACTION EXERCISE to challenge you to take action!

Why should I take this course? Your competitor has a bigger course!

I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.

What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!

There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.

I never succeeded in Excel, is this course suitable for me?

Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!

Just check it and test it out for a month!

To make it even better, I offer this course as 30 day money back. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.

Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.

Alright winner, it is time to take action! Click on “Take this course" and start making great pieces of Excel Furniture!

Beginner to Pro in PowerPoint: Complete PowerPoint Training

PowerPoint lessons that are easy to apply at work! Become the top PowerPoint user in your office. #1 PowerPoint training

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 32782, Price: $99.99

Students: 32782, Price:  Paid

** Complete PowerPoint training: Basic PowerPoint features, Slide design, Business presentation preparation, and more! **

Updated for: January 2021

Are you about to graduate from university and start looking for your first job?

Are you a young professional who wants to establish themselves at their new position?

Would you like to become your team's go-to person when it comes to creating important PowerPoint presentations?

If so, then this is the right course for you!

It certainly pays off to be able to create great-looking PowerPoint presentations from scratch:

  • Everyone will want to work with you

  • You will quickly make a good and lasting impression at work

  • Your work will be judged much more favorably

The instructor of the course has extensive experience with PowerPoint. His slides have been in front of some of the most influential executives in Europe. Learn how to organize your presentations in a professional manner, exactly like employees of Fortune100 companies do.

Beginner to Pro in PowerPoint: Complete PowerPoint Training is THE ONLY course that will teach you how to prepare professional business presentations that are identical to the ones that are delivered by major investment banks and consulting firms. It's a one-stop-shop for everything you need in order to create sophisticated presentations.

In the first part of the course, we will cover PowerPoint's basic tools. This makes the course appropriate for beginners and inexperienced users. Once we have done that, we will explore some advanced features, which are often neglected by average users. The third part of the course is a case study. We will go through the entire thought process that is necessary to create a well-structured company presentation. And then, we'll create the actual presentation. You will gain first-hand experience on how to design great-looking PowerPoint slides!

Get excited! This course is an opportunity to beat the learning curve and stand out from the crowd.

Here's what you get with Beginner to Pro in PowerPoint: Complete PowerPoint Training:

  • An Introduction to PowerPoint's basic tools

  • Advanced PowerPoint features that will allow you to stand out

  • The Kinemax (a company operating in the cinema sector) Case Study: a complete company presentation built from scratch

  • Over 200 pages of supporting PDF materials

In addition to that you will receive:

  • Personal contact with the course tutor

  • Life-time access to all course materials, including future updates

  • A PDF file containing maps and shapes, which are not native to PowerPoint

  • Well organized materials that will have an instant impact on your work

By taking this course you will have every chance to:

  • Be confirmed after an internship

  • Secure a promotion

  • Establish yourself within your team

  • Impress your clients

As always, you have nothing to lose, because the course comes with a complete 30 days money-back-in-full Udemy guarantee. In case you don't like the course, you click one button and you will be refunded immediately (no questions asked). Simple as that.

Take the course now and become a true PowerPoint professional!

Microsoft Excel Pivot Tables – Master Excel Pivot Tables!

Excel with Microsoft Excel Pivot Tables & Data Analysis - Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 32511, Price: $94.99

Students: 32511, Price:  Paid

You’re Just Seconds Away From Leveraging Excel & Pivot Tables That Will Make It Possible For YOU To:

  1. Increase your Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

**** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ****

>> UPDATED APRIL 2020 with several Homework practice activities to increase your skills and an Assignment!

----------------------------------------

What some of the thousands of students who have viewed this tutorial have said...

"The course was fantastic! I had quite a few jaw-dropping moments!!" - Tan - Livingston

"I am one of the more advanced users in our organization but I have realized that I knew next to nothing" Jocelyn - Melbourne

"Not a question but just wanted to say in the space of 9 minutes I've learnt a lot." Richard - London

"Wow! No question, just wow! Amazing!" John - Hamburg

"Simply awesome, with in an hour I found myself a Pivot expert" - Natalie - Boston

----------------------------------------

No matter if you are a Beginner or an Advanced user of Excel,  you are sure to benefit from this quick course which goes through the most important tools that are available in an Excel Pivot Table.  The course is  designed for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Office 365.

In no time you will be able to analyze lots  of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management &  prospective employers.

What you will learn?

  • How to set up your data and create an Excel Pivot Table in less than 3 minutes which will increase your efficiency!

  • How to put your key business metrics like Year to Date Sales, Monthly Variations and Top 10 Customers in an interactive Excel Pivot Table, taking your analytical skills to another level!

  • How to create an Interactive Excel Dashboard with Slicers & Pivot Charts that will WOW your boss and get you noticed by top Management!

  • Pivot Table tips & special Bonus material that you can keep and use to become better at Excel straight away which will skyrocket your personal development!

Scroll down this page to view the full Course Curriculum...

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Microsoft Excel 2016 Beginners & Intermediate Excel Training

Excel 2016 for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 30720, Price: $129.99

Students: 30720, Price:  Paid

Do you want to learn how to work with Excel 2016?

Even if you don’t have any prior experience?

If so, then this is the right course for you!

A Verifiable Certificate of Completion is presented to all students who complete this course.

Microsoft Excel 2016 is here, and it promises to be one of the greatest versions that we’ve seen so far.

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

If you want to become any of the following…

  • Executive Assistant

  • Office Clerk

  • Auditor

  • Accountant

  • Business Analyst

  • Financial Analyst

  • Credit Counselor

  • Sales Representative

  • Sales Manager

  • Financial Manager

  • Investment Banker

  • Real Estate Agent

  • Market Research Analyst

  • Financial Advisor

  • Business Operations Manager

  • Entrepreneur 

  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2016. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2016 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

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

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive Case Studies that will help you reinforce everything that you’ve learned

  • 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

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Bill Gates knows how to work with Excel

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Enrol today and let's start this journey together!

Pivot Tables, Power Pivot Tables, Power Query & Power BI

5 Course Excel Bundle: Microsoft Excel, Pivot Tables, Power Pivot Tables, Power Query & Power BI (Excel 2007-2019, O365)

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 30410, Price: $119.99

Students: 30410, Price:  Paid

You’re Just Seconds Away From Leveraging Microsoft Excel, Pivot Tables, Power Pivot, Power Query & Microsoft Power BI That Will Make It Possible For YOU To:

  1. Increase your Microsoft Excel & Pivot Table SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Pivot Tables with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

Listen to a few of our satisfied students who have taken this TOP-RATED Microsoft Excel course and advanced their Excel skills in days:

          "This course is tremendously comprehensive. The best part is that the  course is served in small bite-sized pieces that are easily digested.  A teaching course that  doubles as a reference guide. Definitely worth your time and money" - James

           "I was a Pivot Table novice when I started this course but with just a few lessons I was becoming more and more confident at using Pivot Tables.  John's teaching style is engaging, his voice is clear and the videos are first class and very in-depth, as he covers ALL the Pivot Table features.

There are plenty of exercise files and real life homework activities to practice the skills learned. I can now say with confidence that I am an advanced Excel & Pivot Table user to my colleagues, boss and future employers.

Thanks John for this comprehensive course and I am forever indebted to you. Keep up the awesome work you do." - Sebastian

----------------------------------------         

***** ADDED BONUS: This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! *****

***** GET 5 MICROSOFT EXCEL COURSES FOR THE PRICE OF 1 *****

> UPDATED APRIL 2020: New Excel Pivot Tables Features For Excel 2019 & Office 365.

> BONUS EXCEL COURSE: 333 Excel Keyboard Shortcuts with Free PDF Cheat Sheet for Windows & Mac

> 7 COURSE BONUSES: Excel PDF Cheat Sheets, 101 Ready Made Excel Templates, plus MORE!!!
---------------------------------------- 

YOU GET THE FOLLOWING 5 COURSES WITH THIS EXCEL BUNDLE:

----------------------------------------

COURSE #1 - EXCEL PIVOT TABLES

----------------------------------------

If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

This is the most comprehensive Excel Pivot Table online course ever made which has over 250 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

In no time you will be able to analyze lots  of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management &  prospective employers.  The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!  

There are 17 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies. 

Here are the main topics that we will cover in this course:

EXCEL PIVOT TABLES COURSE:

  1. CUSTOMIZE   YOUR PIVOT TABLE       

  2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

  3. VALUE FIELD SETTINGS > SHOW VALUES AS

  4. GROUPING

  5. SORTING

  6. FILTERING

  7. SLICERS

  8. CALCULATED FIELDS & ITEMS

  9. PIVOT CHARTS

  10. CONDITIONAL FORMATTING

  11. GETPIVOTDATA Formula

  12. MACROS       

  13. DATA MANAGEMENT       

  14. BONUS VIDEOS       

  15. NEW EXCEL 2013 PIVOT TABLE FEATURES       

  16. NEW EXCEL 2016 PIVOT TABLE FEATURES

  17. NEW EXCEL 2019 & OFFICE 365 PIVOT TABLE FEATURES   

----------------------------------------

COURSE #2 - EXCEL POWER PIVOT & DAX FORMULAS

----------------------------------------

Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.

In a nutshell, Power Pivot allows you to use multiple data sources for analysis. So it is a Pivot Table on steroids, meaning it can handle more data and create more powerful calculations using Measures & DAX Formulas.

Power Pivot gives you the power to work with large sets of data that are OVER 1 millions rows!!!

You can import, consolidate and create relationships from your data and perform enhanced analysis. The beautiful thing with Power Pivot is it allows you to work on Big Data with NO limitations.

Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access and analyzing these all into one awesome Pivot Table!

This course will introduce you to the key concepts of getting started with Power Pivot and it's various features for enhanced calculations, so you will be confident & comfortable in using Power Pivot on your data.

Here are the main topics that we will cover in this course:

EXCEL POWER PIVOT & DAX COURSE:

  1. IMPORT/LOAD DATA

  2. TABLE RELATIONSHIPS

  3. PIVOT TABLES & SLICERS

  4. INTRO TO DAX FORMULAS

  5. MEASURES & CALCULATED COLUMNS

----------------------------------------

COURSE #3 - EXCEL POWER QUERY

----------------------------------------

This is the Ultimate Microsoft Excel Data Cleansing course which has over 60 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. 

The course is designed for Excel 2007, 2010, 2013, 2016 or 2019 and Office 365.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers! 

The course is just over 4 hours long so you can become an awesome analyst and advanced Excel user within 1 day! 

In the first part of the course you will learn the various "Data Cleansing" techniques using Power Query or Get & Transform - as its name changed in Excel 2019 and Office 365.  We will show you how to:

EXCEL POWER QUERY - PART 1

  1. Clean & transform lots of data quickly

  2. Import data from various external sources, folders & Excel workbooks

  3. Consolidate data with ease

  4. Sort & Filter data

  5. Merge data

  6. Join data

  7. Data shaping & flat files

  8. Auto cleanup your data

  9. M Functions

In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:

EXCEL POWER QUERY - PART 2

  1. Text Function

  2. Logical and Lookup Functions

  3. Text to Columns

  4. Find & Remove Duplicates

  5. Conditional Formatting

  6. Find & Replace

  7. Go to Special

  8. Sort & Filter

----------------------------------------

COURSE #4 - MICROSOFT POWER BI

----------------------------------------

If you want to get better at Microsoft Power BI so you get a better paying job or just get answers & insights from your data FAST with Power BI Dashboards, then you are in the right place!

No matter if you are an Power BI Beginner or NEVER USED POWER BI before, you are sure to benefit from this quick course which goes through the MUST KNOW Power BI features.

You will be able to master Power BI straight away the following (in just 90 minutes) with the following Sections:

  1. Introduction to Power BI

  2. Creating a Power BI Dashboard

  3. Advanced Power BI Dashboard with Real Live Data

----------------------------------------

COURSE #5 - 333 EXCEL KEYBOARD SHORTCUTS

----------------------------------------

This is the most comprehensive Excel Keyboard Shortcuts course ever made which has 333 short and precise video tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single Excel shortcut that is available inside Microsoft Excel.  The course is designed for Excel 2007, 2010, 2013, 2016, 2019 and Office 365.

If you learn only 5 Excel keyboard shortcuts and apply them each day, you will SAVE HOURS each week, which means you can go home early for once!

There are 15 different modules so you can work on your weaknesses and enhance your strengths as well as practice files, quizzes and a FREE PDF Cheat Sheet listing all 333 Excel Keyboard Shortcuts for Windows & Mac that you can print off and keep. 

Here are the main keyboard shortcut topics that we will cover in this course:

333 EXCEL KEYBOARD SHORTCUTS VIDEO COURSE:

  1. Cell Formatting

  2. Drag & Drop

  3. Formulas & Functions

  4. Frequent  shortcuts

  5. Function Key   

  6. Making selections

  7. Ribbon Tab

  8. Cell Navigation

  9. Inside Ribbon 

  10. Macros & VBA

  11. Pivot Tables 

  12. Power BI 

  13. Power Pivot

  14. Other Shortcuts   

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including over 250+ downloadable Excel workbooks, Quizzes, Assignments, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

Advanced Excel – Top Excel Tips & Formulas

Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress (Excel 2010)

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 30028, Price: $124.99

Students: 30028, Price:  Paid

If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you!

The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - This is How:

  • Use my top 10 tips to save time

  • Learn the top 10 formulas for quick and dynamic analysis

This course includes a detailed downloadable PDF of the top 10 Tips & Formulas - together over 90 pages! Now you can READ, WATCH or do BOTH!

The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

In Their Own Words:

Carlo says: "Excellent course featuring loads of easily understood content. It helped me become very competent and comfortable with pivot tables along with a host of other functionality. It's easily understood and also easy to follow. Instructor speaks clearly and explains things well, very helpful so the information is easily retained."

Sahar says: "Very very helpful tips. Anyone who uses Excel should learns these to let them get more benefits of the embedded functionalities."

Steven says: "Well explained, excellent material and topics. Definitely very helpful for my everyday work."

Advanced Excel skills are highly relevant
in business
. No matter which role you’re currently in or you’re planning to
take on. Whether you’ll be in Finance, consulting, IT, in project management,
your advanced Excel skills will set you apart from the competition.

What is the difference between an Advanced Excel and Average Excel user?

An advanced Microsoft Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation.  Advanced Excel users, always find the optimal solution for every task, and they find it fast!

What differentiates this Microsoft Excel course from the others?

The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.

Differentiation factor #1

Focus - The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel. 

Differentiation factor #2

Learn by doing - This Advanced Microsoft Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Excel Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.

Differentiation factor #3

Engaging - I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.

Summary

My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Take this course to get a head start!

Microsoft Access Complete Beginner to Advanced

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 27939, Price: $89.99

Students: 27939, Price:  Paid

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, and 2016

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

Learn Excel in 60 Minutes: Using Real Company Data

Filtering, SUMIFS, Pivot Tables, Conditional Formatting

Created by Tony Li - Hotel Manager

"]

Students: 27041, Price: Free

Students: 27041, Price:  Free

Use Excel to organize a real company's accounting and customer data. Then apply key practices in data analytics to draw insights from the data. 

This course is very straightforward and targets people that want to pick up Excel as quickly as possible. Keep in mind that this course may not be for everyone because we move fast. Video tutorials are also done on a Mac, and it may be a little different on a Windows PC. 

You are not required to have any prior experience with Excel, but there will be some knowledge gaps if you are 100% unfamiliar with it. In any case, we have structured the course so that you can  easily follow along, but we expect students to be resourceful (i.e. Google) to fill in any gaps. 

Excel tools you will learn: Pivot Tables, SUMIFS, COUNTIFS, AVERAGEIFS, filtering, conditional formatting, copying formulas, using dollar signs, and more!

Microsoft Word 2016 Learn to Become a Master

An easy way to learn Office Automation Tool

Created by Mehmood Shaikh - Web Developer & Udemy Instructor

"]

Students: 26814, Price: Free

Students: 26814, Price:  Free

This video tutorial series is a complete solution for Microsoft Word 2016, design for all types of users includes concepts from Beginner level, Intermediate level and expert level. We have covered almost all the topics of M S Word 2016. An in depth analysis and discussion is provided on each and every topic of M S Word 2016 starting from beginning to end.

Beginners Guide to Microsoft Excel Pivot Tables

Pivot Tables separate beginners from intermediates and allow you to delve deep into your data like no other tool can!

Created by Jed Guinto - ~445,000 Enrolments, ~185,000 Students, ~12,000 Reviews

"]

Students: 26600, Price: $19.99

Students: 26600, Price:  Paid

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. 

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.


WHAT YOU’LL LEARN IN THIS COURSE

Pivot Tables are extremely powerful analytic tools available in Microsoft Excel. I shall share an example of it's use using my favorite lunch time chocolate snack, M&M's!

If you don't know what M&M's, firstly you haven't lived, and second, they're awesome chocolates that come in little bite size forms in a variety of colors. So imagine someone gives you 100 M&M's. It's your job to sort them by color, by type and by size. Obviously, this will take a long time as you have to sift through the M&M's one by one. However, imagine you had some magical tool that will instantly sort the M&M's however you like. By type....No worries! By colour....even easier! 

Pivot Tables sort, group and summarize information similar to sorting M&M's by colour, size or shape. It's so easy to use and even easier to learn! In this course I'll teach you how to setup your data, how to create your first pivot, apply the different types of parameters using the pivot module, change data sources, refresh links and much more. 

So what are you waiting for, sign up today!


ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students and over 17,000 students for this course alone
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews and over 1,000 Reviews for this course
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.


TESTIMONIALS

Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman - Extremely knowledgeable and clear on instructions.

E Frank - Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach.

A complete guide to Microsoft Word 2013

Learn the essential as well as the advanced features in Microsoft Word 2013 in an easy and compelling way.

Created by Parallel Learning - When you know better, You Do better !!

"]

Students: 26239, Price: $19.99

Students: 26239, Price:  Paid

Are you a beginner trying to come to grip with this amazing tool or are you an everyday user who wants to learn to use this tool effectively and efficiently to save time?

If your answer is yes to either of the questions then this course is what you have been looking for!

What will you learn

Microsoft word 2013 is a powerful application which allows you to make impressive documents using its various features which are thoroughly explained in the course, giving you a very clear understanding of its use and implementations. 

Some of the features covered in the course are:

  • Applying style
  • Creating tables in word
  • Creating Hyperlinks
  • Inserting Smart Art
  • Applying themes for a document
  • Adding cover-page
  • Password protection
  • Applying watermark 

The course is covered in an easy and lucid language, making it easier to understand the concepts, at the same time the exercise links are attached with the course which will allow you to go in tandem with the instructor and making sure that the topic is understood thoroughly. 

So what are you waiting for take this course and see yourself work more efficiently than ever!

 

Introduction to Microsoft Excel VBA

Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 24816, Price: $94.99

Students: 24816, Price:  Paid

Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.

Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. I've been teaching Excel for 15+ years and have had loads of questions from those that have taken the dive into learning Excel VBA. Where should I start? What do I need to know? What's a variable? Enroll in this course and I'll share the knowledge and experience I've gained working with Excel VBA.

WHAT YOU'LL LEARN

  • Fundamentals of Excel VBA
  • Proper Syntax Writing VBA Code
  • Excel Object Structure to Effectively Communicate with Excel
  • Working with the Most Common VBA Objects in Excel
  • Automate Routine Microsoft Excel Tasks
  • And More....

EXERCISE FILES AND QA

As you go through the video lectures you can download the exercise files, found within each section. Use the exercise files to practice the concepts you will be learning.

The course contains a QA section where you can interact with me and ask any questions as you develop your VBA skills.

ENROLL NOW

As you participate in this introductory Excel VBA course you will build the knowledge and confidence to automate your experience in Excel, saving you time and money.

Microsoft Word 2016 for Everyone

A Microsoft Word 2016 Course for Recharging Your Career and Resume

Created by Prof. K - Technology Professional, Online Instructor

"]

Students: 24396, Price: $19.99

Students: 24396, Price:  Paid

This course provides a comprehensive tutorial on using Microsoft Word 2016, whether you are a student, a business user or in a corporate environment.  Speed learn Word 2016 from start to finish learning Microsoft Word from the basics to the advanced features.

This course is expertly designed for new users to get a great start while helping more experienced users fill in any gaps in their knowledge. You enjoy more than 50 expert video tutorials clearly showing you how to use Microsoft Word 2016.

Learn what's new in Microsoft Word 2016. Get up to date in order to be a true Word power user.

This Word 2016 course will renew your confidence and recharge your career and resume. This course gives you everything you need to know about Microsoft Word 2016 for personal use or running your own business.

The self-learning format allows you to watch a short video tutorial and follow along using your Microsoft Word 2016 program. You'll have a lifetime of access to the course allowing you to revisit and learn at your own schedule.

Now you can become a master at using one of the world's most popular computer applications – Microsoft Word 2016.

Microsoft Excel VBA for Beginners – Learn VBA Step by Step

Serious about learning VBA for Excel? This course makes learning VBA easy. Jump in and master Microsoft Excel VBA today!

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 24223, Price: $94.99

Students: 24223, Price:  Paid

Welcome to the Excel VBA Programming Course for Beginners. If you need to learn how to program VBA for your job or for yourself, this course was designed for you!

You'll start with the very basics of understanding what VBA is and what it does. You'll learn how to install VBA and record your first macro. Then, you'll progress to learning all of the essential terminology as you create your own functional VBA modules. By the end of this course, you'll be able to create your own user forms that other users can interact with and enter data into, and you'll be able to troubleshoot and debug your code, make it run faster, and even create your own custom Excel functions.

The beauty of VBA is that when you learn to master it, you can program Excel to do the work for you.

Using VBA, you can save a ton of time for your organization by automating repetitive and tedious tasks.

VBA isn't exactly easy, but it's one of the simplest and easiest to learn programming languages. It's like the gateway drug that gets you hooked on programming. And in this course, I'll walk you through the initial learning curve to give you a solid foundation from which to launch your programming skills.

This is a very detailed course and you will walk away with a vastly expanded vocabulary and a full toolbox of VBA programming skills.

The truth is, you could  teach yourself VBA using free articles and videos on the internet. The challenge is that VBA can be hard to learn without the right info and the right examples. It's easy to waste a lot of time learning things that aren't useful in the real world. By following this course, you'll get clear, step-by-step guidance along a relevant and valuable learning path to master the essentials of Excel VBA.

I have a lot of personal experience learning and using VBA as an engineer and I'm very excited to pass that knowledge on to you! Ever since my days as a college tutor, I've loved teaching and helping people learn challenging subjects. So, if you're ready to learn how to start programming in Excel VBA, I'm excited to show you how!

Thanks for checking out the course and I'll see you in the first lesson.

By the way, did I mention that Udemy has a 30-day money back guarantee? That's right. You can take the whole course, and if in those first 30 days you don't feel like you're actively getting better at using VBA, you can get a full refund. So, you really have nothing to lose. Dive in and start learning Excel VBA today!

Excel with Top Microsoft Excel Hacks

Learn these Hidden Excel Gems to Become an Excel Master

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 23339, Price: $19.99

Students: 23339, Price:  Paid

Unleash the Full Power of Microsoft Excel

Wow! How did you do that? This is something you're going to hear over and over again from your boss and co-workers as you apply the features you'll master as you participate in this course.

Microsoft Excel users use only a small percentage of what the application is really capable of. But, hidden within Excel are loads of lesser known Excel Productivity Hacks that will make your Excel experience more efficient and fun. I've been teaching Microsoft Excel since the '97 version of the Microsoft Office Suite. Join me in this course and I will share with you some of the tips and tricks that I have picked up along the way as I have helped others become Excel Guru's.

I have kept each video lecture short and to the point, about 2-3 minutes each. I created this course back in Feb. 2016. Over the next several months I have updated the course with more quick tips on working with Excel. Keep an eye on the course as I will continue to add more Excel hacks throughout the lifetime of the course. The course is recorded using Excel 2016, but Excel 2007, 2010,  2013 or 2016 will work in order to follow along.

Towards the beginning of the video lectures is an exercise file that you can download and use to practice the concepts taught during each video lecture. Also, jump into the course discussion board and participate by asking questions or commenting on how awesome this course is. I will also be participating in the discussion board offering more Excel resources and answering any questions you may have.

Enroll now and start learning the secrets of Microsoft Excel and begin to WOW your boss and co-workers today.

Excel Essentials for the Real World (Complete Excel Course)

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

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 23289, Price: $129.99

Students: 23289, Price:  Paid

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.

Excel Data Validation For beginners

Eliminate bad data by controlling the inputted data on your workbook!

Created by Abdelrahman Abdou - Founder|ExcelBonanza.com|20000+ Students|164 Countries

"]

Students: 23212, Price: Free

Students: 23212, Price:  Free

This course teaches students how to use the Data Validation feature in Excel to create rules that can control the inputs to Excel Workbooks.

This helps users eliminate bad data inputted by other people.

Students will learn how to controls numbers such as Integers and Decimals inputted by other users.

Students will learn techniques for creating data validation lists to restrict inputs to a list of values.

Students will learn how to apply date and time controls to restrict date and time inputs on their workbooks.

Students will learn how to apply text controls to control text inputs on their workbooks.

Excel Charts – Visualization Secrets for Impressive Charts

Gain Highly Advanced Excel Skills to Create Impressive Excel Graphs for your Management Reports (Excel 2010)

Created by Leila Gharani - Microsoft MVP, Bestselling Instructor

"]

Students: 22678, Price: $89.99

Students: 22678, Price:  Paid

Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! 

Significantly Improve your Reports by using Advanced Excel Graph Techniques. 

This Course Includes:

  • Downloadable Workbook to follow the demonstrations (and use the charts as your templates).

  • Downloadable Exercise Book (answers included).

  • Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training.

If you use Excel to generate reports and graphs, my
hands-on Excel training provides you with an extremely advanced toolkit worth
of knowledge that will take the design of your Excel charts, tables and reports to the next
level. It will provide you with the best tricks to create dynamic charts.
It will save you tons of time of manually updating your Excel graphs on a monthly
basis. The visualization techniques introduce you to some unusual methods to
handle and create charts which will enhance readability of your reports as well
as impress your readers. 

Lauren says: "I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts."

John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken"

Paul says: "Course is clear, to the point and very dynamic. Excellent!"

Types of Excel Charts & Excel Graphs are presented:

The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information.

If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel.

Demonstration will be done using Excel 2010, but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new “methods” of doing things which you can do no matter which Excel version you have.

Why this course is different to other Excel courses:

I will not only demonstrate to you, but you
will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the
techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first).

I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible.

I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that.

This course is split to 5 major parts:

  1. Methods to effectively communicate and present data trends – In this section I will also provide you with a crash course in best practices for table and graph design.

  2. Behind the scenes secrets of dynamic charts in Excel, where I introduce you to key functions you need to use to never manually update your Excel charts again –The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables.

  3. Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most.

  4. New ways to compare performance: as in Actual data versus Budget, forecasts and previous year

  5. Effective Chart Combinations that are pivotal to management reports

This is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them!

How to use Vlookup in Excel – A simplest tutorial

Learn Lookup functionality in just 50 minutes

Created by Nurture Tech Academy - Microsoft Office Specialist

"]

Students: 22351, Price: $19.99

Students: 22351, Price:  Paid

In this lookup functionality video course, Nurture Tech Academy introduces you to the most simplest way to understand Vlookup and other lookup functions.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with understanding references and how excel reacts on the same. Then it will show you how to use Vlookup and then gradually moves to the next level in lookup functionality like Vlookup with False, Vlookup with True, Vlookup with if function, Hlookup, Lookup and ultimately combines Index & Match.

By the completion of this online training course, you will be fully versed, and capable of using any function in lookup functionality in Microsoft Excel 2007/2010/2013 in a commercial Environment.

Microsoft PowerPoint Essentials|PowerPoint 2016 Presentation

Became advanced user today! Hack 2010, 2013, 2016, PowerPint 2019, Office 365 |Presentation from beginner to advance

Created by Denis Kulikov - Enterpreneur, dancer, teacher, scientist, rapper and IDK

"]

Students: 22313, Price: $89.99

Students: 22313, Price:  Paid

****COURSE WERE UPDATED (06.12.20) - Based on Review

*** This "Microsoft PowerPoint: Essentials - Let's do your first presentation" course access includes project files, quizzes & homework exercises, Power Point Presentation with all slides from course, 1-on-1 instructor support, LIFETIME access and a money-back guarantee!***

__________

MICROSOFT POWERPOINT: ESSENTIALS - LET'S DO YOUR FIRST PRESENTATION COURSE DESCRIPTION:

Microsoft PowerPoint nowadays is an absolutely essential tools for life. The truth is that, Microsoft PowerPoint is a really powerful, and dynamic presentation performing software . Absolutely everyone could get their life on a new level after studying this Microsoft Power Point: Essentials.. Let's do your first presentation course and applying this knowledge in their lives.

This Microsoft Power Point: Essentials.. Let's do your first presentation provides you with all the tools and instruments which you need, to understand this software.

I am sure it is not so important to remember each of the functions, more essential is how to understand how Microsoft PowerPoint "thinks" and know where you could find explanation of features which do you need.

Thats why my Microsoft Power Point: Essentials.. Let's do your first presentation consists of very individual, deep and simple explanations of each of the features, which I placed separately. In this case if you forget some aspects you could come back to my video course and refresh all information in your memory.

__________

We will be raising such topics as:

- What type of Microsoft PowerPoint versions is exist

- How to save, export and share presentation in Microsoft PowerPoint

- Slide structure in Microsoft PowerPoint

- Structure of Interface in Microsoft PowerPoint

- How to work and Format Text in Microsoft PowerPoint

- How work with Insert Menu in Microsoft PowerPoint

- Different View modes in Microsoft PowerPoint

- How to work with Format Painter in Microsoft PowerPoint

- How to work with CTRL, Shift, ALT shortcuts in Microsoft PowerPoint

- How to Align Shapes in Microsoft PowerPoint in Microsoft PowerPoint

- How to group, Ungroup, Regroup objects in Microsoft PowerPoint

- How to work with Animation in Microsoft PowerPoint

- How to work with Transitions in Microsoft PowerPoint

- How to export presentation (in PDF, MOV and etc.) in Microsoft PowerPoint

And more...

You could use next Software to learn this course:

Windows:

  • Microsoft PowerPoint 2007

  • Microsoft PowerPoint 2010

  • Microsoft PowerPoint 2013

  • Microsoft PowerPoint 2016

  • Microsoft PowerPoint 2019

  • Microsoft PowerPoint 2020

Macbook:

  • Microsoft PowerPoint 2011

  • Microsoft PowerPoint 2016

And all upper Microsoft PowerPoint version of software

Just check a couple of reviews on my previous courses:

  • Amazing course!! There's so much to do with Excel that i couldnt imagine. Now im able to use it not only better in my work, but also for personal stuffs, even for gaming! Thanks a lot!!!!!

  • Nice lectures.I have learned amazing stuff about excel.

  • IT WAS A GOOD EXPERIENCE FOR ME AND IT HELPED ME IN MANY WAYS.

  • it's very good , i benefit from every minute in this course

    and intructor is be graet

    thank to him

My suggestion to you..

If you really want to understand how to create your first presentations in PowerPoint.... Just try this excellent course...

__________

NOTE:

Microsoft PowerPoint: Essentials - Let's do your first presentation includes downloadable resources and project files, homework and course quizzes, lifetime access and a 30-day money-back guarantee.

This Microsoft PowerPoint: Essentials - Let's do your first presentation were created on Microsoft Excel for Macbook 2016

Excel Shortcuts, Excel Tips, Excel Tricks – Excel Skills!

Use simple Excel shortcuts to Excel at work, impress your boss, and Excel your income. Macros, Formulas, PivotTable Tips

Created by Billy Wigley - Microsoft Certified Trainer (MCT), MOS Excel Expert

"]

Students: 22117, Price: $64.99

Students: 22117, Price:  Paid

Do you use Microsoft Excel?

-Learn Excel Shortcuts, Tips and Tricks that will make you money (money moves)!

-What would it be like to create a chart by pressing one button?

-What would it be like to easily create a slicer controlled pivot table with a chart in just minutes?

ALERT! - This course is not meant to be completed! I am continuously adding lectures that quickly resolve issues professionals in my live seminars across the USA are having while using Excel in their daily work.

To ensure that you have all of the ingredients in place when using Excel it takes years of using the program before you learn all of these “Secrets of Excel."

You have taught me a few things that irritate you about Excel, (VLOOKUP, PivotTable, Conditional Formatting, Charts, Formulas), and I have developed this course full of Excel Shortcuts Tips and Tricks that will take years off your learning curve. You will be using Excel like a professional within seconds of viewing this course.

There's only 86,400 seconds in a day, and you can't make time, or save time – you can only spend it and invest it.

=================================================

Super easy to follow!

"If you have trouble with Excel, then this course makes it much easier to understand. The instructor is very knowledgeable and he makes it fun to learn."

==================================================

Billy Wigley Is #1 Excel Trainer

"Billy's Course is great for newcomers to excel and excel veterans alike that want to increase their knowledge, proficiency, and Skills!!! Billy is by far the most entertaining and knowledgeable Excel mentors I've had the privilege of learning from. I recommend his online course as a must for the aspiring excel guru, and I HIGHLY RECOMMEND trying to find one of his live lectures."

==================================================

You are an ACHIEVER. You KNOW what to do – Take This Course – and let's get started.

Excellence in Excel! Make any chart dynamic in Excel!

Excel dynamic charts, a more efficient why to create 1 chart that displays many values by pressing a button in Excel!

Created by Nicky Wong - Data Analyst, Market Researcher, Data Visualizer!

"]

Students: 21993, Price: $19.99

Students: 21993, Price:  Paid

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Do you want to place more charts in Excel only to notice there is too less space in the tab?
  3. Do you want to make your data more clear and reduce the clutter in your spreadsheet?

If so, this course is for you!

This course will teach you how to use Excel functions and create dynamic charts. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.

Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!

If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.

This course is active, and you have to do the exercises and follow along.

Why should I take this course? Your competitor has a bigger course!

I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.

What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!

There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.

I never succeeded in Excel, is this course suitable for me?

Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!

No risk to take a peak and try it out!

To make it even better, I offer this course as no risk. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.

Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.

Press "Take this course" now!

Alright winner, it is time to take action! Click on “Take this course" and start making great pieces of Excel Furniture!

Microsoft Excel 2016 Master Class: Beginner to Advanced

Quickly learn how use Excel 2016 the right way and make your life easier and more productive in our complete course!

Created by Bruce Myron - Productivity Specialist

"]

Students: 21606, Price: $139.99

Students: 21606, Price:  Paid

Have you always wanted to learn Microsoft Excel but you just don't know where to start?

Or maybe you have started, but you just don't know how to use some of the more advanced features of Excel.

Then the our complete Microsoft Excel 2016 Master Class: Beginner to Advanced is for You!

_________________________________________________________________________

Welcome To Microsoft Excel 2016 Master Class: Beginner to Advanced

⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses!

⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results!

⇉ You Get Over 103 Lectures and 8+ hours of premium content

⇉ Watch the Promo Video to see how you can Get Started Today!

_________________________________________________________________________

What do you get with this course?

  • Hours of easy-to-watch video lessons

  • Downloadable Resources

  • Practical activities

  • Instructor support if you have any questions

  • Community of students ready to help

What will you learn in this Microsoft Excel 2016 Master Class: Beginner to Advanced.

In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Excel course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Excel.

You'll start with an overview of the course and how to get started with Microsoft Excel.

You'll then learn the worksheet basics and some beginner excel strategies.

Once you understand the basics, you will learn about manipulating columns and rows, entering data, selecting cells and ranges, formulas, copying and moving, the fill handle, naming ranges, functions, formatting worksheet contents, table filters and keyboard shortcuts, and how to bring it all together. You will also learn about payment function and what if analysis, finding and fixing errors, more on working with tables, protecting your work, pivot tables, viewing large worksheets and multiple workbooks, and working with charts.

By the end of our course you will:

  • Understand how Excel works and the most efficient way to do most tasks.

  • Understand worksheet basics and learn keyboard shortcuts

  • Learn how to manipulate columns and rows.

  • Learn how to enter and edit different kinds of data: text, numbers, dates and symbols

  • Learn how to select cells and ranges and discover basic formulas

  • Save time copying and moving, and know how to use the fill handle

  • Create names for ranges or individual cells and work with SUM and many other functions

  • Format Excel worksheet content like a pro

  • Learn how to modify a large Excel file to prepare it for printing

  • Use Payment Function and What If Analysis

  • Work with tables, pivot tables, charts and protect your work

  • Find and fix errors easily

Ready to get started?

Once you enroll, we recommend students install Microsoft Excel on their computers to follow along.

_____

See What Current Students Are Saying About Our Course:

I really enjoyed the course! I feel that I've learned a lot more than I expected. The lectures were well-organized and clearly presented and with a lot of practice activities (quizzes, exercises). Time well spent, money well spent!”
-Veronica Caratanase

Great course :) Short videos on every topic make u feel focused on eat, easy language to understand and a lot of knowledge i recommend it :)”
-Tomasz Krugowiec

Course is excellent for those new to excel. I have picked up quite a few new tricks and learned some new things.”
-Jamie Shaw

_____

Who are your instructors?

We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Excel. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world.

Our goal is to show you the real world and practical ways to start working with Microsoft Excel today!

_________________________________________________________________________

With the right mindset, understanding, and application, you will instantly begin learning how to work with spreadsheets in Microsoft Excel.

When I learn something new I add it to the course - at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But it can be done!

I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

_________________________________________________________________________

It's time to take action!

Our happiness guarantee

This course includes a money back guarantee, so there is no risk to try it out. Sign up today, see if it's the right one for you.

Enroll now.

Sincerely,

Joe Parys and Bruce Myron.

Microsoft Excel – Basic Data Visualization in Excel

Learn how to make great data visualizations in Excel

Created by Sean J. Thompson - Analyst

"]

Students: 21361, Price: Free

Students: 21361, Price:  Free

Welcome and thanks for your interest in my course!

Learn and master the art of creating a well-designed data visualizations and basic data analysis in Excel in this wide-ranging course. Forget the same old default Excel graphs that are boring and without personality - you can do better than that! This course will help your to go beyond the basics of graphing and teach you how to design graphs with your intended audience in mind. Not only will you learn how to create great graphs in Excel, but you will also learn how to organize your data before graphing to make the process easier and more productive.

A few of the topics we will cover in this course include:

  • How to determine if your data is graph-worthy
  • How to organize your data prior to visualization
  • Using vlookups to enhance your datasets
  • Designing your graphs for your audience
  • Using your visualizations outside of Excel
  • and a few other surprises....

This course is mostly video based, but does include all of the Excel spreadsheets used throughout the course. Use these spreadsheets and documents as a resource after you complete the course. They are yours to keep and use as a reference in the future.

This course will allow you to use the Excel skills you already have and take them to the next level. This course was designed with you - the student in mind. My goal is for you to be able to implement the skills your learn in this course immediately once you have completed it.

I hope you enjoy the course and that your use the skills learned to enhance your skillset and wow your boss and coworkers!

- Sean

Excel Formulas & Functions – Find Answers in Your Excel Data

Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 21143, Price: $49.99

Students: 21143, Price:  Paid

Do you want to learn how to use Excel Formulas and Functions but find it all a bit overwhelming?

Do you need Excel to succeed at work, but wonder where to even start?

If so, you're in the right place. In this course I'm going to teach you how to use Excel Formulas and Functions without any tears or pulling your hair out.

I'm so confident that this course will increase your efficiency and understanding of Excel formulas and functions that I guarantee it! If you aren't 100% satisfied with ANYTHING that you've learned or you don't see the results in your work within 30 days of signing up, you get a FULL REFUND.

Why should you take this course?

  1. I make learning Excel as simple as possible. Excel can seem extremely complex and overwhelming at times. But I break every function down into simple, manageable steps. I also use easy, realistic examples that you can follow along with.

  2. I get right to the point in every lecture. I know you're busy so I don't waste a lot of time on tangents, personal stories or filler like many instructors do. If the lecture is about VLOOKUP, I'm going to get straight to teaching you how to use VLOOKUP so you can put it to use right away.


Who is this course for?

This course is designed for beginning or intermediate Excel learners who are new to using formulas and functions to make calculations in Excel. It is also appropriate for anyone who wants to learn to use functions but feels intimidated or overwhelmed.

What's included in the course?

  1. What is a formula? What is a function?

  2. The anatomy of a formula and how to create one.

  3. How to use the SUM function.

  4. How to use the AVERAGE and AVERAGEA functions.

  5. How to use the COUNT and COUNTA functions.

  6. How to use the IF function.

  7. How to use the SUMIF and SUMIFS functions.

  8. How to use the COUNT and COUNTIFS functions.

  9. How to use the popular VLOOKUP function.

  10. How to use RIGHT, LEFT and MID to sort data easily.

  11. A complete demonstration of how to use each function and what to use if for.

Thanks for taking the time to check out my course. I can't wait to help you take your Excel Formulas and Functions to the next level!

To learn more now, watch one of the FREE preview lectures.

Remember, If you aren't 100% satisfied with ANYTHING that you've learned or you don't see the results in your work within 30 days of signing up, get a FULL REFUND.

If you're ready to get started, click on the "Take This Course" button and in just a couple of hours you'll be amazed at what you can do with Excel.

Excel for beginners:( PowerPivot, PowerQuery,Macros,VBA,DAX)

Learn to Create spreadsheets , Formulas ,Functions,Tables ,Charts and input data

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 20932, Price: $89.99

Students: 20932, Price:  Paid

Microsoft Excel is a powerful tool essential for managing and presenting data
in today’s working environment. In this one day excel course,
you  will gain the knowledge and skills required  to create and edit worksheets, use formulas
and functions, sort and filter detail data visually, and present summary information
in a consumable and professional format.

A macro is a sequence of instructions that automates some aspect of Excel so that you can work more efficiently and with fewer Errors. Macros are written in VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft.

The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data.  You will learn how to use the DAX formula language to provide lookup abilities.

I will walk you through step-by-step how to use Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Also i will walks you through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures.

You will learn hands on real-world scenarios for working together with Power Query and Power Pivot.

What You Will Learn Include:

  •  What is Office 365

  • Setting up Office 365

  • Excel 2016 user interface

  • Exploring the Excel Ribbon 

  • Customizing the Quick Access Toolbar

  • Keeping Tabs on the Ribbon

  • Entering Data 

  • Opening a new workbook 

  • Entering Data in Excel

  • Basic Data entry

  • Entering Data with Autofill

  • Entering Date

  • Entering Time

  • Undo and Redo Changes

  • Adding Comments

  • Giving your worksheet a title

  • Saving your work

  • Creating Formulas and Functions 

  • Using formulas for arithmetic tasks

  • Re-using Formulas

  • Calculating YTD Profits

  • Calculating Percentage Change

  • Using Relative and Absolute Reference

  • Using RANK Function

  • STD Function

  • Small and Large Functions

  • Median Function

  • Count and counta functions

  • Formatting   
    Exploring Fonts

  • Adjusting Column Width and Row Height

  • Using Alignment  
    Designing Borders

  •  Formatting Numbers

  •  Conditional Formatting

  • Creating Tables

  • Inserting Shapes

  • What VBA is and why it is so incredibly useful

  • What  are Macros

  • Creating Macros using macro recorder

  • Creating macro manually from scratch

  • Editing Macros

  • Debugging Macros

  • How to write VBA code and execute it in Excel

  • How to make your macros work with workbooks, worksheets and the data on them

  • How to find and eliminate errors in your programs and make your macros run

  • Automation using macros.

  • Analyse the macro from the Developer tab or the View tab.

  • Examine the VBA window and VBA components.

  • Distinguish between absolute and relative references.

  • How to save workbook with macros

  • Create a module

  • Create procedure

  • Create a sub

  • Understand the difference between a module and sub

  • Run the code in a sub

  • Preparing queries

  • Cleansing data with Power Query

  • Enhancing queries

  • Creating a data model in Power Pivot

  • Building relationships

  • Creating Pivot Tables and Pivot Charts

  • Creating Lookups

  • Using DAX to link data

  • Creating data model

  • Creating relationship between data sources

  • Analyzing data with PivotTables and PivotCharts

  • Using Power Query with PowerPivot

  • Connecting  to a variety of data sources with Power BI

  • Create and publish reports to Power BI Service

  • Refreshing Data Source

  • Updating Queries

  • Using Conditional statements

  • Using quick and dynamic measures

  • Transforming data on connected datasets

  • After completing this course you would have gained useful and practical skills to enable you to confidently create spreadsheets  that you can apply formulas and functions to as well as create tables from the data within the spreadsheet and much more.