Fundamentals Of Microsoft Excel (Basic MS Excel Training)

Working with Functions

• Using the paste function tool
• Absolute and relative cell references
• Using range name in functions
• Crested nested functions
• Logical functions (SUMIF, COUNTIF)

Working with Data

• Using Excel as a database
• Sorting Data
• Custom sorts
• Filtering using AutoFilter
• The Advanced Filter tools

Working with External Data

• Writing formulas in cells
• Using the formula bar
• AutoSum and other basic functions

Working with External Data

• Data consolidation
• Linking to another workbook
• Linking to an external database
• Getting data from the web

Collaboration tools

• Protecting a workbook
• Protecting worksheets and cells
• Adding comments to cells
• Sharing workbooks

What-if Analysis

• Using the scenario manager
• Creating and editing scenarios
• Creating a scenario report
• Using Goal Seek

Working with Outlines

• Applying an outline
• Automatic outlining
• Displaying and collapsing levels
• Modifying outline settings
• Creating subtotals

Analyzing Data with Pivot Tables

• Creating a pivot table
• Defining the source range
• Inserting, moving, and deleting fields
• Showing and hiding fields
• Grouping and ungrouping fields

Excel Macros

• About macros and VBA
• Macro security
• Recording macros
• Running a Macro
• Absolute and relative references
• Saving and distributing macros
• Assigning a macro to a button
• Editing macro code
• Automatic macros