Advanced Excel for Data Analytics
₹500.00 ₹1500.00 67% OFF
/CourseBundles(34018)/3451762-Excel_for_Data_Anal.jpg)
Course Overview
Course Curriculum
1 Subject
Advanced Excel for Data Analytics - June 2023
42 Learning Materials
Course_Introduction
02_Excel_Basics
Excel Shortcuts
2.1_Printing_Excel
3_Formatting_Excel
3.1_Formatting
04_Cell_Operations
3.2_Excel_Cell_Operations
5_Cell_referceing_formulas
06_date_functions
1_Date_Time_Function
07_text_functions
1.1_Text_Functions
1.1.2_Textjoins_concat
1.1.3_Text_Functions (Find and Search)
1.1.4_Text_Functions(Substitute and replace)
1.1.5_Text Functions (Text and Value)
08_Mathematical_functions
1.2.1Maths Functions
1.2.2. Maths Functions_sumifs
1.2.3. Maths Functions_maxifs_minifs
09_Finanical_functions
1_Financial_Function
10_lookup_functions
6_Vlookup_Hlookup
7_Index_Match
Logical and Error Handling Functions
3.1_Logical_Error_Functions
11_Stastical_functions
4.1_Statistical_Function
12_datafiltering_sorting
2_Sort_Filter
13_pivot_table
8_Pivot_Tables
Introduction_charts
Charts_practicals
Charts
1.1_Excel_Charts_Data
1.13_Sparklines
6_Waterfall_Charts
Condtional_formatting
whatif analysis
Course Introduction
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy
