The Huge Microsoft Excel Training Bundle - Beginner to VBA

Udemy

Develop a deeper understanding of the basic as well as advanced concepts and functionalities of Microsoft Excel ...Read more

Brochure

Enquire

Beginner

Online

₹ 449 3099

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study

                                    Mode of Delivery
                                    Video and Text Based

Intro to Excel 2019

Intro to Excel
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
Downloadable course transcripts
What's New In Excel 2019
Course Overview
Overview of the Excel window
Mouse-Features
Back Stage View
Section Quiz

Creating Workbooks

Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section Quiz

Saving Workbooks

Working with the Save and Save As Commands
File Extensions, Share, Export and Publish Files
Module 3 - Practice Exercise
Section Quiz

Navigating Workbooks

Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section Quiz

Page Setup & Print Options

Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section Quiz

Working with Rows, Columns and Cells

Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section Quiz

Moving Data

Cut, Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section Quiz

Formulas & Functions

Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section Quiz

Working with Sheets

Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section Quiz

Formatting Worksheets

Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section Quiz

Charts

Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section Quiz

Working with Names

Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section Quiz

Sorting and Filtering

Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section Quiz

Outlining and Subtotaling

Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section Quiz

Working with Views

Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section Quiz

Linking Files

Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section Quiz

Advanced Formula Creation

If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section Quiz

Pivot Tables

Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section Quiz

Additional Excel Features

Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tab
Module 19 - Practice Exercise
Section Quiz

Shortcuts

Excel Shortcuts Every User Should Know

Closing

Closing Video

Pivot Tables Beginner: Introduction

Course Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files
What are Pivot Tables and Why are They Useful?
Section Quiz

Pivot Tables Beginner: Preparing Data for Analysis

The Importance of Cleaning Data
Removing Blank Rows
Removing Duplicate Rows
Clearing Formatting
Applying Number Formatting
Changing the Case
Removing Spaces and Non-printing Characters
Merging and Splitting Columns
Convert Numbers Stored as Text
Finding and Replacing Text
Spell Check
Exercise 01
Section Quiz

Pivot Tables Beginner: The Importance of Excel Tables

Excel Tables vs Pivot Tables
Format Data as a Table
Exercise 02
Section Quiz

Pivot Tables Beginner: Creating a Basic Pivot Table Report

Using Recommended Pivot Tables
Creating a Pivot Table from Scratch
Pivot Table Ribbons and Fields
Pivoting the Fields
Adding Multiple Dimensions
Deleting Fields and Locking the Report Layout
Exercise 03
Section Quiz

Pivot Tables Beginner: Aggregation and Grouping

Methods of Aggregation
Combining Methods of Aggregation
Grouping and Ungrouping Data
Exercise 04
Section Quiz

Pivot Tables Beginner: Formatting Values

Applying Number Formatting
Handling Cells with No Data
Exercise 05
Section Quiz

Pivot Tables Beginner: Layout Options

Subtotals and Grand Totals
Choosing a Report Layout
Inserting Blank Rows
Exercise 06
Section Quiz

Pivot Tables Beginner: Formatting Pivot Tables

Applying Pivot Table Styles
Modifying Pivot Table Styles
Creating a Custom Pivot Table Style
Exercise 07
Section Quiz

Pivot Tables Beginner: Sorting and Filtering

Sorting Pivot Table Data
Filtering Pivot Table Data
Top 10 Filter
Exercise 08
Section Quiz

Pivot Tables Beginner: Creating Pivot Charts

Selecting the Right Chart Type
Clustered Column and Bar Charts
Line Charts
Pie and Donut Charts
Map Charts
Applying Chart Layouts
Exercise 09
Section Quiz

Pivot Tables Beginner: Formatting Pivot Charts

Adding a Slicer
Formatting a Slicer
Adding a Timeline
Connecting Slicers and Timelines
Exercise 10
Section Quiz

Pivot Tables Beginner: Applying Conditional Formatting

Highlight Cell Rules
Data Bars
Color Scales
Icon Sets
Exercise 11
Section Quiz

Pivot Tables Beginner: Updating Pivot Tables and Pivot Charts

Adding Data to the Dataset
Updating Pivot Tables and Pivot Charts
Exercise 12
Section Quiz

Beginner: Course Close and Next Steps

Course Close and Next Steps

Pivot Tables Advanced: Introduction

Introduction to Advanced Pivot Tables
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files
PivotTables Recap
Section Quiz

Pivot Tables Advanced: Importing Data

Importing Data From a Text File
Importing data from Access
Exercise 01
Section Quiz

Pivot Tables Advanced: Preparing Data for Analysis Cleaning Data

Tabular Data
Exercise 02
Section Quiz

Advanced: Creating and Manipulating PivotTables

Creating and Manipulating a PivotTable
Combining Data from Multiple Worksheets
Grouping and Ungrouping
Report Layouts
Formatting Error Values and Empty Cells
Exercise 03
Section Quiz

Advanced: Formatting PivotTables

PivotTable Styles
Custom Number Formatting
Exercise 04
Section Quiz

Pivot Tables Advanced: Value Field Settings

Summarizing Values
Show Values As
Exercise 05
Section Quiz

Advanced: Sorting and Filtering

Advanced Sorting
Advanced Filtering
Exercise 06
Section Quiz

Advanced: Interacting with PivotTables

Inserting and formatting Slicers
Inserting and formatting Timelines
Connecting Slicers to Multiple PivotTables
Using Slicers in Protected Workbooks
Exercise 07
Section Quiz

Advanced: Calculations

Creating a Calculated Field
Creating a Calculated Item
Solve Order and List Formulas
GETPIVOTDATA
Exercise 08
Section Quiz

Advanced: Pivot Charts

Creating a Pivot Chart
Formatting a Pivot Chart - Part 1
Formatting a Pivot Chart - Part 2
Creating a Map Chart using Pivot Data
Dynamic Chart Titles
Include a Sparkline with your PivotTable
Exercise 09
Section Quiz

Advanced: Conditional Formatting

Highlighting Cell Rules
Graphical Conditional Formats
Conditional Formatting and Slicers
Exercise 10
Section Quiz

Advanced: Dashboards

Creating an Interactive Dashboard - Part 1
Creating an Interactive Dashboard - Part 2
Updating Pivot Charts and PivotTables
Exercise 11
Section Quiz

Pivot Tables Advanced: Course Close

Course Close

Introduction to Excel for Business Analysts

Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files

The Basics

A Recap of Basic Formulas
Absolute vs Relative Referencing
Exercise 01
Section Quiz

Merging and Looking Up Data

Merging Data from Different Sources
Looking up Information with VLOOKUP (Exact)
Looking up information with VLOOKUP (Approx)
How to use VLOOKUP with Data that Expands
Using HLOOKUP
Combining VLOOKUP and MATCH
Using INDEX, MATCH and XLOOKUP
Data Validation Lists with Lookups
Exercise 02
Section Quiz

Making Better Decisions with IF

How to use the IF function
More Examples of the IF Function
Working with Nested Ifs
The IFS function
Error handling with IFERROR and IFNA
Using MAX and MIN instead of the IF function
Using SUMIFS and COUNTIFS
Exercise 03
Section Quiz

Preparing Data for Analysis

Splitting Data Using Text Functions
Using the Flash Fill command
Concatenating Data
Standardizing Data
Formatting Data as a Table
Exercise 04
Section Quiz

PivotTables

An introduction to PivotTables
Creating a PivotTable
Summarizing Data
Calculations in PivotTables
Using Slicers to Filter information
Exercise 05
Section Quiz

Visualizing Data with Charts

Creating a Pivot Chart
Formatting a Pivot Chart
Using Sparklines
A Basic Interactive Dashboard
Exercise 06
Section Quiz

Forecasting

Forecast Sheets
The Forecast Function
Exercise 07
Section Quiz

Additional Useful Tools in Excel

Conditional Formatting
The INDIRECT function
The OFFSET function
Using Histograms
Regression
Exercise 08
Section Quiz

WhatIf Analysis

Goal Seek
Scenario Manager
Data Tables
Solver
Exercise 09
Section Quiz

Course Close

Course Close

Course Close

Course Close

Intro to Advanced Formulas in Excel

Course Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Files

Advanced Formulas

Filter a Dataset Using a Formula
Sort a Dataset Using a Formula and Defined Variables
Multiple Dependent Dynamic Drop-down Lists
Perform a 2-way Lookup
Make Decisions with Complex Logical Calculations
Extracting Parts of a Text String
Creating a Dynamic Chart Title
Finding the Last Occurrence of a Value in a List
Looking Up Information with XLOOKUP
Find the Closest Match to a Value
Section Quiz

Macros and VBA Course Introduction

Introduction
WATCHE ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Files
DOWNLOAD ME: Course Transcript
Using Macros to Automate Repetitive Tasks
VBA Explained
Section Quiz

Creating Macros

Recording, Saving and Running a Macro
Recording a Macro with Relative Referencing
Complex Macros
Recording a Macro to Sort and Filter Data
Protecting cells with a Macro
Section Quiz

Editing Macros with VBA

The VBA Editor
Understanding VBA Code
Editing Macros
Debugging Macros
Creating a Macro from Scratch
Section Quiz

Custom Macro Ribbon

Creating a Macro Custom Ribbon

Additional Training

READ ME: This Additional Training Is Optional
Ten Excel Tips and Tricks - Part 1
Ten Excel Tips and Tricks - Part 2
Ten Excel Tips and Tricks - Part 3

Popular Courses

Popular Platforms

Popular Searches