Microsoft Office 2013 - Excel

Microsoft Excel 2013 - Course Introduction

• Section 1-1 - Create Worksheets and Workbooks
• Creating New Blank Workbooks
• Creating New Workbooks Using Templates
• Importing Files
• Opening Non-Native Files Directly in Excel
• Adding Worksheets to Existing Workbooks
• Copying and Moving Worksheets

Section 1-2 - Navigate Through Worksheets and Workbooks

• Searching for Data Within a Workbook
• Using Go To and Name Box
• Changing Worksheet Order
• Inserting Hyperlinks

Section 1-3 - Format Worksheets and Workbooks

• Changing Worksheet Tab Color
• Modifying Page Setup and Inserting Watermarks
• Inserting and Deleting Columns and Rows
• Changing Workbook Themes
• Adjusting Row Height and Column Width
• Inserting Headers and Footers
• Setting Data Validation

Section 1-4 - Customize Options and Views for Worksheets and Workbooks

• Hiding Columns - Rows - Worksheets
• Customizing the Quick Access Toolbar and the Ribbon
• Managing Macro Security
• Changing Workbook Views
• Recording Simple Macros
• Adding Values to Workbook Properties
• Using Zoom
• Displaying Formulas
• Freezing Panes
• Splitting the Window

Section 1-5 - Configure Worksheets and Workbooks to Print or Save

• Setting a Print Area
• Saving Workbooks in Alternate File Formats
• Printing Individual Worksheets and Scaling
• Repeating Headers and Footers
• Maintaining Backward Compatibility
• Configuring Workbooks to Print
• Saving Files to Remote Locations

Section 2-1 - Insert Data in Cells and Ranges

• Appending Data to Worksheets
• Finding and Replacing Data
• Copying and Pasting Data
• Using AutoFill Tool
• Inserting and Deleting Cells

Section 2-2 - Format Cells and Ranges

• Merging Cells
• Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
• Using Format Painter
• Wrapping Text Within Cells
• Applying Number Formatting
• Applying Highlighting and Cell Styles
• Changing Text to WordArt

Section 2-3 - Order and Group Cells and Ranges

• Applying Conditional Formatting
• Transposing Columns and Rows
• Inserting Sparklines
• Creating Named Ranges
• Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals

Section 3-1 - Create a Table

• Creating a Table and Moving Between Tables and Ranges
• Adding and Removing Cells Within Tables
• Defining Titles

Section 3-2 - Modify a Table

• Applying Styles to Tables
• Banding Rows and Columns
• Inserting Total Rows
• Removing Styles From Tables

Section 3-3 - Filter and Sort a Table

• Filtering Records
• Changing Sort Order
• Sorting Data on Multiple Columns
• Removing Duplicates

Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions

• Utilizing References - Relative - Mixed - Absolute
• Defining Order of Operations
• Referencing Cell Ranges in Formulas

Section 4-2 - Summarize Data with Functions

• Utilizing the SUM Function
• Utilizing the MIN and MAX Functions
• Utilizing the COUNT Function
• Utilizing the AVERAGE Function

Section 4-3 - Utilize Conditional Logic in Functions

• Utilizing the SUMIF Function
• Utilizing the AVERAGEIF Function
• Utilizing the COUNTIF Function

Section 4-4 - Format and Modify Text with Functions

• Utilizing the RIGHT - LEFT and MID Functions
• Utilizing the TRIM Function
• Utilizing the UPPER and LOWER Functions
• Utilizing the CONCATENATE Function

Section 5-1 - Create a Chart

• Creating Charts and Graphs
• Adding Additional Data Series
• Switching Between Rows and Columns in Source Data
• Using Quick Analysis

Section 5-2 - Format a Chart

• Adding Legends
• Resizing Charts and Graphs
• Modifying Chart and Graph Parameters
• Applying Chart Layouts and Styles
• Positioning Charts and Graphs

Section 5-3 - Insert and Format an Object

• Inserting Text Boxes
• Inserting SmartArt
• Inserting Images
• Adding Borders to Objects
• Adding Styles and Effects to Objects
• Changing Object Colors
• Modifying Object Properties and Positioning Objects
• Course Close