Data Analytics - Advanced Excel
7 modules
English - Hindi Mix
Lifetime access
<p><em>The only Excel Course you will ever need !</em></p>
Overview
Professionally designed course for getting understanding of how to do effective and efficient Data Analysis..
This course will help you develop an understanding of how to use the various Excel Functions & tricks to work with different datasets and get the desired result!
A must attend course for everyone who work with Complex Data and want to generate meaningful information from the data!
Modules
DayWise - Course Curriculum
1 attachment
Accounts Basics
Excel Basics - Screen & Terminology
1 attachment
excelterminology
DAY 1: DATA CLEANING 1
6 attachments • 2 hrs
DAC - DAY1 : DATA CLEANING1
DAY 1: DATA CLEANING
StartupData
DAC_AE_EV_Day1_Text Functions
DAY1: DATA CLEANING - CONTINUED
Conditional Formatting
DAY 2: DATA SCREENING
10 attachments • 6 hrs
Excel Formulas and Functions-ExcelVibez
Text Functions Assignment
DAY 2 : DATA SCREENING LIVE SESSION
100 Most Useful Excel Shortcut Keys
Conditional Formatting - Basics - Part 1 || ExcelVibez || CA Alok A Sethi #excel #exceltips
Conditional Formatting with Data Validation (LIST) || CA Alok A Sethi #conditionalformatting #list
Conditional Formatting - Excel Vibez
Custom Formatting - Excel Magic Tricks
Custom Formatting
Conditional Formatting - Last Part
DAY3: DATA CRUNCHING
3 attachments • 1 hrs
Cell Referencing and Freezing !! by CA Alok A Sethi #excel #exceltutorial
Cell Freezing and Referencing - ExcelVibez
What IF Analysis - GOAL SEEK
DAY4: FINANCIAL DATA ANALYSIS
2 attachments • 1 hrs
Financial Functions in Excel - CA Alok Sethi
Recording_2023-03-31_22-58-40
DAY5: DATA AUTOMATION
5 attachments • 1 hrs
Macro practice - Excel Vibez
MACRO - FORMATTING - EXCEL VIBEZ
MacroforChartCreation
Recording_2023-03-30_23-1-46
LOOKUP FUNCTIONS IN EXCEL - Vlookup vs Hlookup vs Xlookup || #exceltips
Rate this Course
₹ 999.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?