Microsoft Excel 2007

Beginner

Excel 2007 Beginner

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to move that data to an electronic format. In this course, you will use Microsoft Excel 2007 to manage, edit, and print data in a spreadsheet.

----------------------------------------------------------------------------------------

Course Duration: 1 Day

Onsite: Please request quote for onsite training.  

----------------------------------------------------------------------------------------

Pre-Requisites: Students must have basic computer literacy

----------------------------------------------------------------------------------------

Course Outline
  • Spreadsheet Basics
  • Excel Basics (Screen, Menu)
  • Navigating Within a Worksheet
  • Changing the View
  • Using Help
  • Entering, Editing, Deleting & Undeleting Data
  • Working with Blocks
  • Adjusting Column Widths & Row Height
  • Creating & Filling Formulas
  • Entering Natural Language Formulas
  • Auto Fill
  • Using the Spell Checker
  • Saving, Opening & Printing Workbooks
  • Setting Print Options
  • Copying & Moving (Drag & Drop)
  • The Office Clipboard
  • Formatting (Alignment, Attributes, Borders)
  • Inserting & Deleting Rows/Columns
  • Using Built-In Functions
  • Customizing Cell Formats
  • Cell Styles
  • The Format Painter
  • Working with Charts
  • Absolute Addressing
  • Document Recovery
  • Using & Creating Templates

Intermediate

Excel 2007 Intermediate

As you are now able to edit, format, and print basic spreadsheets, you now need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

----------------------------------------------------------------------------------------

Course duration: 1 day

Onsite:  Please request quote for onsite training.

----------------------------------------------------------------------------------------

Pre-Requisites: Completed Microsoft Excel 2007 Beginner Course

----------------------------------------------------------------------------------------

Course Outline

  • Find/Replace
  • Using Block Names
  • Working With Dates
  • Advanced Functions
  • Creating a Database
  • Sorting Records
  • AutoFilter & Custom Filters
  • Working with Tables
  • Working with Macros
  • Creating an Array Formula
  • Linking Files
  • Creating a Workspace
  • Protecting Blocks/Worksheets
  • Freezing Panes
  • Splitting the Screen
  • Hiding Columns/Blocks
  • Multiple Worksheets & Tabs
  • Working with Chart Sheets
  • Hyperlinks
  • Sharing Workbooks
  • Tracking Changes
  • Adding Cell Comments
  • Conditional Formatting
  • Formatting Shortcuts
  • Custom Formats

Advanced

Excel 2007 Advanced

In this course we look at the more advanced features of Excel 2007.

----------------------------------------------------------------------------------------

Course duration: 1 day

Onsite Please request quote for onsite training in Johannesburg only.

----------------------------------------------------------------------------------------

Pre-Requisites: Completed our Excel 2007 Beginner & Intermediate course or have similar experience.

----------------------------------------------------------------------------------------

Course Outline

  • Creating Outlines
  • Pivot Tables & Pivot Charts
  • Advanced Chart Options
  • Adding Clipart, Graphic Files, AutoShapes
  • Adding Word Art
  • Using the Goal Seeker
  • Creating Scenarios
  • Adding an Outlook Task
  • Consolidating Data
  • Importing & Exporting
  • Customizing the Toolbar
  • Working with Styles
  • Custom Views
  • File Properties
  • Setting Program Options
  • Sending Workbooks
  • Creating Web Pages

facebook

Like us on Facebook and win monthly prizes.

Click on the Facebook icon above.

Course Enquiry

Name (*)

Please enter your name
Email (*)

Please enter your email address
Query (*)

Please enter your query
What city are you in? (*)

Invalid Input
Subscribe to our newsletter? (*)

Invalid Input



Contact No (*)

Please enter a contact number
How did you find us? (*)

Please select an option
Course (*)

Please select a course Hold the Ctrl key and click to select more than 1 course.






facebook

Like us on Facebook and win monthly prizes.

Click on the Facebook icon above.

 

Back to top