Microsoft Excel- Complete Master Program in MS Excel [2022]

Core Excel, Core Formulas and Functions, Pivot Tables, Data visualization with charts, 200+Shortcuts, Practical Examples

3.85 (270 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
17,604
students
12.5 hours
content
Jan 2022
last update
$49.99
regular price

What you will learn

******At End of this course you are become a master in Excel*****

*****You will become a Master in Excel Basics*****

At end of the course you are become a Master in Pivot Tables, Data visualization with charts, dynamic Arrays, core formulas, excel shortcuts

*****Build a solid understanding of ESSENTIAL Microsoft Excel functions*****

Solve complicated Excel problems WITHIN MINUTES

*****Conduct effective analytics - THOUSANDS OF TIMES FASTER*****

****Impress your boss, colleagues, partners by being THE BEST at Excel in the office****

Harness full potential of Excel by creating Pivot tables with slicers

Description

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Microsoft Excel- Complete Master Program in MS Excel [2021] will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy Expert you can build on.

What you'll learn

An accelerated, step-by-step program to give you a strong foundation to Expert Level Skills

Core Excel

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Core Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy foundation you can build on.

Core Excel Formulas and Functions

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas and Functions today.

Core Pivot

If you use Excel, but don't know how to use Pivot Tables, you're missing out...wasting time trying to do things that a Pivot Table can do for you automatically. With a small investment, Pivot Tables will pay you back again and again.

Core Charts

A picture is worth a thousand words. Nothing beats an effective chart for presenting data in a way people can instantly understand. Excel has a powerful and deep charting engine built right in, so you already have the tools you need to create a wide range of charts and visualizations. This course will untangle and demystify Excel's powerful charting tools, so you can create effective charts quickly and painlessly.

Excel Shortcuts

Shortcuts turbocharge your productivity in Excel: they help you work faster & more accurately, they let you focus on your work (not Excel's interface), and they unlock Excel's most powerful features. But shortcuts require practice to master. This video course covers over 200 Excel shortcuts, and includes a full set of practice worksheets. Start using more Excel shortcuts today!

Excel Tables

Excel Tables offer an easy way to create dynamic ranges that adjust when data changes. This makes tables perfect for pivot tables, charts, and dashboards that need to show the latest data. This course covers the key benefits of tables, including a detailed review of structured references, the special formula language for tables. Examples include VLOOKUP, INDEX and MATCH, and SUMIFS. The course also covers, table styles, slicers, filtering, sorting, and removing duplicates.

Conditional Formatting

One of the hottest trends today is data visualization. Why? Because when data is presented visually, people understand it immediately. This course will show you how to use Excel's conditional formatting to communicate key insights with clarity and impact. This is an accelerated program that takes you step-by-step through the capabilities of this powerful tool.


Happy Learning!


Content

Introduction

Shortcuts-entering data
How i Design this course

Microsoft Excel Basics >>>>> (Module-I) <<<<<

Excel - Overview
Open and Close Excel Appilication
Window controls to Maximize, Minimize and Restore Excel Window
Resize and Move Excel Window
Components of excel workbook user interface
Customize Excel Ribbon
Quick Access Tool Bar in Excel
Configure password for Excel file to prevent unauthorized Access
Row, Column and Cells in Excel Worksheets
Change Row Height in Excel
Change Column Width in Excel
Hide and unhide Rows and Columns in Excel
Insert Rows and Columns in Excel
Insert and Delete cells in Excel
Delete Rows and Columns in Excel
Range and Types of Ranges in Excel
Insert, Rename and Delete worksheets in Excel
Hide and Unhide Worksheets
Free panes Rows and Columns in Excel

Entering Data in Excel

Enter Data in Excel
Delete Data in Excel
Edit Data in Excel
Use the fill handle to enter data in Excel
enter custom patterns with the fill handle in Excel
Move data in Excel
Duplicate Data in Excel
Use drag and drop in Excel

Find and Replace in Excel

find a value in Excel
find a formatted value in Excel
find all matches at once in Excel
find and replace a value
find and replace formatted values in Excel

Font Formatting in Excel

Format Font and Font Size
Bold, italic and underlining styles
Change font colour
Different Underlining options in Excel
apply subscript, superscript, and strikethrough formatting in Excel
insert symbols and special characters in Excel
format individual characters in Excel

Borders and fills

apply a border to cells in Excel
apply a fill to cells in Excel
draw borders and border grids in Excel
apply a border using ribbon presets in Excel
remove existing borders and fills in Excel

Conditional Formatting in Excel >>>>> (Module -II) <<<<<

What is Conditional Formatting
Create Conditional formatting Rule
Edit Conditional formatting Rule
Add Additional conditional formatting Rule
Delete Conditional formatting Rule

Built in Conditional Format Rules

Highlight Top and Bottom Values
highlight above and below average values
use data bars with conditional formatting
use color scales with conditional formatting
use Icon sets with conditional formatting
highlight text values with conditional formatting
show duplicate values with conditional formatting

Conditional formatting with formulas

apply conditional formatting with a formula
Conditional formatting based on a different cell
Conditional formatting with one variable input
Conditional formatting with two variable inputs
highlight rows with conditional formatting
highlight rows using multiple criteria
add a conditional formatting key
check line length with conditional formatting
build a search box with conditional formatting
create zebra stripes with conditional formatting
compare two lists and highlight differences

Core Formulas and Functions ->>>>> (Module III) <<<<<

What is a Formula and function?
How to use operators in formulas
The order of operations

Cell References in Excel

What is a cell reference?
What's a relative reference?
relative references - example
What's an absolute reference?
absolute references - examples
Mixed reference in Excel

Named ranges

Named ranges as absolute references
create a named range
create a named constant
What is a dynamic named range
create a dynamic named range with a Table

Date and Time Functions

Create Full Date using DATE Function
Extract Year, Day, Month values using YEAR, MONTH, DAY functions
Generate Time Using HOUR,MINUTE,SECOND and TIME Functions
get time between dates in years, months, or days using DATEDIF and YEARFRAC
Generate past, future and end dates using EDATE() and EOMONTH() Function
Generate weekday and week number using WEEKDAY() and WEEKNUM() functions

Information Function in Excel

Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR

Excel- Logical Functions

Logical Functions - AND () Function
Logical Functions - OR () Function
Logical Functions - NOT() Function
Logical Functions - IF and IFS functions

Excel- Statistics Functions

Count Items using COUNT () Function
Count items based on criteria using COUNTIF() Function
Find Total using SUM () Function
Find Total based on conditions using SUMIF () Function
Find Minimum and Maximum values using MIN () and MAX () Function
Generate averages using AVERAGE () Function

Excel- Text Functions

TEXT Functions---> LEFT, RIGHT, MID () Functions
TEXT Functions -----> LEN () Function
TEXT FUNCTIONS -----> TRIM, CLEAN() Functions
TEXT Functions ------> UPPER, LOWER, PROPER() Functions

Microsoft Excel Tables >>>>>(Module- IV)<<<<<

What is an Excel Table
create an Excel Table
Excel Table Options
remove an Excel Table

Working with tables

Working with table rows and columns
How Excel Table ranges work
How to use Table filters
How to sort an Excel Table
How to add a totals row to a Table
remove duplicates from a table

Table formula examples in Excel

use SUMIFS with an Excel Table
Use VLOOKUP with a table
set up a running total in a table
Conditional formatting formula in a table
Data validation with an Excel table

Table Slicers in Excel

add a slicer to a table
use table slicer options

Table styles in Excel

Introduction to table styles
How to apply a table style
How to create a new table style
How to copy a table style to another file

Practical Scenarios on table

Why you should use a table for your pivot table
build a simple summary table
count items in a filtered list

Microsoft Excel- Shortcuts >>>>> ( Module-V) <<<<<

Excel Shortcuts -File Commands
Excel Shortcuts- Cell Editing
Excel Shortcuts-Cut, Copy and Paste
Excel Shortcuts- Undo, Redo
Excel Shortcuts- Entering Data
Excel Shortcuts-Find and Replace
Excel Shortcuts - Navigate workbook
Excel Shortcuts- Selecting Cells
Excel Shortcuts - Insert Rows and columns

Data Analysis With Pivot Tables- Introduction >>>> ( Module VI)<<<<<

Introduction to Pivot Tables

Building Pivot Tables

Add fields to a pivot table
rearrange fields in a pivot table
access field settings in a pivot table
format numbers in a pivot table
change the math used for pivot table values
control grand totals in a pivot table
control subtotals in a pivot table

Date Visualization with Core Charts >>>>(Module VII)

Data Visualization with bar chart
Data Visualization with line chart
Data Visualization with column chart

Screenshots

Microsoft Excel- Complete Master Program in MS Excel [2022] - Screenshot_01Microsoft Excel- Complete Master Program in MS Excel [2022] - Screenshot_02Microsoft Excel- Complete Master Program in MS Excel [2022] - Screenshot_03Microsoft Excel- Complete Master Program in MS Excel [2022] - Screenshot_04

Reviews

Olukayode
September 27, 2023
It was awesome being enrolled in this course. It was as straight to the point. Would definitely recommend ?
Amal
June 15, 2023
This course explains from the simplest thing to the most difficult portion of excel. The course is simple and is effective.
Mohammad
April 23, 2023
Keep up good work awesome course I m in the mid i m leaving a review because the course is in detail with explanation step by step. The course provider has expert excel communication skills which increase my potential in excel. Thank you Sir
Mica
January 7, 2023
While instructor seems knowledgeable, he is lacking in eloquence. Very thick accent that is impacting his clarity. Also says 'ok" too many times
Bassem
August 3, 2022
One of the best courses related to excel .The instructor explain step by step . Only the English accent is difficult to understand. thank you Rajesh
Vanshika
January 15, 2022
very easy to understand , and it my honest review, if youre from india and want to learn excel this is a very good course
Akhil
August 27, 2021
the way of teaching is good , we understand each and every topic easily. But the speed of teaching is little bit slow, this course seems really helpful, right now I am at its 4th topic , I think very soon I have to make it 5 star rating. Lets' read .
Anshul
August 18, 2021
Very good Course, Easy Explanation, Explained each and everything completely, I understood everything completely.Thank you so much for this amazing course Dear Rajesh Sir. Thank you.
Muhammad
August 15, 2021
It should be requirement for every instructor to take a communication skills course before launching a course.
Ivandro
August 12, 2021
I apriciete and get a lot experience with this course i´d to explore more things in Excell thanks for this oportunity wish you better in your life
Dinesh
August 1, 2021
this course is good for me i am happy to join course simple teaching by the Guru ,i will be master on excel.wow great.
Princess
July 30, 2021
It was quite easy to follow step by step. It was challenging a few times to understand some pronunciations so I missed out on that information. But overall great course.

Coupons

DateDiscountStatus
7/26/2021100% OFF
expired
9/19/202288% OFF
expired

Charts

Price

Microsoft Excel- Complete Master Program in MS Excel [2022] - Price chart

Rating

Microsoft Excel- Complete Master Program in MS Excel [2022] - Ratings chart

Enrollment distribution

Microsoft Excel- Complete Master Program in MS Excel [2022] - Distribution chart

Related Topics

4185722
udemy ID
7/15/2021
course created date
7/24/2021
course indexed date
Bot
course submited by