Scribd
Upload
110 views

Advanced Excel Syllabus

This document outlines an advanced Excel syllabus totaling 25 hours. It covers a wide range of Excel topics organized by duration including date formats, conditional formatting, sorting, filtering, lookup functions, pivoting, power query, data analysis, and descriptive statistics. It also includes project work and resume/interview preparation assistance.

Uploaded by

Pradeep
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
110 views

Advanced Excel Syllabus

This document outlines an advanced Excel syllabus totaling 25 hours. It covers a wide range of Excel topics organized by duration including date formats, conditional formatting, sorting, filtering, lookup functions, pivoting, power query, data analysis, and descriptive statistics. It also includes project work and resume/interview preparation assistance.

Uploaded by

Pradeep
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

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

You might also like