Excel 2007 Basic

What does this course offer you?

In this elearning course you will learn how to use basic functions of Excel 2007 in connection with creating and editing tables. You will peform calculations with relative and absolute cell references and will become familiar with a selection of other important mathematical, financial and time functions provided by Excel.


What does this course include?

In addition to the instructional content, practice exercises and test questions are also included.

95
NUMBER OF LESSONS
12
LEARNING HOURS
 


Course Topics

  • How is a Table constructed in Excel?
  • What does Spreadsheet mean in Excel?

  • Starting and Ending Excel
  • The Excel Application Window
  • Calling up Commands

  • Moving about within a Spreadsheet
  • Entering Data
  • Changing and Deleting Cell Contents
  • Changing Column Width and Row Height
  • Selecting Cells Using the Mouse
  • Selecting Using the Keyboard
  • Undoing Work
  • Printing Tables
  • The Table is wider or larger than the Print Page
  • Saving Workbooks
  • Opening and Creating Workbooks

  • Structure of Formulas and Entering Formulas
  • The SUM Function
  • Entering Cell References within Formulas by Pointing
  • Editing Formulas

  • Getting fast Help on the Program
  • Working with Excel Help

  • Working with Themes
  • Font Type, Size, Style and Color
  • Setting more Font Attributes
  • Aligning Cell Contents
  • Additional Options for Cell Alignment
  • Merging Cells
  • Automatic and Manual Text Wrap
  • Drawing Borders and Lines
  • Applying Background Colours
  • Formatting Numbers

  • Repeat and Automatic Complete
  • Copying and Moving Using Drag-and-Drop
  • Copying and Moving Using the Clipboard
  • Using the Fill Feature
  • Relative References
  • Absolute References

  • Hiding and Displaying Columns and Rows
  • Inserting and Deleting Columns or Rows
  • Inserting or Deleting Cells

  • Structure and Entering of Functions
  • Entering simple Functions with the AutoSum Button
  • The ROUND Function
  • Using the Function Wizard
  • Creating Nested Functions
  • Finding Errors in Formulas
  • Using Formula Auditing

  • Assigning Names
  • Using Names in Formulas

  • The Structure of the IF Function
  • Using the IF Function
  • Linking Conditions with Logic Functions
  • The VLOOKUP Function
  • The HLOOKUP Function
  • Structure of the PMT Function
  • Using the PMT Function
  • Using Math and Statistical Functions

  • Entering Dates and Times
  • Formatting Date and Time Entries
  • Fundamentals of Time Calculations in Excel
  • Performing Simple Calculations with Time Entries
  • Working with Date and Time Functions
  • Practical Applications

  • Working with the Preview
  • Page Setup
  • Defining additional Print Options
  • Defining Page Breaks
  • Using Headers and Footers
  • Defining Column and Row Titles
  • Printing-specific Features

Technical Specifications

Windows

  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 or higher
  • “Script ActiveX controls marked safe for scripting” must be enabled

* In Internet Explorer 8 and higher, the Internet Explorer 7 "Compatibility Mode" is used to guarantee the optimal display of course content.


Interested in Pricing?

To receive pricing information for our MS Office and Windows E-Learning courses, please send us a Quotation Request and we will be touch with you shortly.

Receive a Quote ›

About Us

EXPAND Global provides learning technologies and content for the next generation workplace. We are experts in innovative learning tools, eLearning content development, off-the-shelf eLearning for Microsoft Office, microlearning, mobile learning, gamification and performance support.

 

GET IN TOUCH