Advanced Excel
Introduction to Advanced Excel | Excel sheet Creation, edit, save, Folder Creation | Project 1
Conditional Formatting & Data Validation
Cell reference, Conditional formatting| Data validation| Important functions in Excel, Remove duplicate values, Hyperlink| Filter, Unique, Sort, SortBY, Sequence, Randarray Functions|
Logical & Statistical functions
Logical functions | Sum & Count if functions| Graphics, Print area setup , Camera tool project| Statistical functions, mathematical functions , Date related functions, Financial Functions| Dsum, subtotal functions, Text functions, Insert object| Data extraction| Averageif& Averageifs.
Advanced Pivot Table
Classic pivot table and chart| Slicers, timelines and calculated fields| Building hierarchies in pivot tables| Advanced Pivot table data analysis
Advanced Formula for Data Analysis
Custom view, Header and footer, Text to column function| Goal seek, Solver, Scenario manager| Lookup| Project| Match and index function, Consolidating data
Advanced Formula for Data Analysis
Sparkline chart, People graph, Data forecast, Import text file| Mail merge, Consolidating data| Form data, Auditing tool, Web data, Speak cell | Macro, Password protection
Data Preparation and Cleaning
Importing data from various sources. | Handling missing values and duplicates. | Using Text-to-Columns and Flash Fill. | Data validation and error checking for quality assurance.|
Date and Time Analysis
Working with DATE, TIME, NETWORKDAYS, and EOMONTH. | Automating rolling date ranges for dynamic reports. | Calculating time differences in hours, minutes, and seconds. | Custom formatting for date and time (e.g., “MMM-YYYY”). | Dynamic date ranges and custom date logic with WEEKNUM, WORKDAY.INTL
Power Query (Get & Transform)
Importing and cleaning data from various sources| Merging and appending queries| Advanced filtering and transforming data
Introduction to Dashboard Design
Understanding the importance of dashboards | Planning a dashboard project| Data visualization best practices| Advanced Charts
First Floor, Kailas Plaza,
Pattom, Trivandrum- 695004