713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  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   |