713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft® Office Excel 2013: Level 1

Training Course Content

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

 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |