Best Microsoft Courses

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

Microsoft Outlook 2010 Beginner

Master Outlook basics in this easy to follow, step-by-step course.

Created by SONIC Performance Support - E-Learning Experts - Training Company

"]

Students: 72, Price: $19.99

Students: 72, Price:  Paid

In this course you will use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks, and create notes.

Consider SONIC's Microsoft Outlook 2010 Intermediate to deepen your knowledge.

Our Microsoft courses help you to prepare for the official Microsoft Office Specialist exam.

Interactive Excel Dashboards

Create impressive, interactive Dashboards in Excel, from scratch!

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

"]

Students: 68, Price: $89.99

Students: 68, Price:  Paid

**Includes exercises and two, follow-along Dashboard Projects**

Have you ever looked at an interactive dashboard in Excel and thought “I wish I could create something like that!”. Well, now you can. We’ve drawn on our years of expertise as a Microsoft Excel training provider and have put together the ultimate Excel dashboards course.

We’ll teach you how to create dashboards that look amazing, that are fully interactive so you (or anyone else!) can change the data they are seeing, and that can be updated with new data in a couple of clicks.

If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!

In this advanced Excel course, we look at how to create stunning, interactive dashboards in Excel.

Once we’ve taught you all the techniques you need to create your dashboards we end the course with two, super projects:

  1. Creating a fully interactive Sales Dashboard from scratch

  2. Creating a fully interactive HR Dashboard from scratch

In this course you will learn:

  • About Dashboard architecture and inspiration

  • How to prepare data for analysis (cleaning data)

  • Useful formulas for creating dashboards in Excel

  • How to create and edit Pivot Tables in Excel

  • How to create Pivot Charts from Pivot Tables

  • Advanced chart techniques in Excel

  • How to add interactive elements (form controls) into your dashboards

  • How to create a Sales Dashboard from scratch

  • How to create an HR Dashboard from scratch

This course includes:

  1. 9+ hours of video tutorials

  2. 70+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

This course was recorded using Excel 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2019, 2016, and 2013.

New Features in Microsoft 365 Desktop Applications

This training covers the desktop applications in Microsoft 365 and Office 2019 desktop applications.

Created by SONIC Performance Support - E-Learning Experts - Training Company

"]

Students: 68, Price: $19.99

Students: 68, Price:  Paid

Microsoft 365 is constantly being developed and updated. The development status of Microsoft 365 (Office 365) in October 2018 was published as Office 2019. All new features in Office 2019 are therefore included in Microsoft 365. In this Microsoft 365 training course, all the new features are explained to you in a meaningful order, sorted by application. You will find the version and release date of each new feature in the table of contents.

Data Analysis with Excel’s Power Pivot

Learn how to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

Created by SONIC Performance Support - E-Learning Experts - Training Company

"]

Students: 67, Price: $19.99

Students: 67, Price:  Paid

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. 

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to
analyze data from a variety of sources.

You will: 

  • Get started with Power Pivot.
  • Visualize Power Pivot data. 
  • Work with advanced functionality in Power Pivot. 

OneNote for Windows 10 – In-depth, comprehensive training

Comprehensive, real world training in OneNote for Windows 10 starting from the very beginning.

Created by ITPro TV - Watch & Learn

"]

Students: 66, Price: $89.99

Students: 66, Price:  Paid

OneNote for Windows 10 - In-depth, comprehensive training

Microsoft's OneNote for Windows 10 is the helpful note taking application to keep you organized for any project. Whether is it for working on a large project with co-workers to tracking recipes for dinner, OneNote is a great answer for keeping everything in one place.

In this series, you will learn how to create and organize notebooks, add different types of content, stay on task with tags, use helpful features such as the OneNote Web Clipper, and share notebooks with others.

This series specifically covers the OneNote application that is part of the Windows 10 operating system.

Course format

  • Binge-worthy TV shows! Watch comprehensive, in-depth episodes that use a talk show-like format to keep you engaged while learning. 

  • Each episode has downloadable files to help you follow along

  • You can pick and choose episodes by specific topic or can watch as a complete series

  • Enjoy cats, NSYNC, and some real-world examples to keep learning fun

Other courses

Ready to be an Office pro?  Check out the full line of Microsoft Office Productivity Tools training from Vonne and OfficeProTV.  This application has only 1 levels of training for purchase.

Looking for OneNote 2016? You’re covered. We have specific training for OneNote 2016 for Windows for purchase.

Office versions and updates

Got another computer update? Probably. Frequent updates are a cornerstone feature of a Microsoft Office 365 subscription, and Office is always changing – from the interface to the expanded functionality. That being said, some features such as icons, buttons, and options have updated since the time of this series’ recording.  While bells and whistles change, the foundations stay the same. 

Many of the skills covered in this course can be translated to previous versions of OneNote like Office 2013 or even the new Office 2019, locally. If you are using Office Online only, some lessons and demonstrations from this series may translate, but the online platforms are quite different.

Outlook 2019 3-Course Bundle (Intro, Adv, & Email Etiquette)

Learn and use beginner/advanced features of Microsoft Outlook 2019 as well as gain knowledge on email etiquette

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 62, Price: $89.99

Students: 62, Price:  Paid

Save 20% by purchasing this 3-course bundle; which teaches you all you need to know about Microsoft Outlook 2019. An email etiquette course designed to help with formatting and editing email messages is also included in this great bundle!

This bundle includes:

  • Microsoft Outlook 2019 Beginner

  • Microsoft Outlook 2019 Advanced

  • Business Skills: Email Etiquette

Email is in an important tool in today's business world. With its prevalence, it is imperative this tool is used professionally and properly.

In the beginner course of Microsoft Outlook 2019; students will learn the basics of Microsoft Outlook 2019 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.

In the advanced course of Microsoft Outlook 2019; students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2019. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data.

In the email etiquette course within this bundle; students will understand best practices for setting up and composing email, and responding to messages, formatting messages, proofing messages and offers tips to minimize common mistakes like missing attachments, wrong addressing and more. 

Easy Excel PivotTable Skills – PivotTable Power Tips

How to create Excel PivotTables that can quickly be used to summarize large amounts of data and learn some Power Tips

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

"]

Students: 57, Price: $34.99

Students: 57, Price:  Paid

No fluff here, just skills!

Unlike other courses, we will not get into the history of PivotTables, instead we just start learning right away. 

Have you been using Excel regularly for over 1 year? Jump right in - you are ready to take your data analysis/reporting to the next level!

  • Would you like to create an interactive report that can quickly be used to summarize large amounts of data? Then look no further than a Pivot Table.
  • Are you swarmed by the mountains of data you have?
  • Do you want to see trends and patterns at a glance?
  • Your bosses want answers (QUICK!) from your collection of data and each of them want something different out of those numbers.  

If you have ever been in any of these situations, then PivotTable reports are just the thing for you.

We just get right into it here.

Ready. Set. Go!

Don't Get Mad...Get Skills!

Connect XL & Outlook -Access VBA & Collection Loops Series 7

Control Excel and ms Outlook Applications from MS Access VBA plus wonderful collection loops.

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 56, Price: $19.99

Students: 56, Price:  Paid

  • Using ms access vba how we can work with ms excel

  • Using ms access vba how to connect outlook application.

  • How to send emails using access vba

  • How to send any ms access table data via outlook mail using vba

  • Early binding and late binding approaches - which is better and why?

  • What is Create Object and Get Object methods in late Binding.

  • How to import outlook email information from any folder to any ms access table

  • Why to declare object and why a class object.

  • How we can create a new excel object using access vba

  • How we can open an existing excel from ms access vba editor

  • Use of file-dialogs like open dialog and save-as dialog

  • What are the collection loops

  • Collection loops use in tables

  • Collection loops in queries

  • Collection loops use in forms

  • Collection loops  use in reports

  • Collections loops  for macros and modules

  • Few interesting projects for you

  • Always ready to help you online with 100% guaranteed

The Business Guide to Microsoft Office

Another Computer Mama Guide

Created by Elizabeth Nofs - The Computer Mama

"]

Students: 56, Price: $94.99

Students: 56, Price:  Paid

The Business Guide to Microsoft Office

If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need.

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

All materials for this program are available online. The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Word 2013
  • Intermediate Guide to Microsoft® Word 2013
  • Advanced Guide to Microsoft® Word 2013
  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft® Excel 2013
  • Advanced Guide to Microsoft® Excel 2013
  • Beginning Guide to Microsoft® PowerPoint 2013
  • Advanced Guide to Microsoft® PowerPoint 2013

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 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 Microsoft Word, you will cover important topics, including how to:

  • Format Text and Paragraphs
  • Get skilled at working with Text and Pictures
  • Learn how to create and format SmartArt
  • Understand how to use and edit Templates to create documents and resumes
  • Create a Mail Merge that sends a personalized invitation to each recipient
  • Learn how to select the Mail Merge recipients and troubleshoot errors
  • Create a Web Page that uses a Table for consistent layout

In Microsoft Excel, you will cover business topics, including how to:

  • Create formulas that use Relative and Absolute values and audit the formulas
  • Use and modify TEXT, DATES and FINANCIAL data with formulas
  • Create, use and troubleshoot Named Ranges and use Named Ranges in formulas
  • Understand how to create and use Lookup Tables and use the IF functions
  • Excel In Print: Use page Layout and Page Set up to modify print settings

In Microsoft PowerPoint, you will learn how to:

  • Know how to work with Text Boxes, Format Shapes and apply Themes
  • Insert, format and adjust Pictures with the Picture Tools
  • Insert and format Shapes and SmartArt to create an effective presentation
  • Use Tables and Spreadsheets to display data in a presentation
  • Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  • Learn how to design Slide Masters and apply slide Transitions
  • Apply Animations to images in a slide show and edit the timing

Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need.

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

Microsoft 365 Visio Online – Beginner

Students will learn the basics of Visio Online in Microsoft 365, including working with shapes, diagrams & flow charts.

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 52, Price: $29.99

Students: 52, Price:  Paid

This course teaches the basic functions and features of Visio Online. The primary focus is to get acquainted with creating the different diagrams using the shapes and templates. You will learn the difference between Visio Online and Visio, and the benefits of each. You will learn how to draw basic shapes, format shapes, group shapes, and arrange shapes. You will also learn how to create diagrams, work with text, apply formatting, and work with pages. Lastly, you will learn to share diagrams and start a review.

This IAAP-certified counts for 0.75 recertification points for the CAP certification under the Technology and Information Distribution content area.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

OneNote for Windows 10 – A Complete Guide

An in-depth look at OneNote for Windows

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 52, Price: $39.99

Students: 52, Price:  Paid

This course is an introduction to, and in-depth look at OneNote for Windows. During the course, students will learn how OneNote can help them to organize their notes more efficiently, and allow them to access their content from anywhere. Students will also learn how to share the contents of their OneNote notebooks with others, and collaborate.

This IAAP-certified counts for 2.5 recertification points for the CAP certification under the Technology and Information Distribution content area.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the utmost next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

Excel Macros

Everything you need to know to start working with Macros in Excel

Created by Branka Bradule - Project manager, Business Analyst, MS Excel tutor and coach.

"]

Students: 50, Price: $49.99

Students: 50, Price:  Paid

This course is designed in a way to first explain some basic theory about macros and then to explain and show the most important aspects of Macros in Excel. We will not go into the depths, we will cover only the basic aspects which are needed to start recording, understanding, and editing macros. Right after the explanation, we will work on exciting examples to help you to consolidate newly gained knowledge on practical examples.

Topics that will be covered:

  • Theoretical background about Macros, OOP, and VBA editor

  • Creating Macros using Macro Recorder

  • Creating user forms

  • Binding a Macro to an object

  • Debugging

  • Quick Access Toolbar and Ribbon customization

In the beginning lectures of the course, we will cover first some theoretical aspects, because it is very important for you to understand basic terminology and methodology related to macros, VBA, and object-oriented programming. After understanding some basic macro theory, we will then start with macro creation using a macro recorder.

Once when we will have our first macro in place, we will understand the importance of the VBA editor, which is the only way to modify the macro we already recorded. Here I am going to show you how VBA comprised and the basic syntax for writing the VBA code.

Once when we get a bit more proficient in writing VBA code directly in VBA editor, we are going to write a simple program to do different things for us, such as clearing the content of specified ranges, printing active Excel sheet to pdf format, or generating numbers for invoices that we manage in Excel. I believe that this part will be the most interesting one and that we are going to have so much fun in this part of the course!

In each module, you will also receive Excel exercises to follow along with course examples and at the end of each module, you will be given an activity to complete.

At the end of the course, we will summarize what has been covered, work on additional exercises and provide a few review questions for you to answer.

Additionally, at the end of the course, you will get access to Lesson Labs to work independently on different examples. The purpose of lesson labs is for you to consolidate gained knowledge and to try to think outside the familiar area. Some examples in the lesson labs were covered during this course lectures, others were not. Even if solutions for all lesson labs are presented in the file which contains completed lesson labs, I encourage you to try to finish them on your own – even if it contains the additional research.

I look forward to seeing you inside the course.

Excel Macro Basics

Everything you need to know to start creating macros in Excel 2016

Created by Tim Wright - Nationally Recognized Instructional Designer

"]

Students: 49, Price: $19.99

Students: 49, Price:  Paid

You don't have to be a programmer to start using the basics of Excel Macros. Excel makes it easy to identify your list of actions and automate them with buttons and/or shortcut keystrokes. 

This video lecture covers all the basics of Macros in Excel 2016. Topics include: 

  • Overview of macros
  • Identifying the series of commands and actions to automate 
  • Avoiding common errors in macros 
  • Creating universal and local file only macros
  • Creating shortcut keys 
  • Creating custom buttons
  • Creating Quick Access Toolbar links
  • Managing macros
  • VBA Macro Basics

Start this course today and tomorrow you be be automating tedious tasks in Excel make your work more efficient and less frustrating.

Enroll now.

Excel & Access VBA Dashboards and Projects Series 15

Super Advance Reports &Projects - Excel VBA and Access VBA

Created by ajay parmar - Instructor - Advance Excel, Excel Vba ,Access, Access Vba

"]

Students: 48, Price: $29.99

Students: 48, Price:  Paid

  • if you are an intermediate or expert in Excel  and Access vba then these report Automations and dashboards are very useful to you.

  • Dashboards are coming directly from your questions so it will give you a real feel of office work. You can use these ideas in your day to day work and create fabulous Projects and Dashboards.

  • Fantastic automation secrets are also revealed in this series.

  • Excel and MS Access reports can be downloaded.

  • Online support by me is available if you have questions.

  • How to create Excel Pivot Dashboards - Preview available

  • Agent Dashboard simple dashboard is created to begin with.

  • Create a Break Timer for Team members so that they can see their live break duration on system using Excel VBA - Its awesome tool

  • How to create a Tool which can help Team Leaders to supervise their team associates break timings. Using MS Access integration with Excel VBA- Using SQL and other recordset related loops - Highly Advance Level.

  • How to create a Tool using VBA Arrays and etc to empower user to find out the relevant information inside data and export it in a specific format.

  • How to create a MS Access Dashboard using its VBA to keep tracking of Visitors. It is done by using MS Access VBA.

  • Recently added one more outlook dashboard wherein you can send emails to clients at desired time and also can take follow ups on the auto mode. It is completely handled from excel and user just need to give email id and time. It is one of most advance report I have created using ms word, ms outlook classes and controlling it via ms excel vba.

Basics of Computer

Basic things about computer & Micro soft Office features

Created by Pravin Pathak - Chemical engineer and Safety Professional

"]

Students: 46, Price: $19.99

Students: 46, Price:  Paid

In this course, the contents are :

  1. History of Computers

  • Types of Computer

  • Old version computers to Palmtop, Laptop etc.

  • Computer System : - Hardware, Software & User

  • Types of Software :- System Software & Application Software

  • DOS, OS, Windows, Office etc

  • Advantages of Computers

  • Different parts of Computer System :- Mouse, Keyboard, CPU, Monitor, Printer, Scanner etc

  • Types of Printer - Compact & Non-compact

  • Internal Components of CPU like power supply, RAM, Chord, Video Card, Sound Card, etc

  • Photographs of major components and peripherals of Computer System.

2. MicroSoft Word - Features in MS Word :-

  • Creating and saving a file

  • Editing and formatting a document

  • Paragraph formatting

  • Inserting header and footer and Page number

  • Checking spelling and grammar

  • Subscript and superscript

  • Inserting symbols

  • Print preview and printing

  • Inserting clipart, word art, and picture

  • Page setting

  • Bullets and number

  • Border and shading

  • Searching a word and replacing it by another word

  • Inserting table

3. MicroSoft Excel - Features :-

  • Introduction to Excel

  • Overview of the Excel Screen

  • The Excel Menus:

  • File Menu Edit Menu Insert Menu Format Menu View Menu

  • Help Menu and Office Assistant

  • Excel Worksheets

  • Entering Formulas and Data

  • Formatting Workbooks

  • Charts

  • Freezing Panes

  • Printing

  • Keyboard Shortcuts

4. MicroSoft Powerpoint

  • Conversion process of PPT to Video.

  • Initial Setup

  • Record

  • Write / Annotate (Pen option)

  • Export

  • Features of Presentation and recording.

  • What is recommended quality of Conversion?

5. WWW - World Wide Web - Internet Features

  • How the Internet is operating?

  • How to search on Internet? What are search engines?

Master Visio

A practical approach to learning and mastering Microsoft Visio 2016 quickly.

Created by Peter Reynolds - Consultant at TM-Global

"]

Students: 43, Price: $39.99

Students: 43, Price:  Paid

This is a comprehensive course which will show you how to master Microsoft Visio 2016. The course is structured in five sections.

Section 1 introduces the course, Visio and gets you working with Visio.

Section 2 shows you how to work with shapes, create block diagrams, create workflow diagrams, create  organisational charts and use Visio for brainstorming.

Section 3 shows you how to create shapes, work with data, add data to shapes as well as looking at collaboration and the document Stencil.

Section 4 shows you how to create timelines, Gannt charts, floor plans and maps, network diagrams, wireframe diagrams and SDL diagrams.

Section 5 shows you how to  use the developer mode, work with layers, work with macros and work with the ShapeSheet.

Intro to Excel Macros Part 2

This course continues the exploration of the Excel Macro Recorder, including how to enhance the code you’ve created.

Created by Illumeo Learning - Condensed and Efficient Courses for Busy Professionals

"]

Students: 35, Price: $49.99

Students: 35, Price:  Paid

In this comprehensive on-demand webcast, you’ll learn even more about how to use Excel’s Record Macro feature from Excel expert David Ringstrom, CPA. He shows you how to enhance the code you’ve created with the Record Macro feature by adding error-handling functions, decision-making capabilities, and interactive features. In addition, David presents techniques, features, and keyboard shortcuts that will help you eliminate repetitive tasks and become more proficient utilizing Excel macros.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Topics Covered:

  • Discovering how to enable the Developer menu in Excel 2007 and later.

  • Gaining an understanding of Excel’s Goal Seek feature, which is useful in simplifying what-if analyses.

  • Learning how to play back macros you’ve recorded so as to eliminate repetitive or tedious tasks.

  • Using form controls to simplify data entry as well as control the input of other users.

  • Understanding the nuances of assigning keyboard shortcuts to macros in Excel to avoid superseding shortcuts for built-in features.

  • Learning what to do if a Debug prompt appears.

  • Adding error-handling features to Excel macros to compensate for unexpected or missing data entry inputs.

  • Bypassing filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.

  • Learning the nuances of the Excel Macro-Enabled Workbook in versions 2007 and later.

Although each course may be taken individually, this is part 2 of 4.

1. Intro to Excel Macros Part 1

2. Intro to Excel Macros Part 2

3. Intro to Excel Macros Part 3

4. Intro to Excel Macros Part 4

Microsoft Teams for Business Users

Conquer Microsoft Teams as a Business User

Created by Competitive Computing Consultants Inc. - Business Skills and Automation Training

"]

Students: 34, Price: $39.99

Students: 34, Price:  Paid

You don't need to watch 5+ hours of Microsoft Teams Training to learn all you need to know about this Workplace Application without wasting your valuable time.

At Competitive Computing Consultants, we train Microsoft Teams to hundreds of organizations. Now you can get our Enterprise Level Training for yourself.

Learn how to communicate, collaborate and work effectively and efficiently using Microsoft Teams. Whether you are working with others, or on your own, Microsoft Teams allows you to stay connected with your colleagues, partners, customers, and your work documents from a centralized Collaboration Hub.

This course will focus on the features and capabilities that let you focus on your day to day work activities from any where, on any device, at any time.

Part 1: Tour and Navigation

Part 2: Create a Team, Manage a Team, Channels and Tabs

Part 3: Activity and Chat View

Part 4: Calendar View and Meetings

Part 5: Calls View, Files View, Ellipses, Searching, Command Bar Shortcuts, and Settings

Part 6: Teams Mobile App

Microsoft OneNote 2016 Course – Basics to Expert

The course prepared by the Microsoft Partner of the Year

Created by Akademia CentrumXP - Oficjalny Partner Microsoft

"]

Students: 33, Price: $29.99

Students: 33, Price:  Paid

OneNote 2016 course is a complete set of guides on how to use the popular Microsoft application.

We start work with a notebook, create notes, use templates and provide ready-made notes. We present the possibilities of handwriting and the use of tags. We create advanced records that will allow you to work more effectively.

The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards.

Microsoft 365 Managing Microsoft Teams (Exam MS-700)

Learn more about Managing MS Teams and how to pass the MS-700 Exam

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 33, Price: $64.99

Students: 33, Price:  Paid

This course is for people interested in administering a Microsoft Teams environment or taking the MS-700 Microsoft Teams Administrator Associate certification exam.  We will cover all they task required for a person charged with the day-to-day management of a Microsoft Teams environment.  We will cover topics including planning and configuration, managing chat, calling and meetings settings and experiences, along with creating teams, membership, and app control.  There will be a discussion about upgrading considerations as you move from Skype for Business to Teams.  We will discuss using the various portals as well as PowerShell for administration.   We will examine governance and lifecycle management as well as security and compliance, including guest and external access.   This course will help you understand how to deploy and manage various Microsoft Teams endpoints such as desktop, mobile and IP phones.  You will learn how to monitor the environment using usage reports, Call Analytics, Call Quality Dashboard and Power BI.   As a cloud PBX solution, we will gain an understanding of how to manage phone numbers, emergency address configuration, call routing, auto attendants as well call parking, caller ID policies and calling plans.  If you are sitting the exam to earn your MS-700 Microsoft Teams Administrator Associate certification, this course will cover all the skills being measured. 

Unleashing Power Pivot and DAX in Excel for Beginners!

Join the ELITE EXCEL POWER USERS by Learning DAX and Power Pivot in Excel

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

"]

Students: 32, Price: $89.99

Students: 32, Price:  Paid

In this course, the student will learn how to use Power Pivot in Excel and perform complex calculations using the DAX formula language. This course is excellent for beginners who want to learn Power Pivot & DAX from scratch.

This course offers tremendous value as a beginner's course. The student will get out of this course with a thorough understanding of Power Pivot & DAX and also using Power Query along the way.

This course will take the student step by step through the journey of learning Data Modeling, Power Pivot, & DAX.

We will also be using Power Query as a tool to Extract, Load & Transform (ETL) our data.

  • First, we will start by learning how to enable Power Pivot in Excel

  • Then, we will load the data into our Data Model using Power Query and create relationships between our tables

  • We will also explore the different types of relationships and understand the difference between them

  • Afterward, we will explore Measures and Calculated Columns and understand the difference between them

  • We will also learn the difference between Implicit Measures & Explicit Measures

  • Moreover, we will learn about the Filter Context & the Row Context and understand the difference between them

  • Furthermore, we will learn about the RELATED() and RELATEDTABLE() functions and understand the difference between them

  • Also, we will be installing DAX Studio and having multiple examples on how to use it to troubleshoot and verify the results of your DAX formulas

  • Afterwards, we will learn about Iterator functions in DAX such as SUMX(), AVERAGEX() & FILTER(), and we will be explaining the difference between the X and Non-X functions ( e.g. SUM() vs SUMX())

  • We will also be dedicating multiple videos to the FILTER() function and explaining how to use it solve different problems and get the desired results

  • Then, we will be exploring super important Table Functions such as ALL(), ALLSELECTED(), VALUES() and DISTINCT() and we will explain the difference between VALUES() & DISTINCT() functions

  • Moreover, we will be exploring Variables in DAX and explain how to use them to make your formulas easier to read and troubleshoot and faster to execute

  • And of course, we will be explaining the CALCULATE() function which is the most important function in DAX, and we will be explaining how to use it to change the filter contexts of your calculations to get the results that you want

  • In addition to CALCULATE(), we will be explaining the CALCULATETABLE() function and showing a great example on calculating the number of new customers acquired each day in our store. We will also be explaining the difference between CALCULATE() & CALCULATETABLE()

  • Afterward, we will dive into Time Intelligence Calculations in DAX, where we will build a Calendar Table from scratch using Power Query

  • After building the Calendar Table, we will explore how to perform Time Intelligence Calculations such as YTD, Previous Periods, Moving Running Total, Moving Average & Weekly Time Intelligence Calculations

  • You will also be getting all the needed Example files to follow along and you will be having exercises along with answers throughout the course in order to get hands-on practice!

I'm confident that you will be getting outstanding value from this course, so make sure to enroll in the course to join the ELITE EXCEL POWER USERS!!

Abdelrahman

OneNote for Windows 10 Essentials

It’s time to get organized

Created by Chip Reaves - Bigger Brains

"]

Students: 29, Price: $24.99

Students: 29, Price:  Paid

The Structure You Need with the Flexibility You Want

OneNote is one of Microsoft’s unsung heroes: a digital notebook that allows you to organize your notes, meeting minutes, project documents, and more—all in one place. It’s almost like having an old-school, three-subject binder—except with unlimited sections and your notebook won’t weigh down your bag like it might have in school. Plus, no one will have to copy your notes, because you can share them digitally to collaborate with others.

Are you ready to get organized?

Note: While many of the features are the same in other versions, this course is specific to the Windows 10 version of Microsoft OneNote.

Microsoft Access: Up to Speed

Database management & design with Microsoft's powerful database application.

Created by Roger Hyttinen - Course Designer and Instructor

"]

Students: 27, Price: $19.99

Students: 27, Price:  Paid

Welcome to Microsoft Access - Up To Speed:

This course helps you to get up and running quickly with the latest version of Microsoft’s powerful database application, Access 2019. This handy step-by-step class starts from scratch, starting with basic topics and moving on to more advanced features of the application, designed to help you to become more productive more quickly.

In no time at all you’ll be navigating Microsoft Access’s interface, create databases, entering data, creating data entry forms for users, and reports. You’ll also learn how to filter your data using queries, create relationships between your tables, and how to create macros to automate your tasks. Additionally, you’ll learn how to import data from other applications into Access and how to export your Access data to other applications. You’ll end by managing your databases using Access’s various database tools.

Who is this course for?

This course was created for people new to databases as well as database designers looking to learn a new and powerful database management application. This course will also be helpful for those coming from a previous version of Microsoft Access or those looking to delve more deeply into the Access application.

What does this course include?

· Step-by-step instructional videos that are easy to follow

· Downloadable lesson files allowing you to follow along with the instructor

· Support for any questions you may have

What You’ll Learn:

· The Basics. We’ll begin by creating a new Microsoft Access database file and then take a look at the Access environment. You’ll set Access options, learn about database templates, how to open an existing Access database and how to create a new database. We’ll also take a brief look at the various objects in Access: Tables, Forms, Queries and Reports. Then, you’ll learn how to obtain help when necessary.

· Working with Tables. You’ll start by creating a table using Application Part and we’ll move on to entering data into a table. You’ll discover how to create a table from scratch, add new fields to a table, change column width and height, delete fields from a table, change field properties and design while in Datasheet View. You’ll also learn all about setting Primary Keys.

· Working with Data. In this section, we’ll begin working with data. You’ll learn how to enter, edit, and format data. You’ll sort records, filter data by selection and form, select records and delete records. You’ll learn how to hide, unhide, freeze and rearrange columns. You’ll also import Excel data and data from a text file into an Access table. Lastly, you’ll learn how to display column totals in a datasheet.

· Advanced Tables. Next, we dive more deeply into working with Tables. Here, you’ll learn how to limit data entry be creating validation rules. You work with formatting and indexing fields, as well as how to require data entry in a field. Here, you’ll learn how to facilitate the data entry process by creating an Input Mask, a Lookup Field and a Value List. You’ll look at Primary Keys more in depth and learn how to create calculated fields in your tables.

· Working with Queries. Now we begin working with Queries. We’ll create queries both from scratch and using the Query Wizard. You’ll learn how to add fields to and remove fields from a query, rearrange query columns, how to add single or criteria to a query, and sort query data. You’ll also work with saving and running queries.

· Database Relationships. At this stage, you’ll learn all about database relationships. You’ll start by creating one-to-one relationships and then move on to one-to-many relationships and finally to many-to-many relationships. In order to maintain data integrity and to ensure that you never end up with orphaned records, you’ll learn how to cascade delete related records, enforce referential integrity and casted update related fields. You end up by creating and then printing a relationship report.

· Advanced Queries. Next, we’ll delve more deeply into the query object. We’ll learn how to create multi-table queries, using calculations in queries and change query properties. We’ll create expressions both manually and using the expression builder. You learn how to prompt a user for criteria by creating a Parameter Query as well as summarize data using a Totals Query. Using queries, you’ll find duplicate records in your table as well as find unmatched records between tables. You’ll also learn how to modify query joins in this section.

· Action Queries. In this section, we begin working with Action Queries; that is to say, queries that change the data in your tables. We’ll add data to a table using a Make-Table Query, adding data to an existing table using an Append Query, change data in your tables using an Update Query and delete data using a Delete Query. We’ll even take a brief look at creating an SQL query.

· Working with Forms. We now begin working with Forms. Here, we’ll create a form using the Form Wizard and then learn how to enter data into a form. We’ll change the layout of a form using Design view, add fields to forms, finding records in a form and modify the form from Layout view. You’ll also work with changing the properties of controls on your form.

· Advanced Forms. In this section, we’ll delve into some of the more advanced features of Forms. We’ll add headers and footers to a form, learn how to add various controls to a form as well as move and size controls. We’ll also perform calculations using calculated controls and modify individual control properties. Additionally, you’ll learn how to change form properties, modify the tab order in a form, insert graphics and lookup data in a table or query using a Lookup control. We’ll also learn how to add a subform and why you may need to.

· Working with Reports. Next, we’ll begin working with Access reports. We’ll begin by creating a basic report, applying a theme to an existing report and move to creating a more advanced report using the Report Wizard. We’ll look at the different report views and learn how to modify reports from design view. We’ll also learn how to print reports and create a label merge using the Label Wizard.

· Advanced Reports. In this stage, we’ll begin working with some more advanced report features. We’ll work with the various report sections, add controls to reports and modifying control properties. You’ll learn how to create a calculated control and how to change a control’s data source. We’ll take a look at how to sort and group report data, change report section properties and even change a report’s data source. You learn how to insert graphics and apply conditional formatting to a report.

· Advanced Features of Forms and Reports. Here, you’ll learn how to add a subform or subreport using the Subform/Subreport tool. You’ll learn how to modify a subform, align controls relative to one another and creating options groups. We’ll also look at how to insert total fields in reports, edit sorting and grouping levels in a report and add some pizazz to our reports using lines, rectangles and borders.

· Importing and Exporting Data. Now we delve deeply into exporting and importing data to and from Access. You’ll learn how to import data from a text file, Excel or from another Access database. You’ll also learn how to link data between databases. We’ll then work with exporting data to a variety of formats: a PDF file, to another Access database, to Excel, to Microsoft Word as an RTF file and even performing a Microsoft Word mail merge directly from within Access.

· Working with Macros. In this section, we begin working with Microsoft Access macros. Here, you’ll learn how to create a macro, add macro actions and executing a macro step-by-step. We assign a macro to a command button, use macro groups and use macro conditions. You’ll learn how to create an AutoExec macro that executes when a database is first opened, an AutoKeys Macro which executes after certain keystroke combinations are pressed and even a Data Macro which is a macro that is added to events in your tables. We’ll end by learning how to add a macro to the Quick Access Toolbar.

· Creating a System Menu. In order to make your database as user-friendly as possible, you’ll learn how to create a Switchboard. You’ll learn how to add items to a switchboard, edit a switchboard, setting startup options and create a navigation form.

· Database Tools and Maintenance. We’ll finish off the course by learning how to maintain your databases. You’ll learn how to compact and repair databases, change database properties, document and analyze your databases and view database dependencies. We’ll also learn how to back up a database and split a database into a front end and back end. Lastly, we’ll learn how to password-protect a database.

By the end of this course, you’ll learn how to create, organize and manage your Access databases, allowing you to effectively remain in control of your data.

My Promise to You!

I'll be here for you every step of the way so if you have any questions at all that come up as you’re working through the course, please let me know. Feel free to post your question in the course or send me an email.

I want to ensure that this is the best course on how to use Microsoft Access so if you have any suggestions on how I can improve the course, please let me know.

Are you ready to begin your Microsoft Access journey? Then, click the enroll icon and let’s get started!

- Roger

Build a Sales Management Dashboard with Excel

Learning by Doing

Created by Marc Augier Programmation Web | Python | Bases de Données - Professeur passionné de nouvelles technologies

"]

Students: 24, Price: $89.99

Students: 24, Price:  Paid

This is not your usual Excel Course!

You have a lot of Data at hand in order to track your business but you need to find an easy  way to analyze it.

You have already followed a lot of Excel courses, read books and you know all these funny functions, but you have no idea about what to BUILD with them.

You don't like theory and are better  at learning by doing?

In this course I will show you step by step how to start working with raw data and turn it into a meangful, straigtforward, clear, easy to read dashboard. Did I mention it will be friendly as well?

This course is definitely what you were looking for: 100% practice, hands on from the begining. No big theory, no demonstration out of context.

The way it works

In this course you will follow me creating a dashboard to track the activity of a sales team. Starting from a big table of data, we will learn how to analyze and create a clear dashboard.

Lot of context, lot of practice, and lot of learning:

  • Functions (SUMIFS, COUNTIFS, VLOOKUP, MAX,MIN, etc.)

  • Naming cells, relative and absolute addresses

  • Pivot Tables

  • Graphics

All these concepts are covered along the creation of the dashboard.

The best part of it?

You can't be bored in this course, my French accent will keep you on track from the first second to the end!

LAW: OneNote e-Trial Electronic Digital Notebook – Extras

How to Make / Use a Microsoft OneNote Electronic Digital Notebook to increase law office and Court Trial Productivity

Created by Dana T. Blackmore, B.S., J.D., LL.M. - Lawyer and Law Professor

"]

Students: 23, Price: $34.99

Students: 23, Price:  Paid

This is an add-on to my course entitled: "LAW TRIAL NOTEBOOK: Making a OneNote Court e-Trial Notebook (Main Course)".

The Main Course is a study of all aspects of constructing an Electronic e-Trial Notebook using OneNote electronic notebook technology. Since constructing a good trial notebook should begin when the case first comes into the law office, this course will cover every aspect of pre-trial, trial and post-trial practice and procedure. In Part 5 of the Main Course, I teach you how to use your OneNote e-Trial Notebook during trial including:

  • How to play video excerpts directly from your OneNote e-Trial Notebook;

  • How to show exhibits to the judge or jury during trial directly from your OneNote e-Trial Notebook;

  • How to take quick written and audio notes for cross-examination of witnesses or for other uses;

  • How to use your cell phone or pad as a document scanner/camera to store copies of documents in your OneNote e-Trial Notebook for later use

In this Course, I’m going to talk to about some of the hidden extras in OneNote that you can use in your everyday law practice or to conduct activities as you prepare for trial. I’m going use the same case example we used in the Main Course – the automobile / pedestrian bicycle accident case: Winters v. Ramirez to show you some of the OneNote resources you can use to prepare for a deposition as you build your e-trial notebook in anticipation of trial including:

  • Part 1 - How to create OneNote Notebook Sections and Notebook Pages for all of the events associated with an upcoming deposition;

  • Part 2 - How to create Outlook Calendar and Google Calendar Meeting Details on your OneNote Notebook Pages;

  • Part 3 - How to turn on Dictation to dictate notes during events and how to turn on Audio Recording to record audio during events on your OneNote Notebook Pages;

  • Part 4 - How to create Drawings and insert Diagrams, photos, documents, etc on your OneNote Notebook Pages associated with meeting events and deposition events;

  • Part 5 - How to replay a drawing/diagram from your OneNote Notebook that was created during a deposition.

Microsoft Office 365 Masterclass: Complete Office 365 Course

Master Microsoft Office 365 and enhance your professional skills with this Complete Microsoft Office 365 Course.

Created by Janets - Quality Education for All - Online Course Provider

"]

Students: 23, Price: $19.99

Students: 23, Price:  Paid

Take the first steps on a new life journey by signing up for Microsoft Office 365 Masterclass: Complete Office 365 Course. Using Microsoft Office 365 in this ever-changing world and sector can sometimes be a challenging or intimidating affair. However, you can learn how to master Office 365 simply by enrolling in our easy-to-take and interactive Microsoft Office 365 Masterclass: Complete Office 365 Course. The contents will support your personal goals, and you can learn at a pace that suits your specific needs. Whether it is for personal interest or a business necessity, you deserve tuition from those best placed and qualified to give it to you. We have long-term experience with home education methods and are committed to providing quality training at a price that is right.

We have worked with industry professionals and online experts to ensure our courses are appropriate for each learner's specific needs. You do not have to needlessly spend money and valuable time searching for scraps of information or advice about Office 365. You should not need to rely on unverified sources or dubious websites. Microsoft Office 365 Masterclass: Complete Office 365 Course will provide the complete learning curve in one great experience that will raise your skills and knowledge to new heights, giving you a massive advantage in this area. You will be amazed at what can be accomplished outside a classroom and from the comfort of your home or study area. There is no better time to take this opportunity.

Make a break from inferior home education and reach for the top with the help of Janets Education.

Microsoft Office 365 SharePoint for End Users

Updated Version 2021

Created by Integrity Training - Certification Trainers for Over 20 Years

"]

Students: 23, Price: $99.99

Students: 23, Price:  Paid

Microsoft Office 365 SharePoint for End Users - Updated Version 2021

The Microsoft Office 365 SharePoint for End Users is a comprehensive course that covers the features, functionalities, management and usage of Microsoft Office 365 SharePoint with the perspective of end users. Microsoft SharePoint is primarily a document management and storage platform that is integrated with Microsoft Office suite and provides easy file sharing and collaboration amongst the team members of an organization. Microsoft Office 365 SharePoint provides similar functionality with enhanced features on cloud using a web based interface.

The course covers the entire landscape that is visible to the end user of Microsoft Office 365 SharePoint, starting from login screen, basic navigation to creating lists, assigning permissions etc. This course is designed in such a way that it helps the students to understand the usage of Microsoft Office 365 SharePoint and benefit from its features such as file sharing, groups, lists, libraries and applications. The course is designed keeping in mind the end users who are not usually IT literate, hence the course can be taken by personnel belonging to non-IT departments as well such as finance, HR, accounts and sales etc.

Overall, the course is very well designed and concisely timed to give an overview of the usage of Microsoft Office 365 SharePoint to its end users. The course enables the students to feel confident while using the software and make full use of its offerings and features.

Mastering OneNote 2013

Organize Your Work & Life Into Pages, Sections, and Notebooks!

Created by Chip Reaves - Bigger Brains

"]

Students: 18, Price: $34.99

Students: 18, Price:  Paid

Organize Your Work & Life Into Pages, Sections, and Notebooks!

OneNote is a powerful tool both for managing your own notes or idea, and for collaborating with others.

In this course trainer Christina Tankersley will walk you through everything you need to know to be efficient with Microsoft’s incredibly popular note-taking platform.

OneNote is great for task lists, brainstorming, meeting notes, collecting ideas, research, and more. In this course you will learn:

  • How to navigate inside OneNote notebooks, sections, and pages
  • Different options for organizing your notebooks
  • Using handwritten notes and converting them to text
  • How to add audio and video to your notebook
  • And more!

Learn Microsoft OneNote With Claudia

This OneNote course is suitable for Microsoft Office versions 2010, 2013, 2016, 2019 & Microsoft 365

Created by Claudia Carrozzo - Microsoft Certified Trainer & Microsoft Office Specialist

"]

Students: 17, Price: $19.99

Students: 17, Price:  Paid

Microsoft OneNote is much more than just creating simple Notebooks and being able to say goodbye to paper notes. 

With OneNote we can:

  • Share our notes

  • Access our notes across all our devices, as long as we have the OneNote app installed!

  • No limit on the number of Notebooks

  • No limit of sections

  • No limit of pages

  • Integrate Outlook emails, contacts, appointments and tasks

  • Integrate Word, Excel and PowerPoint

  • Creating Table of Contents (TOC)

  • Creating links between Notebooks, pages and sections

  • Audio & video recording and finding specific spots of what has been recorded in literally a couple of clicks

  • Extracting text from pictures, screenshots etc.

  • And... much much more! All of which will be covered during these tutorials

A little about me:

Prior to becoming a Microsoft Certified Trainer and Microsoft Office Specialist across the Microsoft Suite (previously Microsoft Office) in 2008, I used to work as a Corporate Professional where maximising my work and speeding up tasks were key.  Hence I decide to learn about all the tricks and tips that would really simplify my work.

It is for me a great satisfaction and joy to pass on my knowledge and receive feedback from my students who now feel so much more proactive and confident across the Microsoft applications.  My goal is to hear my students say "wow" about what they are learning!

In these tutorials I will share with you not only what I have learnt during my 13 years of training others in the Microsoft applications, but also the many years of knowledge that I have gained by working in high profile Global companies.  We will create real work scenario Notebooks which will truly help maximise and organise yourself on a daily basis.

Once this tutorial is concluded, you will feel fully confident in using this fantastic application and completely forget (if you wish) about paper notes. Most importantly, you will be able to access your notes, Outlook appointments, tasks and more, Word, Excel, PowerPoint all in one place by using the OneNote application. 

Cool isn’t it!

So… ready to enrol? I really look forward to having you onboard so that you can all say goodbye to paper notes and hello to OneNote and become 100% more productive!

Let’s get started!

Claudia Carrozzo MCT | MOS

Microsoft Access VBA – Create your own applications

Learn VBA to automate repetitive tasks in Microsoft Access and to create state of the art database applications.

Created by Qaisar Ali - M.Com., D.C.M.A., CMA, CFM, CIMA, CGMA, RPA

"]

Students: 16, Price: $59.99

Students: 16, Price:  Paid

When you know Visual Basic for Applications [VBA],  you can create macros to automate repetitive tasks which will save you a lot of time and boredom of doing the same thing over and over again. If you know how to use VBA in Microsoft Access, you are on top of all Access users because you know how to create state of the art database solutions. By learning Access VBA, you can:

  1. Manage smaller to medium size databases.

  2. Create you own defined functions.

  3. Manipulate data using advanced features of various objects of MS Access.

  4. Create a portable procedure to reuse as and when required.

  5. Animate data to get rid of non value added activities.

  6. Communicate with other applications and platforms.

Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and is functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. This course will help learners of any level get the most out of the Visual Basic for Applications (VBA) environment. Starting with the development environment and working through various aspects of VBA, you will learn the tools and techniques needed to build custom solutions using Microsoft Access.