Navigating easily in Excel

• Using the Ribbon – Tabs, Groups and Commands
• Cells, columns and rows
• Shortcut Keys combinations
• Freezing, splitting and zooming the screen
• Hiding columns and rows

Entering Data

• Formatting Dates and Times
• Check spelling
• Undo / redo
• Create and modify tables
• Sorting and Filtering tables

Start Creating Formulas

• Add,
• Subtract,
• divide and
• multiply
• What is cell reference

Start Using Built-in Excel Functions

• Manually type functions
• Use functions button
• AutoSum, Average, Count, Min and Max

Moving and Copying Data

• Cut, Copy and Paste
• Fill Handle
• Autofill
• Flash Fill
• Smart Tags

Organizing and Working with Multiple worksheets

• Renaming and coloring tabs
• Moving, copying and inserting worksheets
• Margins
• Headers and Footers
• Printing Options

Formatting with Excel

• Adjusting width/height of column/rows
• Cell alignments
• Wrapping and merging
• Formatting numbers

Creating and Editing Worksheets

• Introducing Flash Fill
• Selecting and Naming Cell Ranges
• Using Column Headers to define names
• Moving around the worksheet
• Copying one or more cells to many

Manipulating Numbers

• Creating, editing, and copying formulas
• Using the AutoSum button and built-in function
• Inserting Functions
• Using relative, fixed and mixed cell references
• Using names in formulas and validating cell entries

Working with Text in Excel

• Combining text from multiple cells into one string
• Copying cells containing formulas and passing only their resulting values

Analyzing Data

• Using the Quick Analysis tools
• Analyzing data from another source
• Filtering data with tables
• Adding data to tables
• Sorting data and creating a custom sort list

PivotTable

• Creating a PivotTable
• Editing and modifying a PivotChart

Formatting Worksheets

• Applying number formatting
• Formatting with styles

Lookup Functions

• HLOOKUP
• VLOOKUP

Introduction to Working with Macros

• Creating Macro
• Running Macro
• Editing Macro

Perform calculations on data

• Name groups of data
• Define Excel tables
• Create formulas to calculate values
• Summarize data that meets specific conditions
• Set iterative calculation options and enable or disable
• Automatic calculation
• Use array formulas
• Find and correct errors in calculations

Manage worksheet data

• Limit data that appears on your screen
• Manipulate worksheet data
• Define valid sets of values for ranges of cells

Reorder and summarize data

• Sort worksheet data
• Sort data by using custom lists
• Organize data into levels
• Look up information in a worksheet

Analyze alternative data sets

• Examine data by using the Quick Analysis Lens
• Define an alternative data set
• Define multiple alternative data sets
• Analyze data by using data tables
• Vary your data to get a specific result by using Goal Seek
• Find optimal solutions by using Solver
• Analyze data by using descriptive statistics

Advanced Functions

• V-Lookup Advanced
• V-Lookup with IFERROR – Multiple Match
• V-Lookup with IFERROR – Multiple Match in Dynamic Tables
• Compare: Compare and Highlight differences with Conditional Formatting
• H-Lookup Applying H-Lookup to Multiple Tables
• Pivot-Tables Creating and Modifying output using Pivot-Tables
• Dash-Boards Create an Attractive Dynamic Dashboard using Pivot Tables, Pivot Charts & Slicers
• Summarizing a Multi-sheet Workbook
• Conditional Formula: Using Logical IF with AND / OR Operators
• Creating a Macro and Editing in VB Editor
• Modifying the Macro using the VB Editor to dynamically update the changes in the Data Range