713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas
Course Links
training schedule  Schedules
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule
Resources
training schedule
training schedule
training schedule

 

 


 
 

Microsoft® Office Excel: Level 1
Online Training Course Content

Course Objective: Students will create and edit Excel worksheets and manage 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.

Excel Level 1: Fundamentals of Excel   Excel Level 1: Basic Functions & Formulas
3 Hour Webinar   3 Hour Webinar
         
Lesson 1: Creating a Basic Worksheet
   • Explore the Interface
   • Navigate and Select Data in Excel
   • Enter Data and Save a Workbook
   • Use Microsoft Office Templates
   
Lesson 2: Modify a Worksheet
   • Manipulate Data
   • Insert & Delete Cells, Columns and Rows
   • Find and Replace Data
   • Apply Number Formats
   
Lesson 3: Format a Worksheet
   • Modify Fonts
   • Add Borders, Color to Cells, Cell Styles
   • Change Column Width and Row Height
   • Position Cell Contents
   
Lesson 4: Print Workbook Contents
   • Print Workbook Contents
   • Set Page Layout and Printing Options
   • Set Page Breaks
   • Insert Headers and Footers
   
Lesson 5: Manage Large Workbooks
   • Format Worksheet Tabs
   • Manage Worksheets in a Workbook
   • Manage the View of Worksheets
 
Lesson 1: Create a Basic Formula
   • Enter and Manipulate Numerical Data
   • Calculate Mathematical Results in a Formula
   
Lesson 2: Referencing Options in Formulas
   • Calculate formulas using Cell References
   • Understand Relative Referencing
   • Apply Absolute and Mixed References to reuse a Formula
   
Lesson 3: Copy and Paste Formulas
   • Copy, Paste and Autofill Options
   • Create a Series List
   • Flash Fill
   
Lesson 4: Summarize and Link Data across Worksheets
   • Link cells in a formula
   • Sum Across Worksheets
   • Troubleshoot formulas
   

Excel Training Class Outlines (Online Training):

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

 

 

  		   
     

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