Best Free Microsoft Courses

Find the best online Free 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.

Useful Excel for Beginners

Learn the basics of Microsoft Excel and become an effective user

Created by Dinesh Natarajan Mohan - Sharing simple but effective solutions

"]

Students: 378433, Price: Free

      Welcome to the Useful Excel for Beginners course. 

     In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

Microsoft Excel Pivot Tables – The Beginner Course

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

Created by Matt Jackman - Digital Analytics and SEO Professional

"]

Students: 151181, Price: Free

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

  • How to create a Pivot Table
  • How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

Created by Mynda Treacy - Microsoft Excel MVP, Teaching 25,000+ Students

"]

Students: 131584, Price: Free

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was
incredibly informative, insightful and taught me a few tips and tricks
that will surely aid me in producing automated dashboards. Thank you for
sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

  • Design and Display Principles
  • Interactive Controls
  • Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.

Excel Quick Start Tutorial: 36 Minutes to Learn the Basics

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Created by Jeff Knowlton - Senior Executive. Data Scientist. Teacher.

"]

Students: 119237, Price: Free

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

FREE Microsoft Dynamics 365 For Beginners (Updated for 2021)

Learn the basics to become an Expert of Microsoft Dynamics 365 (CRM) Enterprise Solution and Boost Your Career Growth.

Created by Online CRM Training (3E Consulting Private Limited) - The Best &Most Affordable Microsoft Dynamics Training Online

"]

Students: 89230, Price: Free

***Updated the entire course to the latest version of Microsoft Dynamics 365 Customer Engagement (CRM)***

This Microsoft Dynamics 365 course has the highest numbers of students and positive reviews IN THE WORLD!
(Seriously, thank you so much for your Love :) )

If you are a Programmer or Business Analyst or Existing non-Microsoft Solutions Consultant or want to be a Dynamics 365 Consultant, this is the best course to start your learning journey to earn more.

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

HERE'S WHAT STUDENTS ARE SAYING:

"Overall, this course has been very helpful. I went from not even knowing what Microsoft CRM was to having a good basic understanding of the interface and features of the software. This course has definitely been worth doing and the instructor is great!" - Tyler Martin

"Before starting this course I never heard about Microsoft Dynamic 365 (CRM), one of my friend suggested me to just dirty your hands with MS Dynamic 365 (CRM). Actually I am coming development background so initially its look boring for me but after understanding about Dynamic 365 (CRM), I enjoyed this course very much. Looking forward to join another course. Thanks a lot Abhay. Great work." - Ram Thakkar

"As a complete beginner in this Software this has been very helpful and informative so far. Thank you!" - Aleksander Penev

"It is a very sweet lecture, despite being free. He took his time to explain every details you need to know about MS Dynamics. I am SugarCRM certified developer and willing to dive into MS Dynamics. I will Surely register for more of your courses in future. Thanks Abhay Sharma." - Aremu Habibullahi

"This was a very good course, I am just starting to use Dynamics CRM and this course was very helpful." - Orlando Sanders

"With no experiences in CRM, attending this course was really huge benefits. It guide you trough everything and I like the bonus in end of this course. I will recommended this course to anyone who would like to get into CRM." - Ahmad Hassan

"Thank you so much for creating the course. I enjoyed the learning about the CRM platform. I hope to take more courses in the future to further my career in ICT. Much appreciated" - Seraz Khan

And thousands of positive reviews...

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

Microsoft Dynamics 365 (CRM) is a Enterprise Business Solution by Microsoft.

It includes:

  • Microsoft Dynamics 365 For Sales to help companies improve Sales.

  • Microsoft Dynamics 365 For Customer Service to help companies improve their customer support & experience.'

  • Microsoft Dynamics 365 For Project Service Automation for managing end to end projects and

  • Microsoft Dynamics 365 For Field Service to manage Mobile workforce of the companies.

By the end of this course, you will have complete understanding of all four apps and much more... plus, this is a complete practical course.

Microsoft Dynamics 365 is one of the hottest and fastest growing business solution in the market.

The average salary of the Dynamics 365 Consultant is $85,000 - $100,000 Per Annum which will continue to grow...

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

HERE'S WHAT YOU WILL LEARN:

Module 1: Get Started With Microsoft Dynamics 365

  • What Is Microsoft Dynamics 365?

  • Microsoft Dynamics 365 Deployment Types

  • Microsoft Dynamics 365 Sign Up Process

  • Microsoft Dynamics 365 Application Navigation

Module 2: Microsoft Dynamics 365 For Sales Overview

  • Dynamics 365 For Sales Important Terms

  • Dynamics 365 For Sales Demo

Module 3: Microsoft Dynamics 365 For Customer Service Overview

  • Dynamics 365 For Customer Service Important Terms

  • Dynamics 365 For Customer Service Demo

Module 4: Microsoft Dynamics 365 For Project Service Automation (PSA) Overview

  • Dynamics 365 For Project Service Automation Important Terms

  • Dynamics 365 For Project Service Automation Demo

Module 5: Microsoft Dynamics 365 For Field Service Overview

  • Dynamics 365 For Field Service Important Terms

  • Dynamics 365 For Field Service Demo

Module 6: Microsoft Dynamics 365 Other Important Features

  • Dynamics 365 Records And Activities Creation

  • Dynamics 365 User Creation And Security Model

  • Dynamics 365 Settings And Administration

  • Dynamics 365 Customization

  • Dynamics 365 Reporting Overview

Quick Recap :)

  • Course Quick Recap

I look forward to teaching you this amazing technology.

To Your Success,
Abhay Sharma

#1 Udemy Best-Selling Instructor for Microsoft Dynamics | Microsoft Certified Trainer (MCT)

Excel for Accountants: Mapping Tables

Automate reporting tasks with a mapping table

Created by Jeff Lenning - Microsoft Certified Trainer

"]

Students: 86463, Price: Free

In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.

Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we'll discuss these special properties in the course.

Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications.

Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.

The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Excel Formulas and Functions with Excel Formulas Cheat Sheet

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 84646, Price: Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
  6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
  7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

PowerPoint Slide Design – Casual Slides Presentation

Create 5 PowerPoint Slides for any Presentation. Follow my PowerPoint Presentation & Animation Slide Tutorials

Created by Andrew Pach - Engaged and Passionate PowerPoint & After Effects instructor

"]

Students: 82014, Price: Free

In the brand new 'PowerPoint Slide Design' series I am happy to invite you to its first release. In the #1 edition we will be designing 5 Casual Business Slides for any type of presentation! I will teach you interesting PowerPoint tricks, tell you how to lay out your slides so they are catchy and pleasant for the viewer and so much more! I will take you by hand and design the slides along with you, so you never have to worry anymore about comming up with ideas, because this class will set the tone for you to follow with even more slides afterwards! Take a short preview around this course.

Preview some of the animations:

Features:

  • 5 Outstanding Slides
  • On-Trend presentation design
  • Brainstorm & ideas to follow-up
  • Master PowerPoint in a quick fashion
  • *.PPTX file included for personal usage
  • Design tips, tricks & shortcuts for PowerPoint
  • Confidence and intuition while designing presentations

There is no time to waste if you want to learn PowerPoint quick, efficient and become a better designer under an hour. I share years of my PowerPoint experience packed in tutorials in a concise manner. This series will be for everyone who would like to ramp up their Powerpoint skills in 1 day. It doesn't matter which version of PPT you use as the tips share will allow you to create powerful slides in PPT 2007 / 2010 / 2011 MAC / 2013 or 2016. 

Let's start....Enroll Now!

PowerPoint for Beginners – Program & Animation Basics FREE

PowerPoint basics is a free course where you learn basics about the software and its animation features. Enjoy!

Created by Andrew Pach - Engaged and Passionate PowerPoint & After Effects instructor

"]

Students: 71380, Price: Free

This course is intended for beginner and inexperienced designers, who aspire to learn Microsoft PowerPoint for professional or private use. No matter if you want to add a new skill to your portfolio, create videos, impress at work or start beeing an online entrepreneur. If you have very little experience with the software or are a total beginner and this will be the first time you open the software - this is the right course for you!

It's your best shot at getting on the right track to becomming a pro in the quickest possible way. I am releasing this content totally FREE of charge because it is also intended to be a prequel to any of my existing and future premium courses. So I am both helping people and making sure that I have a point I can direct people to if they never used PowerPoint :)

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

The course has 2 main goals here which I explain right at the beginning and am completely open about:

  1. I want you to get familiar with PowerPoint and teach you a little bit about the program itself and its animation features.

  2. I want to make sure that in case you are interested in my premium courses but are not sure about my teaching style, the pace of my lectures and if you will be prepared enough to enroll them you will be 100% equipped to do so after taking this course.

Sometimes people did ask me to make a very basic introduction to PowerPoint - and I believe such a little Crash Course is the perfect way to be released as free content since you can ensure that you will have the neccesary "prequel" knowledge to understand any other, more advanced course.

All of my courses are fairly beginner friendly but in case you would struggle I encourage you to take this course first to see how it is. If you already know everything that is taought here - you are overqualified and ready to go :)

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

What this course IS, and what this course ISN'T. Please read to not be dissapointed!

  • It is a very basic and brief introduction into the software and it's animation features

  • It is very beginner friednly

  • It is aimed for people with little or no prior tech experience or knowledge of PowerPoint

  • It isn't an advanced powerpoint course

  • It isn't a complex, insightful explanation of all powerpoint features

  • It isn't suitable for advanced powerpoint users - if you understand the basics you do not need to take this course

I think I am very clear with my message about the intentions of the course, what is beeing taought here and who is it for. Some of the features you will learn here are bext viewed by reading through the lecture curriculu,.

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

Some features I want to explain here:

  • What is PowerPoint, what is it used for and the difference between its versions

  • Explaining the interface, how to add slides, save presentations and export them to video

  • Adding & editing shapes, text, pictures and designing an entire slide

  • Using both transitions and animations including all their types and changed timings

  • Creating an entire animation sequence for a slide

  • and of course some more features along the way :)

I highly encourage you to take this course and have some fun inside PowerPoint with me, see you inside! Enroll now!

Best Online Excel Training | Best Shortcuts in 30 mins.

Quick useful guide to learn Excel Shortcuts (Save time & Money) [Excel 2007 - Excel -2019]

Created by Yoda Learning - Data Analyst |MS Office Expert & PMP | Instructor/Programmer

"]

Students: 69683, Price: Free

The list of 1000s of Excel shortcut keys are NOT to be memorized. It will torture your grey cells! So we have used industry practices and our Ninja Instructor's experience to handpick those shortcut keys which will meet your work requirements, make you look like an accomplished Excel Ninja.

This course is best suited for MS Excel 2007-2019 (Windows PC).

Not suited for Mac.

The best part is you can learn them in 30 minutes and start showing off at your office. Join now for a Complete No-Nonsense Course on Excel Shortcuts.

MS Excel – From 0 to Working Professional in 1 hour

Learn Excel as fast as possible

Created by Jason Zhang - Financial Analyst

"]

Students: 65003, Price: Free

This course covers Excel basics in the way that's very short and concise. You may use Excel before but this course shows you a better way of using these functions in real work environment. If you are going back to workforce, or looking for jobs, this is the fastest way to refresh your skill or Jump Start your skills. Within 1 hour, you can use Excel the way a working professional would use.  

This course IS NOT for everyone because of 2 things

1. Excel is powerful. Microsoft tries to make Excel as relevant to anyone as possible. However, each occupation use Excel differently. I've no idea how scientists or engineers use Excel. But I know how working professionals, especially analysts use Excel. I've worked as Business Analyst, Market Analyst, and till this day a full time Financial Analyst. Excel changed my life, I get hired, get promoted because that. I hope more people can do the same and better.

2. The pace of the course is super fast. If you like things go slowly, this is NOT for you. This course covers basic Excel. Most of the things in this course should be learnt by doing. Therefore I have enclosed a downloadable workbook. You can see me demonstrating on the left side of the sheet, while you would be practicing on the right.  

Powerpoint Presentation – design powerpoint slides

Learn to Design powerpoint slides for presentation. Master powerpoint for presentations

Created by Andrew Pach - Engaged and Passionate PowerPoint & After Effects instructor

"]

Students: 64304, Price: Free

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

LEARN TO DESIGN ENGAGING SLIDES & PRESENTATIONS!
MASTER POWERPOINT WITHOUT WASTING ANY TIME! 

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

There are so many Powerpoint tutorials, videos and courses which take too long to explain simple concepts and how to approach certain things, this course is not one of them. If you want to effectiveley use Powerpoint in your daily work. 

I will teach you how to design beautiful, engaging and proper designed in terms of visual hierarchy slides in powerpoint. This course is a complete shortcut to good presentation design in powerpoint in a short amount of time.

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

NO PRIOR EXPERIENCE IN POWERPOINT NEEDED!

MAKE BEAUTIFUL SLIDES INSTANTLY!

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

We work on a real life example, because we will prepare and design several powerpoint slides for a Sporty, Lifestyle presentation using free images and icons. 

What are the biggest benefits of this powerpoint course?

  • You learn on a real example
  • From an experienced Powerpoint designer & instructor 
  • You get the template and free images to work along
  • You will learn Powerpoint fast and efficient
  • It will take you about an hour to complete wonderful slides
  • You get additional design tips & tricks

Don't wait any longer... Enroll Now!

Boost Your Excel Skills: Crash Course w/ Downloadable Files

Microsoft Excel: Hone Core Skills in Microsoft Excel in 1+ Hours (Downloadable Excel Files Included in Course)

Created by The ProductivityMe Company - Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

"]

Students: 59750, Price: Free

Course Highlights:

  • 10 Individual, Bite-Sized Lessons
  • Downloadable Excel Files
  • Verifiable Certificate of Completion
  • Instant Access to Instructor and the ProductivityMe Community
  • 1080p HD Quality Video

In this Course:

Learning Excel takes time, particularly if you try to do it without any structure!

In this course, we'll walk you through the top ten skills you need to know in order to excel in Microsoft Excel!

Give us an hour, and we’ll help you to get to the next level of mastery in Microsoft Excel.

In this short, easy-to-follow training course...

We'll Cover:

  1. Autosum
  2. The Quick Access Toolbar
  3. The Shortcut Menu & The Mini-Toolbar
  4. The Quick Analysis Tool
  5. The Fill Handle
  6. Flash Fill
  7. Charts & Graphs
  8. Recommended Charts
  9. Sorting & Filters
  10. Tables

Our Approach:

At the end of each video, you have the chance to prove your mastery by completing a small practice exercise thus testing the core skill that you’ve just learned.

You can easily follow along in each lesson by using the downloadable course exercise files provided in Lecture 2.

If you have questions, comments, ideas, we’d love to hear from you. Email or message us any time.

Final Thoughts:

Alright, that’s it for now.

Look forward to having you in class!

Cheers,

Tolan & Ryan
ProductivityMe Co-Founders

Mastering Microsoft PowerPoint Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete PowerPoint course. Video lessons & manuals included.

Created by TeachUcomp, Inc. - Quality Software Training

"]

Students: 57860, Price: Free

Learn Microsoft PowerPoint 2010 with this comprehensive course from TeachUcomp, Inc. Mastering PowerPoint Made Easy features 69 video lessons with over 6 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our two printable classroom instruction manuals (Introductory and Advanced), additional images and practice exercises.  You will learn introductory through advanced concepts - from creating simple yet elegant presentations to adding animation and video and customization.

Whether you are completely new to PowerPoint or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch a video lesson or open one of the manuals and you’re on your way to mastering PowerPoint.

 

Excel 2016 Pivot Tables: Create Basic Pivot Tables in Excel

Pivot Tables in Excel 2016. Learn to create basic Pivot Tables in Excel 2016 with real-life examples.

Created by Kawser Ahmed - Founder ExcelDemy.com | Data Analyst

"]

Students: 54092, Price: Free

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Welcome to my “Excel 2016 Pivot Table” course where you will learn how to create basic pivot tables.

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly around 15,000 Excel users come to my Excel blog and read my Excel and data analysis related articles and tutorials.

At the end of this course:

  1. You will be able to create and update basic pivot table reports using Excel 2016,
  2. You will be able to realize, why and when you can best use of Excel Pivot Table tool,
  3. You will be get used to with the features of an Excel Pivot Table Report
  4. And you will be able to handle the limitations and compatibility issues related Pivot tables.

Let me give you an idea what exact topics I am going to teach you in this course.

  1. I will show you the exact cases when you can use the Excel Pivot Table
  2. Then I will show you the anatomy of a pivot table report with a real life example.
  3. Then you will see the step by step by process of preparing a data source for Excel Pivot table
  4. Then you will learn how to create and update a basic pivot table report
  5. Then you will be introduced with the Slicer tool in Excel
  6. And at the end of the course, I will show you total three techniques that you can use to will save your time when you’re working with Excel Pivot tables.

I have designed this course for new comers in Excel pivot table feature. But if you are an intermediate level user and want to be get used to with Excel 2016 Pivot table feature, then this course is also for you. This course will give you a simple but powerful introduction to the most powerful tool in Excel.

Feel free to take a look at the free previews of this course. I hope this course will change your view about Excel Pivot Table. Enjoy the course and thanks for reading!

Microsoft Excel – Improve your skills quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more - in just a couple of hours

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 49142, Price: Free

Welcome to this course about Microsoft Excel.

A lot of people use some of the features in Excel and just muddle through - not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

  • Learn more about formatting, filters and conditional formatting.
  • Create tables, PivotTables, Chart, PivotCharts and Sparklines.
  • Find out how powerful Visual Basic for Applications (VBA) is.
  • And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features - and you'll find out how much more you can learn.

Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.

Created by Marco Russo - Business Intelligence expert at SQLBI - SSAS Maestro & MVP

"]

Students: 45049, Price: Free

The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.

The course includes almost 3 hours of video in 30 lectures. You do not need any previous experience in Power Pivot to take this course.

Sections included in this course:

  • Introduction to Self-Service Business Intelligence
  • Introduction to Power Pivot
  • Loading Data
  • Data Modeling

After this course, we suggest you to take the Power Pivot Workshop Intermediate one.

Easy Excel Basics for Beginners – Get Started with Excel

Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.

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

"]

Students: 42632, Price: Free

Learn the basics of Excel quickly and easily.

This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.

This course will show you the basics of how to use Excel, how to create a basic spreadsheet, how to navigate quickly through a spreadsheet, how to create simple mathematical formulas and some shortcuts and keystrokes to save you lots of time.

You can go through this course in about 30 minutes. At the end you'll know how to create a sample spreadsheet that can calculate estimated kitchen remodeling costs automatically.

If you're ready to get your feet wet quickly and painlessly, take this easy introduction to Excel course and you'll see that using Excel can be easier than you think.

Excel: From beginner to intermediate

Learn the skills that Microsoft want you to know in Excel.

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 42093, Price: Free

What do others like you think of this course?

"Prior to doing this course Excel has always scared the heck out of me! I never expected to learn so much and am amazed by all the things that can be done using excel. It's so much more than just formulas! The course is really well presented and makes the whole learning experience comfortable and enjoyable. Thank you so much for putting together such a great course. I've already signed up to the intermediate to advanced excel course and I look forward to learning more about Microsoft Word in the future too... I imagine there are all orts of neat little tricks that I had no idea about!" -- Adam Shipley

"Phillip is a brilliant teacher of Excel . His explanations are clear , in-depth and very comprehensive" - xlongFx

"Awesome organization of course and well presented. I really loved the course. Of course as I am using excel for many years in work I was quite aware and using many features, but there are many details which helped me to polish my excel skills." - Manjunath Hirennavar

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

In this 11 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,

  • Format worksheets and workbooks,

  • Customize options and views, and

  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and

  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,

  • Manage table styles and options, and

  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,

  • Perform conditional operations, and

  • Format and modify text.

  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,

  • Format graphic elements, and

  • Insert and format objects in Excel .

The course will take about 10 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

Free Basic Excel Course + Lookup Function

Excel made easy for everyone

Created by MKCL India - Creating a Knowledge Lit World

"]

Students: 41781, Price: Free

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables.

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.

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

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

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.

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

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

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.

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

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.

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

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 Data Visualization for Business Analysts

Become an expert in data visualization using Excel as your canvas. Go past basic Excel charts to up your data vis game.

Created by Excel TV - Excel MVPs, Authors and Bloggers

"]

Students: 19847, Price: Free

Master Data Visualization Using Microsoft Excel

Whether you've just started working in Excel or you've been using it forever, chances are you've heard about data visualization and understand how important is. More than that, you've probably made a few charts you were proud of.

I was there, too. I could make any basic Excel chart my boss asked for. But I knew my charts - and many of those that I saw presented - did a poor job communicating data. Looking back, I think I was being asked to make charts just so we would have more to present.

Sound familiar? I've been where you are.

So I wanted to create a data visualization course for the business analysts who work with a lot of data and use Microsoft Excel regularly within their workflows. Chances are - you can already create a bar chart, a pie chart, and more. If that's you, read on.

Because I think a course for people like us has been missing. So I decided to distill everything I knew into a course that shows:

  • The important research behind which charts show the best information.

    That way you're always communicating the best results. And when your boss challenges you, you can point to the research. (Just point him or her to the module on why Pie Charts are the worst!)

  • How to create advanced charts not included in Excel.

    Most business problems can't be captured in Excel's native chart library. Do you know how to create Bullet Charts? Charts with multiple banding? This course will show you how.

  • How to create charts for analysis and how to create charts to tell a story.

    In this course, we'll talk about the difference between data graphics and info graphics. The former is for investigation, the latter for narration. You won't find this content elsewhere - I know, because I came up with it organically while working as a management consultant.

  • How to layout your charts and info graphics when you deliver them to executives.

    I'll introduce you to the camera tool, one of Excel's most powerful features. You'll see how it will allow you to drag-and-drop a chart, much like in Power BI.

  • Labs and Quizzes

    It's not enough to learn this information. You need to apply. I have created labs and quizzes based on the content. Take the quizzes to reinforce your knowledge. Complete the labs and then use them immediately in your own work.

  • No VBA or Macros

    I love VBA and Macros too but they're way over deployed. In many cases, the advanced chart you're thinking of making doesn't need lines and lines of code. I'll show you how quickly.

Here's what you can look forward to in this course: 

  • Data visualization principles including closure, proximity, common group and preattentive attributes

  • Theory and practice for why data visualization is so important

  • Why 3d charts cause issues when communicating data

  • Problems pie charts present to the audience

  • How to create charts with graded banding in Excel

  • How to create Bullet Charts in Excel

  • How to create Progress Meter Charts in Excel

  • How to create Waffle Charts in Excel

  • Microsoft Excel's camera tool

  • Resources to help you continue your learning

Like you, I work in the trenches, hustling to solve every new data challenge that comes my way. I wanted to create a course for people like me to learn from. If you want to stand out in the crowd and take your Excel and data skills to a whole new level, then you're the person I created this course for.

See you there,

Jordan

Learn Hidden Microsoft Word Tricks to become faster at work

A no-nonsense course to find out hidden Microsoft Word features

Created by Yoda Learning - Data Analyst |MS Office Expert & PMP | Instructor/Programmer

"]

Students: 19070, Price: Free

***THE MOST RELEVANT CONTENT TO GET YOU UPTO THE SPEED***

When I ask people at my training workshops how much do you know about Microsoft Word, I get a reply – I know it all. I don’t blame them. We think that word is all about writing or editing documents which we could learn by trying (remember you never needed a course for just typing)

What if I tell you that there are so many hidden techniques and tricks that will actually save 30-40% your current operating time. Maybe you don’t trust me. Let’s get to the point.

  • How do you avoid typing out frequently used text?
  • Do you know that your clipboard saves up to 24 instances (when you cut/copy)?
  • Do you struggle with creating a table of content, list of figures, etc?
  • How to you use mail merge by using data from excel?

I didn’t have an answer to all these questions when I started out (I too said – I know it all). However, after working and training professionals on these, I created a short series of hand-picked word trick specially meant for busy Microsoft Word users

This course is a 30-min no-nonsense fast-paced videos with 100% VALUE and a great way to find out word features you never use

Microsoft Excel: Starter Guide

New to Excel or don't use it often? Here's your free guide to get started.

Created by Eric Arseneau, Ph.D. - University Professor

"]

Students: 18542, Price: Free

This free class is meant for those who need Excel training from the very beginning. I will help you build confidence in using Excel to its full potential and provide you with the skills to navigate Excel efficiently. By the end of the course, you will be able to use Excel for a variety of decision making scenarios. Excel is one of the most powerful software tools ever built. It is just as effective at keeping a grocery list as it is at  crunching numbers for a Fortune 500 business. You will immediately create value for your own organization or your employer by learning the Excel skills taught in this class. I hope you enjoy it.

The Beginning Guide to Microsoft Word 2013

Another Computer Mama Guide

Created by Elizabeth Nofs - The Computer Mama

"]

Students: 18116, Price: Free

If you wish to prepare for Microsoft Certification Exam 77-418:Microsoft Office Word 2013 OR Microsoft Certification Exam 77-425 Part 1 and 77-426 Part 2: Microsoft Office Word 2013 Expert, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with 245 pages of detailed instructions
  • Sample documents and images
  • Practice, Quizzes and Skill Test

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Word 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

In Beginning Microsoft Word, you will cover important topics, including how to:

  • Learn how to navigate online and submit assignments
  • Format Text and Paragraphs
  • Get skilled at working with Text and Pictures
  • Use the Quick Click options and the mini Toolbar to format Text
  • Gain experience editing images and shapes with the Picture Tools
  • Learn how to create and format SmartArt
  • Use Quick parts to create professional documents

The Microsoft Word 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-418:Microsoft Office Word 2013 OR Microsoft Certification Exam 77-425 Part 1 and 77-426 Part 2: Microsoft Office Word 2013 Expert will find beginning through advanced lessons that demonstrate these required MOS topics.


This course teaches the objectives for the following certification tests: Core Certification: Pass any 1 test: Word 2013 Core: Exam 77-418

Expert Certification: Pass either test: Word 2013 Expert Exam 77-425 Part 1 or 77-426 Part 2.