Overview:

Take your data analysis and reporting skills to the next level with Advanced Excel training. With this training, you’ll learn how to manipulate large data sets, perform complex calculations, and create custom reports and dashboards that provide valuable insights into business performance. You’ll also discover how to automate repetitive tasks, reduce errors, and save time by using advanced Excel features such as macros, pivot tables, and conditional formatting.

Objective:

This training focuses on providing participants with advanced Excel skills and techniques to effectively manage, analyze, and present data. By the end of the training, participants will be able to manipulate large data sets, perform complex calculations, and create custom reports and dashboards using advanced Excel features such as macros, pivot tables, and conditional formatting. Participants will also learn how to automate repetitive tasks, reduce errors, and save time, which will enhance their productivity and efficiency.

Course Outline:

1. Getting Start with Excel
   • Basic Calculations
   • Case Change
   • Cell References relative & Absolute
   • Join Text
   • Text Apart
   • Formula Bar
   • Row, Columns, Cells
   • Sheets, Zoom
   • Hiding/Unhiding Columns/Rows
   • Alignment
2. Data Formation 
   • Format Painter
   • Formatting Cell by fill & Border
   • Formatting Cell by font
   • Cell Margin
   • Replace All
   • Data Validation
   • Find & Replace
   • Paste Specials
   • Case Change
   • Freeze Panes
   • Subtotal
3. Data Summarizing
   • Advanced Filter
   • Filter Function
   • Colour Filter
   • Conditional Formatting
   • Sum Function
   • Consolidation
   • SUM Product Function
   • Accsending/Decsending
   • Formate Table
   • Dynamic Slice in Table
   • Data Group/ Ungroup 
4. Working with Dynamic Formula
   • Protect Sheet/ Unprotect Sheet
   • Column Function
   • Column Array Function
   • Picture Reference
   • Using Data Bars, Colors, Scales & Icon sets for great visual
   • Dynamic Vlookup
   • Hlookup
   • IF functions
   • Autofill options
   • Flash Fill
   • Nested IFO with other Functions
5. Advance Analysis Tool & Reporting
   • Using Data Bars, Colors, Scales & Icon sets for great visual
   • Use of AND, OR, NOT
   • Sumif, Sumifs
   • CountIIFs And AverageIfs Functions
   • Pivot Table
   • Table, Slicer
   • Average Value, Top/Bottom Analysis/Top/Bottom
   • 3D Sum Function
   • Concatenate
   • Trim