Microsoft Excel 2013 (MOS)

Introducing Excel

• Identifying What Excel Is Good For
• Seeing What's New in Excel 2013
• Understanding Workbooks and Worksheets
• Moving Around a Worksheet
• Using the Ribbon
• Using Shortcut Menus
• Customizing Your Quick Access Toolbar
• Working with Dialog Boxes
• Using Task Panes
• Creating Your First Excel Workbook

Entering and Editing Worksheet Data

• Exploring Data Types
• Entering Text and Values into Your Worksheets
• Modifying Cell Contents
• Applying Number Formatting

Essential Worksheet Operations

• Learning the Fundamentals of Excel Worksheets
• Controlling the Worksheet View
• Working with Rows and Columns

Working with Cells and Ranges

• Understanding Cells and Ranges
• Copying or Moving Ranges
• Using Names to Work with Ranges

Introducing Tables

• What Is a Table?
• Creating a Table
• Changing the Look of a Table
• Working with Tables

Worksheet Formatting

• Getting to Know the Formatting Tools
• Using Different Fonts to Format Your Worksheet
• Changing Text Alignment
• Using Colors and Shading
• Adding Borders and Lines
• Adding a Background Image to a Worksheet
• Using Named Styles for Easier Formatting
• Understanding Document Themes

Understanding Excel Files

• Creating a New Workbook
• Opening an Existing Workbook
• Saving a Workbook
• Organizing Your Files
• Other Workbook Info Options
• Excel File Compatibility

Using and Creating Templates

• Exploring Excel Templates
• Understanding Custom Excel Templates

Printing Your Work

• Basic Printing
• Changing Your Page View
• Adjusting Common Page Setup Settings
• Adding a Header or Footer to Your Reports
• Copying Page Setup Settings across Sheets
• Preventing Certain Cells from Being Printed
• Preventing Objects from Being Printed
• Creating Custom Views of Your Worksheet

Introducing Formulas and Functions

• Understanding Formula Basics
• Entering Formulas into Your Worksheets
• Editing Formulas
• Using Cell References in Formulas

Creating Formulas That Manipulate Text

• A Few Words about Text
• Text Functions

Creating Formulas That Count and Sum

• Counting and Summing Worksheet Cells
• Basic Counting Formulas
• Advanced Counting Formulas
• Summing Formulas
• Conditional Sums Using a Single Criterion
• Conditional Sums Using Multiple Criteria

Getting Started Making Charts

• What Is a Chart?
• Understanding How Excel Handles Charts
• Creating a Chart
• Hands On: Creating and Customizing a Chart
• Working with Charts
• Understanding Chart Types
• Learning More

Learning Advanced Charting

• Selecting Chart Elements
• User Interface Choices for Modifying Chart Elements
• Modifying the Chart Area
• Modifying the Plot Area
• Working with Titles in a Chart
• Working with a Legend
• Working with Gridlines
• Modifying the Axes
• Working with Data Series

Visualizing Data Using Conditional Formatting

• About Conditional Formatting
• Specifying Conditional Formatting
• Conditional Formats That Use Graphics
• Creating Formula-Based Rules
• Working with Conditional Formats

Creating Sparkline Graphics

• Sparkline Types
• Creating Sparklines
• Customizing Sparklines
• Specifying a Date Axis
• Auto-Updating Sparklines
• Displaying a Sparkline for a Dynamic Range

Enhancing Your Work with Pictures and Drawings

• Using Shapes
• Using SmartArt
• Using WordArt
• Working with Other Graphic Types

Customizing the Excel User Interface

• Customizing the Quick Access Toolbar
• Customizing the Ribbon

Using Custom Number Formats

• About Number Formatting
• Creating a Custom Number Format
• Custom Number Format Examples

Using Data Validation

• About Data Validation
• Specifying Validation Criteria
• Types of ValidationCriteria You Can Apply
• Creating a Drop-Down List
• Using Formulas for Data Validation Rules
• Understanding Cell References
• Data Validation Formula Examples

Creating and Using Worksheet Outlines

• Introducing Worksheet Outlines
• Creating an Outline
• Working with Outlines

Excel and the Internet

• Saving a Workbook on the Internet
• Saving Workbooks in HTML Format
• Opening an HTML File
• Working with Hyperlinks

Importing and Exporting Data

• Importing Data
• Exporting Data

Introducing Visual Basic for Applications

• Introducing VBA Macros
• Displaying the Developer Tab
• About Macro Security
• Saving Workbooks That Contain Macros
• Two Types of VBA Macros
• Creating VBA Macros

Appendix

Appendix B

• Video Tutorials