Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA
4.2 (129 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,613 students enrolled

Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA

Mastery Series of Complete Microsoft Excel, Microsoft Word, Excel Macros & VBA in One! (Excel 2016, 2019 & Office 365)
4.2 (129 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
18,613 students enrolled
Created by Sam s
Last updated 6/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 21 hours on-demand video
  • 77 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Master Microsoft Excel - From Beginner to Advanced
  • Master Microsoft Word - From Beginner to Advanced
  • Master Excel VBA & Macros
  • Learn Excel from scratch or fill in the gaps to become confident immediately
  • Explore the potential of Power Query. You will be surprised at what you achieve with a bit of Power Query knowledge
  • Get lifetime access to all these courses including quizzes, exercises & FREE access to new featured topics
  • Learn how to take full advantage of Microsoft Word
  • Learn each ribbon functions in MS Word
Requirements
  • Require a computer with Word installed (2010, 2013 or Word 2016 - All versions after 2007 were pretty much same).
  • Require a computer with Excel installed (2016 version or later recommended) and a willingness to learn.
  • No prior knowledge of Microsoft Word or Microsoft Excel is required as each step is explained in this Mastery series course.
Description

Why to buy individual courses when this complete package will give you everything you need! Boost your career and stand out from others in crowd!!

1. Microsoft Word (Basic course)

2. Microsoft Word (Advanced course)

2. Microsoft Excel (Basic course)

4. Microsoft Excel (Advanced course)

3. Unlock Macros & VBA Programming course

Microsoft Excel all-in-one Package - Become a certified Excel Ninja with #1 Excel course:

  • Looking for an online Excel course to improve your skills and save time but don't know where to start?

  • I have picked out the Excel Essential skills and packaged them in a structured course.

  • I will take you step-by-step through engaging video tutorials and teach you everything from scratch & to be able to use VBA to improve your work flow, save time and automate your current Excel projects.

Microsoft Word complete Package - Don't use just Word, learn tips and tricks with this course to be a smart user. This course includes basic level, intermediate level and advanced level of MS Word. Enroll now to go from beginning to Advanced user. At completion of this course you will have mastered the Microsoft Word.

Microsoft Excel:

By the end of the course you'll be confident, writing robust & elegant formulas and functions from scratch, allowing you to:

  • Input Data and Navigate Large Spreadsheets

  • Easily build dynamic tools & Excel dashboards to filter, display and analyze your data

  • Apply Excel hacks to get your work done faster

  • Be able to choose right Excel formula to automate your data analysis (Excel IF Function, ROUND and more)

  • Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions

  • Get Answers from your Data

  • Organize, Clean and Manage Large Data

  • Create Interactive reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines

  • Import & transform data with tools like Get & Transform (Power Query)

  • Manipulate dates, times, text, and arrays

  • Reduce manual routine tasks to the click of button

  • VBA programming & read, write own Macro to automate the tasks

We will dive into a broad range of Excel formulas & functions. Below are some Excel Features & Functions that you will learn:

  • Useful Excel shortcuts for data entry and navigation.

  • Protect your Excel files and worksheets properly.

  • To apply formatting correctly for cleaner and more professional reports.

  • To use important features like drop-down lists and add data validation to the cells. The way you can restrict users to type the data which can be input in each cell.

  • Add Comments & Notes to cells & how to print the same if needed.

  • Add Data & time Stamps to your reports.

  • Lookup/Reference Functions.

  • Statistical Functions.

  • Logic Functions.

  • Text Functions.

  • Date & Time Functions.

  • The most useful & powerful functions such as COUNT, COUNTIFS, SUMIFS, SUMPRODUCT, Nesting IF functions by nesting AND and OR within them and many more.

  • Excel features that will help you to organize and structure data so it makes (Sort, Filter, Search & Replace Go to Special, combine text with & character.)

  • Excel Pivot Tables & Pivot Charts so that you can quickly get insights from your data.

  • What Excel Power Query can do for you and how easy it is to combine data from different spreadsheets

  • Use Power Query to unpivot the data drive another Pivot Table, transform messy data to tabular data.

  • Join Multiple Tables & create long table using Power Query that can be used to feed business intelligence solutions & Pivot Tables.

  • Import data from Text File.

  • Three different ways to run the Macro i.e. from Macro Dialog, Using Keyboard Shortcuts & using buttons.

  • More than just Excel! VBA (Visual Basic for Applications) from Scratch to advanced.

Microsoft Word:

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

  • Creating Dynamic Microsoft Word Documents

  • Effectively Formatting a Document with Styles

  • Prepare Documents for Printing and Exporting

  • Manage Large Documents

  • Working with Page and Section Breaks

  • Control Page Orientation

  • Create and Manage Table Layouts

  • Work with Tab Stops to Align Content Properly

  • Insert Media and Images

  • Perform Mail Merges to create Mailing Labels and Form Letters

  • Manage Templates

  • Protect Documents from Edits

  • Track and Accept/Reject Changes to a Document

  • Build Dynamic Table of Contents

  • and much, much more...

What differentiates this course from other Courses?

Yes, there are many Microsoft Office Courses out there teaching you the important functions and features you need to master. BUT, do you get step-step-step learning with of Microsoft Word, Microsoft Excel with Quizzes, Exercises and VBA programming all in one course?


So, what are you waiting for? Enroll Today and take the next step in mastering Excel, Word and VBA Programming. Boost your career and stand out from others in crowd. Go from Novice to Ninja in all this complete package of Microsoft Word, Microsoft Excel, Macros & VBA! Become a certified Excel, Word & VBA Ninja Today.

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

Who this course is for:
  • This online course is suitable for anyone who wants to learn Excel from Scratch to VBA Programmer in order to edit the recorded macro for automating the tasks.
  • This MS Office Course will take you through 4 levels of Microsoft Word & Excel Topics (Beginner, Intermediate, Advanced and Beyond).
  • Whether you are a working professional, student, teacher, freelancer, or entrepreneur, this training can benefit you and help to take your skills to the next level.
  • This is being utilized in almost every office in the world, thus offers a great scope. Excel is highly used in decision making and a kind of analysis tool that represents data into graphical form.
Course content
Expand all 172 lectures 21:09:13
+ Microsoft Excel 101 - An Introduction to Excel
3 lectures 22:43

The ribbon includes various tabs when Excel is opened such as Home, Insert, Page Layout, Formulas, Data, Review, View, and Help, the area below the ribbon displays a set of groups and, within the groups, buttons representing a variety of commands. In this lesson, we will understand the terminology and elements of the Ribbon.

Preview 06:49

Recognize the mains terms used to describe Excel's Canvas.

The Work Surface - Workbook and Worksheets
07:21

Navigating the Excel Interface by utilize the keyboard or mouse to select cells and ranges in a spreadsheet & learn useful Keyboard Shortcuts saves lots of time in Excel.

Navigation Tools with 100+ Keyboard Shortcuts
08:33
+ Getting to Know Excel Step-By-Step
6 lectures 31:13
Your First File
06:27
Formatting
07:59
Work with Alignment and Wrap text
03:57
Hiding or unhiding of Rows and Columns
04:53
Basic Math
06:36

Download the Attached File for more complete details.

Bonus - Get Digital Marketing Toolkit with Resell Rights
01:21
+ Cell Referencing & Excel Functions
9 lectures 01:23:25
Formula Anatomy
08:37
Absolute and Relative Cell Referencing
15:34
Functions Anatomy
09:02
Math Functions
09:28
Statistical Functions
07:37
Logic Functions
08:47
Text Functions
11:02
Understanding Dates & Time
11:57

Download the Attached File for more complete details.

Bonus to Achieve the Success in your Life
01:21
+ Lookup & IF Family Functions
8 lectures 01:08:32
Conditional Math - SUMIF, COUNTIF & SUMPRODUCT Functions
09:26
External Links
07:50
Temporal Functions - EOMONTH & EDATE Functions
08:14
VLOOKUP with Approximate Match
09:44
VLOOKUP with Exact Match
08:11
Using lookup with Large Tables
06:08
Nesting Lookup Functions
07:14
Lookup Functions - Hlookup, Index, Match & Index with Match
11:45
+ Optimizing Data: Sorting, Filtering & Tables
4 lectures 51:57
Basic & Advanced Sorting
15:40
Basic & Advanced Filtering
19:37
Naming Ranges
08:18
Excel Tables
08:22
+ Quick Insights with Excel Pivot Tables & Data Analysis Tools
8 lectures 01:13:10
Creating Pivot Tables
06:48
Formatting Pivot Tables
09:32
Calculated Fields in Pivot Tables
06:54
Slicers to Calculate & Manipulate Fields
09:42
Grouping by date, time and other factors
13:24
Pivot Chart
06:32
What-If analysis & Data Analysis Tools
11:11
Solver in Excel
09:07
+ Formatting including Conditional & Number Formatting in Excel
5 lectures 48:34
Cell Formatting
07:46
Outlining
16:42
Build own Custom Number Formats
09:32
Conditional Formats with Built-in Rules
07:43
Conditional Formats with Custom Rules
06:51
+ Working with Excel Charts
8 lectures 50:15
Column Charts
05:00
Bar Charts
05:55
Pie Charts
06:48
Line Charts
06:18
Waterfall Charts
04:04
Sparklines
08:15
Combination Charts - Area and Line
07:24
Combination Charts - Column and Line
06:31