Excel 2007 Course Beginner Level (I)

Product description:

Who should attend this course?

For those who are on BEGINNER level in using Microsoft Excel.
We recommend attending this course all those who now take the first contact with Microsoft Excel.

At the end of this course participants will be able to:

-use the new Office 2007 interface (Fluent)
-out operations on the data from an Excel spreadsheet
-make calculations based on formulas using Excel functions
-out graphs based on data available
-print levels set before printing a set of specific attributes

Prior knowledge

Minimum experience in using Microsoft Windows (Manage files and directories)

Trainer Information

The course was developed by Dr.Excel (Bogdan Tarla) MVP (Microsoft Most Valuable Professionals) with specialization Microsoft Office.

All our online courses are 100% guaranteed, you have nothing to lose!
10-Day Money Back Guarantee!

If you feel that you did not benefit from the course, no hard feelings. We'll simply give you a full refund, no questions asked! If you would like to cancel your account for any reason, then please contact Office-Learning tream at: support@office-learning.com

Course Outline

Chapter 1 - Worksheets

• Insert a new sheet row
• Delete a sheet row
• Changing rows height
• Insert a new column
• Changing columns width
• Delete a column
• Worksheets - copy and rename
• Worksheets - delete
• Worksheets - create new sheet
• Worksheets - move
• The Split, Freeze, Hide and New Window options
• The Find and Replace tool
• Freezing rows and columns
• Formula Bar and Functions Box

Chapter 2 - Cell Formatting

• Borders
• Changing cells background
• Aligning cells text
• Delete formatting
• Merge and Unmerge cells
• Financial formatting
• Format painter
• Conditional formatting

Chapter 3 - Workbook Printing

• Changing sheets view mode
• The new Page Layout
• Adding Headers and Footers using Page Layout
• Page Breaks
• Printing options

Chapter 4 - Shortcuts

• Shortcuts - simple
• Shortcuts - selections
• Shortcuts - selecting cell blocks
• Shortcuts - selecting visible cells

Chapter 5 - Worksheets Formatting

• Comments - view and modify
• Hyperlinks - view and modify
• Using Paste Special
• Copy data from lines into columns and vice versa
• Gridlines - view and modify

Chapter 6 - General

• Workbook Auto Save
• Exporting as PDF or XPS

Chapter 7 - Describing the Ribbons

• The Home Ribbon
• The Insert Ribbon
• The Page Layout Ribbon
• The Formulas Ribbon
• The Data Ribbon
• The Review Ribbon
• The View Ribbon
• The Developer Ribbon
• Activating hidden Ribbons
• Presenting the Excel Options menu
• Presenting the Office button menu
• Customizing the Quick Access Toolbar