Excel 2010 Basic

What does this course offer you?

In this elearning course, you will learn all the basic functions of Excel 2010 systematically by creating tables, entering data and designing it appropriately. For your calculations, you will work with formulas and use relative and absolute cell references. In addition, you will use some of the functions provided by Excel for your calculations. You will create and edit charts. Finally, you will gain some practical tips for printing Excel tables.


What does this course include?

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

59
NUMBER OF LESSONS
7.5
LEARNING HOURS
 


Course Topics

  • Starting and ending Excel
  • Creating new workbooks
  • Saving workbooks
  • Saving a workbook as a different file type
  • Switching between open workbooks
  • Excel options
  • Receiving help on the program
  • Views
  • The Excel application window

  • Entering data
  • Changing and deleting cell content
  • Good practice: Creating lists
  • Marking cells
  • Undoing work
  • Searching for and replacing specific cell content
  • Sorting tables
  • Filtering tables
  • Copying and moving using drag & drop
  • Using the Autofill function
  • Copying and moving using clipboard

  • Marking rows and columns
  • Inserting or deleting cells
  • Changing column width or row height
  • Freezing rows and columns
  • Sheets: Order and navigation
  • Inserting and deleting sheets
  • Good practice: Naming worksheets
  • Working with workbooks

  • Good practice: Creating formulas
  • Composing and entering formulas
  • Relative references
  • Absolute references
  • Composition and entry of functions
  • Composition of the IF function
  • Setting the IF function
  • Finding errors in formulas

  • Formating numbers
  • Formating text
  • Setting background color
  • Copying format
  • Automatic and manual line break
  • Connecting cells together
  • Aligning cell content
  • Assigning borders and lines

  • Creating diagrams
  • Selection of different diagram types
  • Switching diagram type
  • Editing diagrams
  • Editing diagram titles
  • Editing diagram elements
  • Editing more diagram elements
  • Sparklines

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