Best Free Office Productivity Courses

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

Learn Tableau Desktop for Accurate Business Analysis

Hit the ground running with Tableau Desktop - develop 10 core skills for one of the fastest growing job markets in IT!

Created by Jane Crofts - Tableau Partner and Tableau Qualified Associate

"]

Students: 66043, Price: Free

Let's decide if this course is right for you.

  1. Have you recently started, or are you planning to start, using Tableau Desktop in your business?
  2. Are you looking to quickly build your skills in Tableau Desktop?
  3. Are you looking for Tableau Desktop skills that can be immediately put to use in analysing your business?

If you answered ‘yes’ to these questions, then this course is for you!

This course will give you the skills you need to jump straight in to using Tableau Desktop in your business.

Presented in a business context and working step-by-step through an instructor-led case study, this course goes beyond simply teaching the functions of Tableau Desktop. This course uses real-world business problems to give you 10 core skills that business users should have when using Tableau Desktop.

The 10 Tableau Desktop core skills covered by this course are:

    Bar & Line Charts

    Pie Charts

    Geographic Maps

    Scatter Plots

    Groups

    Area Charts

    Filters

    Dual Axis Charts

    Crosstabs and calculations

    Actions

An additional “Bonus Round” provides some more advanced skill development in formatting data, blending data, creating custom design elements and using responsive dashboard elements to build more sophisticated dashboards.

In addition to the video lectures and supporting notes, you will receive a range of workbooks and additional tools that you can use again and again. These tools and templates have been developed and tested over many years of consulting to organisations of all sizes using Tableau Desktop.

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.

Google Spreadsheet Basics: A (Free) Introduction

Learn Google Spreadsheets Step by Step, and Ditch Excel for the More Powerful Google Docs!

Created by Justin Mares - Traction Book author, growth at Airbrake/Exceptional

"]

Students: 27710, Price: Free

Become a master Google Docs user with this course on using Google Spreadsheets. You'll learn:

  • How to use Google Spreadsheets just like you use Microsoft Excel
  • 3 amazing tools only available in Google Spreadsheets
  • How to write your own scripts and use Google addons to get more done
  • How to create charts, tables, graphs and format data

This course will give you you everything you need to know about Google Spreadsheets.

From the fundamentals, to the most advanced features, after taking this class you will be able to use Spreadsheets like a MASTER. Pretty soon, you'll be using Spreadsheets better than most people can use Excel... and be able to take advantage of the super useful features that only Google Spreadsheets has to offer.

In this course, you will learn all of the following about Google Spreadsheets:

  • Learn how to navigate around Spreadsheets
  • Learn how to adjust the way data and information are displayed
  • Learn how to write formulas quickly and easily with the point-and-click method
  • Learn how to create powerful calculations
  • Learn how to visually represent your data with charts and graphs
  • Learn how to use data tools like sorting, subtotaling, and filtering
  • Learn how to automate tasks with time-saving scripts and addons
  • Learn Spreadsheets secrets and shortcuts

As bonus material, you will also learn two very incredible, and super valuable, skills:

  • how to harvest data from the web
  • how to create online forms which allow you to gather data from individuals

As an additional bonus, you can follow along and complete challenges and quizzes as you learn the material. You will also be shown how to find and download free Spreadsheet templates that will allow you to do all kinds of things.

Another great aspect of this course is that, at the end of this class, you will be given a CERTIFICATE OF COMPLETION.

This class is guaranteed to teach you Google Spreadsheets. Once enrolled, you will have access to this course for the rest of your life. You will always be able to come back to this class to review material or to learn new material. Try this course for yourself and see how quickly and easily you too can learn to use Google Spreadsheets.

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.

Cyber Criminals Want Your Information: Stop Them Cold!

Learn to securely and easily manage your digital life's ever growing list of passwords and beat the cyber criminals!

Created by Jeremy OConnell - Information Technology Experienced Professional

"]

Students: 25307, Price: Free

Let's face it - life on the Internet means usernames and passwords (accounts)! Lots of them in fact!

Stop and think about it for a moment.  How many sites do you login into daily, weekly, or monthly?

  • Social media: Facebook, Twitter, Snapchat, Skype, Pinterest, Instragram, Youtube...

  • Ecommerce: Amazon, eBay, Overstock, Newegg, Target, Walmart...

  • Online Banking: Paypal, Bank Of America, Wells Fargo, Sun Trust, Charles Schwab...

  • Email: Gmail, Yahoo! Mail, Hotmail, your ISP email...

  • Gaming: Xbox Live!, Playstation, Wii, Steam....

  • Streaming: Youtube, Netflix, Hulu, Curiosity Stream...

The above list is only a small sample of sites you probably use on a regular basis.  In fact many people have over one hundred accounts and that list is growing all the time!

How do you keep track of all this information?

  • Use the same few passwords among your accounts

  • Keep a spreadsheet

  • Write them down on paper

  • List them on a word processing document

  • Stick notes on your monitor

Unfortunately none of those are good practices.  That's right - none of them.  For the best security you should have a different password for every account (site)!  These passwords should also be stored in an encrypted and safe manner.

Now why should you use a different password? You have heard of massive data breaches haven't you? Where cyber criminals steal thousands, hundreds of thousands, or even millions of account information?  It has happened to many sites including Adobe, eBay, Twitter, and many many others.

If your Twitter and bank passwords are the same and the cyber criminals steal your Twitter password, guess what? They could now potentially access your bank account! That would be a nightmare.

So every account on every site should have a unique password.  After all, the username is usually your email address so in most cases your account is only protected by your password.  However, there is more to this puzzle.

You should make your password as difficult for the cyber criminals to guess as possible.  That means quit using video123 and use something like R-'hJ@y|11_b@i&U%RfB-z`J7ZF0d":blJg"ksUg which is far more secure.

Now you are probably wondering: how in the world do I have a unique long password for every site and easily keep track of all this information? Well, you are in the right place.  That is the whole point of this Udemy course.

Your instructor, Jeremy O'Connell, will explain with videos how you secure your digital accounts and better protect yourself from cyber criminals.  So the next time when you hear on the news   of some site being hacked and millions of accounts being stolen you will know your accounts are safe and changing that site's password is no big deal.

What are you waiting for?! This course is even free, so put away your wallet!

Getting Started with Gmail, Google Drive, Docs and Calendar

"A great introduction to four of Googles most popular tools - Gmail, Google Drive, Google Docs and Google Calendar"

Created by Guy Burn - Learn how to use Gmail

"]

Students: 24579, Price: Free

This course is an introduction to four of Googles most popular tools, namely Gmail, Google Drive, Google Docs and Google Calendar. Designed especially for beginers, it will help you to organise your online life.

Almost everyone uses email these days, so why not start as you mean to go on, and get organised?!

And, what's more, you don't have to be in business to use Google Drive and Google Docs.

We all have documents that need storing. They could be photos, videos, or even important paperwork. Safe storage is essential. So why not use Googles cloud to look after them? It's free!

As for Google Calendar.....we all need a diary to run an efficient life.

You will find 25 easy to follow videos inside. The majority of these are only a few minutes, so they are easy to digest. You can quickly go over them again if you "don't get it".

And you've got my personal contact details, so feel free to contact me if you have any questions.

Take this course and learn the basics of these "must have" Googe Tools.

SAP LSMW Training – in Plain English

LSMW is the gold standard tool used by functional consultants to migrate data into SAP.

Created by Siva Prasad - SAP Trainer and Consultant

"]

Students: 23266, Price: Free

** Disclaimer ** -  

  1. I do NOT do Live Training. SAP is a registered trademark of SAP AG in Germany and many other countries. I am NOT associated with SAP.
  2. SAP software and SAP GUI are proprietary SAP software. Neither Udemy nor me are authorized to provide SAP Access. You can officially get SAP Access to practice on SAP system from SAP's website. I am not allowed by Udemy to place a link here. Please google "SAP Access" and you can find the URL for the same.

Imagine you are an SAP Functional Consultant and your project's realization phase is done. Now you need to migrate 100,000 Customer records from your legacy system ( say Salesforce ) to SAP. How would you do it ? LSMW is the gold standard tool used by SAP functional consultants to migrate mass amounts of data into SAP. LSMW stands for Legacy System Migration Workbench . The name definitely sounds complicated, but believe me - I am going to make it look so simple that you will have fun doing it !! Ciao in the course..

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.