Microsoft Excel

What Will You Learn?

• Section I: Basic Excel (10 hours)
• Excel tutorial
• Text to Columns
• Concatenate
• Absolute Cell References
• Data Validation
• Time and Date Calculations
• Conditional Formatting
• Creating and Managing Templates
• Charts
• Pivot Tables
• Data Analysis – Overview
• Working with Range Names
• Hands-on practice
• Section II: Advanced Excel (15 hours)
• Date Formats
• 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
• Hands-on practice
• Conditional Formatting
• Highlight Cells Rules
• Top / Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• New Rule
• Clear Rules
• Manage Rules
• Hands-on practice
• Sorting
• 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
• Hands-on practice
• Filtering
• 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
• Hands-on practice
• Other Topics
• Subtotals
• Quick Analysis
• Running Total
• Hands-on practice
• Lookup Functions
• Using the VLOOKUP Function
• Using HLOOKUP Function
• Using the INDEX Function
• Using MATCH Function
• Hands-on practice
• Pivoting
• PivotTables
• PivotTable Fields
• Filters
• Slicers
• Summarizing Values by other Calculations
• PivotChart Tools
• Pivot Charts
• Working with Multiple Sheets
• What-If Analysis
• Hands-on practice