Audience | This course is designed for individuals interested in learning the foundational skills necessary to create and develop Microsoft® Office Excel® 2013 worksheets and workbooks in order to manipulate and analyze the data that is critical to the success of their organization. This course covers Microsoft Office Specialist exam objectives to help individuals prepare for the Excel 2013 Exam and the Excel 2013 Expert Exam. |
Description | Upon successful completion of this course, participants will be able to:
|
Prerequisites | To ensure success, participants will need to be familiar with using personal computers, should have experience using a keyboard and mouse, and be familiar with Microsoft® Office Windows® user interface. |
Suggested Class Size | Minimum 3 Maximum 12 |
Course Length | Full day |
Table of Contents | Lesson 1: Getting Started with Microsoft Office Excel 2013 Topic A: Navigate the Excel User Interface Topic B: Use Excel Commands Topic C: Create and Save a Basic Workbook Topic D: Enter Cell Data Topic E: Use Excel Help Lesson 2: Performing Calculations Topic A: Create Worksheet Formulas Topic B: Insert Functions Topic C: Reuse Formulas Lesson 3: Modifying a Worksheet Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows Topic B: Search for and Replace Data Topic C: Use Proofing and Research Tools Lesson 4: Formatting a Worksheet Topic A: Modify Fonts Topic B: Add Borders and Colors to Worksheets Topic C: Apply Number Formats Topic D: Align Cell Contents Topic E: Apply Styles and Themes Topic F: Apply Basic Conditional Formatting Topic G: Create and Use Templates Lesson 5: Printing Workbooks Topic A: Preview and Print a Workbook Topic B: Define the Page Layout Lesson 6: Managing Workbooks Topic A: Manage Worksheets Topic B: Manage Workbook and Worksheet Views Topic C: Manage Workbook Properties |