Microsoft® Office Excel 2013: Level 1

Course Objective: Students will create and edit Excel worksheets and workbooks, use formulas and functions, and apply formatting and printing techniques.

Prerequisites: To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts.

Contact us to discuss if this level is right for you.

What’s New in 2013: Did you know that Excel will automatically complete cell entry for you when it detects a pattern? Learn more about flash fill and other new features. Excel is also packed full of exciting new templates and features to make your workload easier.

Lesson 1: Creating a Worksheet

Topic 1A: Explore the Interface and the Ribbon
Topic 1B: Update a Workbook’s Properties
Topic 1C: Navigate and Select in Excel
Topic 1D: Enter Data and Save a Workbook
Topic 1E: Customize the Quick Access Toolbar
Topic 1F: Obtain Help
Topic 1G: Use Microsoft Office Templates

Lesson 2: Performing Calculations

Topic 2A: Calculate with Formulas
Topic 2B: Calculate with Functions
Topic 2C: Copy Formulas and Functions
Topic 2D: AutoFill Options and Series List

Lesson 3: Modifying a Worksheet

Topic 3A: Manipulate Data
Topic 3B: Insert and Delete Data
Topic 3C: Find and Replace Data in a Worksheet
Topic 3D: Manipulate Worksheet Elements

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts
Topic 4B: Add Borders, Color to Cells, Cell Styles
Topic 4C: Change Column Width and Row Height
Topic 4D: Apply Number Formats
Topic 4E: Position Cell Contents

Lesson 5: Printing Workbook Contents

Topic 5A: Print Workbook Contents
Topic 5B: Set Page Layout and Print Options
Topic 5C: Set Page Breaks

Lesson 6: Managing Large Workbooks

Topic 6A: Format Worksheet Tabs
Topic 6B: Manage Worksheets in a Workbook
Topic 6C: Manage the View of Worksheets

Lesson 7: Inserting Graphic Objects

Topic 7A: Insert and Modify Pictures and ClipArt
Topic 7B: Draw and Modify Shapes
Topic 7C: Illustrate Workflow Using SmartArt
Topic 7D: Layer and Group Graphic Objects

Excel 2013 Training Class Outlines:

Excel 2013 Level 1: Fundamentals of Excel
Excel 2013 Level 2: Intermediate Functions and Features
Excel 2013 Level 3: Advanced Tools and Collaboration Features
Excel 2013 Level 4: Advanced Formulas and Functions
Excel 2013 Level 5: Introduction To VBA Macros
Excel 2013 Level 6: Advanced VBA Macros