Division of Bdreamz Global Solutions Pvt.
Ltd, India
Advanced Excel Syllabus Total Duration: 25Hrs
Date Formats Duration: 2Hrs
• Converting Dates in Serial Format to Month-Day-Year Format
• Converting Dates in Month-Day-Year Format to Serial Format
• Obtaining Today's Date
• Finding a Workday after Specified Days
• Customizing the Definition of a Weekend
• Number of Workdays between two given Dates
• Extracting Year, Month, Day from Date
• Extracting Day of the Week from Date
• Obtaining Date from Year, Month and Day
• Calculating Years, Months and Days between two Dates
Conditional Formatting Duration: 2Hrs
• Highlight Cells Rules
• Top / Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• New Rule
• Clear Rules
• Manage Rules
Sorting Duration: 2Hrs
• Sort by Text
• Sort by Numbers
• Sort by Dates or Times
• Sort by Cell Color
• Sort by Font Color
• Sort by Cell Icon
• Sort by a Custom List
• Sort by Rows
• Sort by more than one Column or Row
Division of Bdreamz Global Solutions Pvt. Ltd, India
Filtering Duration: 2Hrs
• Filter by Selected Values
• Filter by Text
• Filter by Date
• Data Analysis with Excel
• Filter by Numbers
• Filter by Cell Color
• Filter by Font Color
• Filter by Cell Icon
• Clear Filter
• Advanced Filtering
• Filter Using Slicers
Other Topics Duration: 2Hrs
• Subtotals with Ranges
• Subtotals
• Nested Subtotals
• Quick Analysis
• Quick Analysis with TOTALS
• Sum
• Average
• Count
• %Total
• Running Total
• Sum of Columns
Lookup Functions Duration: 2.5Hrs
• Using VLOOKUP Function
• Using VLOOKUP Function with range lookup TRUE
• Using VLOOKUP Function with range lookup FALSE
• Using HLOOKUP Function
• Using HLOOKUP Function with range lookup FALSE
• Using HLOOKUP Function with range lookup TRUE
• Using INDEX Function
• Using MATCH Function
Division of Bdreamz Global Solutions Pvt. Ltd, India
Pivoting Duration: 2Hrs
• PivotTables
• Creating PivotTable
• Recommended PivotTables
• PivotTable Fields
• PivotTable Areas
• Nesting in the PivotTable
• Filters
• Slicers
• Summarizing Values by other Calculations
• PivotTable Tools
• Using Pictures in Column Charts
• Band Chart
• Thermometer Chart
• Gantt Chart
• Waterfall Chart
• Sparklines
• Pivot Charts
• PivotChart from PivotTable
• PivotChart without a PivotTable
• Working with Multiple Sheets
• Multiple Worksheets with same Structure
• Creating a Formula across Multiple Worksheets
• Summarizing Data in Multiple Worksheets
• What-If Analysis
Power query Duration: 3Hrs
• Connection to data sources
• Connecting a file
• Connecting a folder
• Connecting a database
• Loading the data
• Perform transformations
• Advanced transformation
• Data cleaning
• Data prep
Division of Bdreamz Global Solutions Pvt. Ltd, India
MIS Reports In Excel Duration: 1.5Hrs
Data Analysis Duration: 2Hrs
Descriptive Statistics
• Mean
• Mode
• Median
• Variance
• Standard Deviation
• Range
• Correlation
• Regression
Project work Duration: 3Hrs
Resume Preparation assistance, Interview Questions and
Documents sharing Duration: 1Hr
