Excel Beginner to Pro
- Description
- Curriculum
- FAQ
- Reviews
If you want to become an expert in Excel it will help you to become an advanced professional in Excel.
if you want to become a pro in Excel to boost your productivity, and efficiency in excel?
If you are struggling while working with the excel sheets and their data?
If you are not sure how you can improve your skills in excel?
If any of the above questions answer is Yes, then this is the right course for you, with more than 80 tips which are covered in this course, which will make you an expert in Microsoft excel.
The following topics are covered in this course:
-
Productivity tips
-
Autofill & flash fill
-
CTRL + ALT shortcuts
-
cell protection and its usage
-
Advanced sorting & filtering
-
-
Formatting tips
-
Invisible text
-
Frozen pens
-
Custom number formats
-
formula formatting
-
snap to grid example
-
-
Formula tips
-
Unique & Duplicates
-
Formula auditing Tools
-
different Calculation Modes
-
Fuzzy-Match lookups
-
INDEX & MATCH with its example
-
-
Visualization tips
-
Filled Maps
-
Sparklines
-
Dynamic Ranges
-
Form Controls
-
Custom Templates
-
-
Pivot table tips
-
Custom Sort Lists
-
Date & Value Grouping
-
what are Slicers & Timelines and How to use them?
-
Cache Source Data
-
Conditional Formatting
-
-
Analytics tips
-
Data Modeling
-
Goal Seek & Solver
-
Outlier Detection
All these topics with a handful of examples with practical demonstrations.
At the end of this course, you will become a confident excel professional (Power User) who can do most of your excel work so easily with advanced formulas, interactive visuals and charts, which will save your time and will help you to achieve your goals.
-
-
3
Module Introduction -
4
Excel Footer - How to Customizing it
Lets learn how to customize the footers
-
5
Workbooks - Navigate Excel workbooks with CTRL shortcuts
When it comes to working with multiple excel workbooks, we need to navigate between them, so lets understand how we can navigate the workbooks.
-
6
Access Excel Ribbon tools with ALT key tips
Ribbon tools play important role in Excel, and we all need to understand it and then we can access it.
-
7
special options - Accessing Excel "Go To" special options
-
8
Clean the data - Removing blank rows in Excel
-
9
Clean the data - Splitting Text to Columns in Excel
-
10
Header and Footer in Page Layout
-
11
Creating Drop-Down Menus in Excel with Data Validation
-
12
Autofill & Flash Fill - How to fill Patterns
-
13
Customizing the Excel Ribbon Tools
-
14
Synchronous Scrolling Across Multiple Excel Workbooks
-
15
Extracting Unique Values from a List in Excel
-
16
Using Named Range & Table References in Excel Formulas
-
17
Protecting Cells & Formulas in Excel Workbooks
-
18
Multi-Level Row & Column Sorting
-
19
Configuring Advanced Filter Criteria in Excel
-
20
Module Introduction
-
21
Excel Formatting shortcuts
-
22
Spell checking in Excel
-
23
Snapping Objects to the Excel Grid
-
24
Hiding Excel Workbook Elements
-
25
Replicating Formats & Styles with Excel's Format Painter
-
26
Colour & Border Design Tips in Excel
-
27
Freezing Panes in Excel Worksheets
-
28
Split the data
-
29
Centering Across a Selection
-
30
Creating an "Invisible" Format
-
31
Zip Codes & Phone Numbers
-
32
Relative Reference
-
33
Grouping Worksheet Columns & Rows
-
34
Formatting Excel Errors with IFERROR
-
35
Converting Excel Text to Dates
-
36
Creating Dynamic Formats with Excel Formulas
-
37
Advanced Excel Number Formats
-
38
Module Introduction
-
39
Manual vs. Automatic Calculation Modes in Excel
-
40
Adding Line Breaks to Excel Formulas
-
41
Converting Units of Measurement with Excel Formulas
-
42
Building Real-Time Tools with TODAY & NOW Functions
-
43
Excel Formula Auditing Tools
-
44
Designing Pivot-Style Reports with Excel Formulas
-
45
Counting Words in Excel with LEN & SUBSTITUTE Functions
-
46
Configuring Dependent Drop-Down Menus with INDIRECT
-
47
Creating Custom Hyperlinks Between Excel Worksheets
-
48
Using Approximate Match VLOOKUP Functions
-
49
Combining INDEX & MATCH Functions
-
50
Finding Matching Items Across Lists in Excel
-
51
Counting Duplicate Values with SUMPRODUCT
-
52
Using Many-to-Many Lookups in Excel
-
55
Module Introduction
Introduction
-
56
Configuring Excel Chart Properties (Move & Size)
How to lock and unlock charts.
-
57
Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365)
lets see how we can use filled maps to show the data in Geo Maps
-
58
Customizing Excel Charts to Tell a Story
How to customize charts, let see in this session
-
59
Adding Sparklines to Worksheet Cells
Adding sparklines to worksheet cells
-
60
Designing Custom Chart Templates in Excel
lets see how we can customize the chart templates
-
61
Building Excel Heat Maps Using Colour Scales
In this session, we will see how we can use Heatmaps to show the distribution of the data.
-
62
Analysing Distribution with Histograms
-
63
Goal Pacing with Custom Excel Gauge Charts
-
64
Highlighting Time Periods with Combo Charts
-
65
Configuring Dynamic Chart Source Ranges
-
66
Creating Interactivity with Excel Form Controls
-
67
Module Introduction
-
68
Customizing the Pivot Table Field List
-
69
Autofitting Column Width in Pivot Tables
-
70
Pivot Table Outline & Tabular Layouts
-
71
Counting Non-Numerical Fields Using Pivots
-
72
Grouping & Ungrouping Dates with Pivot Tables
-
73
Enabling Multiple Pivot Table Filters
-
74
Grouping Values into Buckets with Pivot Tables
-
75
Adding Value Calculations to Pivot Tables
-
76
Configuring Pivot Table Slicers & Timelines
-
77
Advanced Pivot Table Conditional Formatting
-
78
Removing & Reviving Pivot Table Source Data
-
79
Adding Custom Sort Lists in Excel
