Microsoft Excel - Beginner to Advance with Example

Microsoft Excel Basic to Advance, Learn A to Z, Office 365/2023, 2010, 2013, 2016, Excel 2019, Zero to Hero guide
4.52 (2780 reviews)
Udemy
platform
English
language
Other
category
instructor
Microsoft Excel - Beginner to Advance with Example
159,699
students
4.5 hours
content
Mar 2024
last update
$54.99
regular price

What you will learn

Basic excel equations widely used in

Email shooting by using VBA Directly from excel to specific users

Hands on experience to the excel with understanding of shortcuts

Analytical dashboard creation

Data filtration, Border, Sr No., Format Painter

Codes used in VBA

Function today() and Equation additing

Command Dollar {$} understanding

Data Validation - Drop Down List creation

IF, Nested if, if(And) command

Use of Conditional Formatting with Example

Remove Duplicates value in Excel

Automate Boarder - Where data available

Understanding of VLOOKUP

Index - Match equation

Data Filter - Analyse data

Bar Chart, Pie Chart Creation - Dashboard

VBA Form Creation

Password Protected Mail shooting directly from excel

Complete idea about Pivot Table & Pivot chart

Screenshots

Microsoft Excel - Beginner to Advance with Example - Screenshot_01Microsoft Excel - Beginner to Advance with Example - Screenshot_02Microsoft Excel - Beginner to Advance with Example - Screenshot_03Microsoft Excel - Beginner to Advance with Example - Screenshot_04
2996272
udemy ID
4/13/2020
course created date
5/1/2020
course indexed date
Lee Jia Cheng
course submited by