Overview
Excel 2013 – Level 1
In this course, students will use Microsoft Office Excel 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.
Excel 2013 – Level 2
In this course, students will build upon the foundational Microsoft Office Excel 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.
Excel 2013 – Level 3
In this course students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.
Prerequisites
Excel 2013 – Level 1
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows 8 environment and be able to use Windows 8 to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Excel 2013 – Level 2
Excel 2013 – Level 1
Excel 2013 – Level 3
Students enrolling in this class should have experience working in Excel, creating, editing, and managing workbooks. Excel 2013 – Level 1, & Excel 2013 – Level 2.
Who Should Attend?
This course is intended for anyone who wish to gain the basic understanding of Microsoft Excel 2013 that is necessary to create and work with electronic spreadsheets.
Course Outline Level 1
- Identify the Elements of the Excel Interface
- Create a Basic Worksheet
- Use the Help System
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search for and Replace Data
- Spell Check a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
- Define the Basic Page Layout for a Workbook
- Refine the Page Layout and Apply Print Options
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
- Customize General and Language Options
- Customize Formula Options
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Functionality of Excel by Enabling Add-Ins
- Customize Advanced and Trust Center Options
Course Outline Level 2
- Apply Range Names
- Use Specialized Functions
- Leverage Questions and Testing to Write Formulas
- Use Logical and Lookup Functions to Find Answers to Questions
- Create and Modify Tables
- Sort and Filter Data
- Use Summary and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data Using Slicers
- Analyze Data Using PivotCharts
- Insert and Modify Graphic Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
Course Outline Level 3
- Update Workbook Properties
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis Toolpak
- Create Interactive Data with Power View
- Consolidate Data
- Link Cells in Different Workbooks
- Merge Workbooks
- Export Excel Data
- Import a Delimited Text File
- Integrate Excel Data with the Web
- Create a Web Query
