Datrix Training offers Office Excel is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Microsoft Excel 2007 also offers more room for you to work in and delivers faster performance.
MS EXCEL 2007 INTRODUCTION – 1 DAY COURSE
Module 1 - Excel Basics in excel 2007
Starting Excel
What Is A Worksheet?
What Is A Workbook?
Identifying Parts Of The Screen
Using Help
Using Selection Techniques
Selecting A Range Of Cells
Selecting Nonadjacent Cells And Ranges
Selecting An Entire Worksheet
Entering Data
Entering Text Data Into A Cell
Entering Values
Entering Data Into A Range
Quickly Adjusting A Column Width
Finishing A Workbook
Saving A Named Workbook
Saving The Workbook In Html Format
Printing A Worksheet
Closing A Workbook And Exiting From Excel
Module 2 - Modifying A Workbook Excel Basics in excel 2007
Opening A Workbook
Creating A New Workbook
Opening A Recently Used Workbook
Creating Simple Formulas
Creating A Formula By Typing
Creating A Formula By Using The Mouse
Using Functions
Using The Autosum Button
Using The Formula Bar
Editing Data On The Worksheet
Editing The Data In A Cell
Editing A Formula
Clearing The Contents From A Cell Or Range
Using Undo And Redo
Module 3 - Managing The Worksheet Excel Basics in excel 2007
Navigating In A Worksheet
Using The Scroll Bars And Boxes
Changing Worksheets
Using Go To
Changing The Worksheet Structure
Deleting Cells, Rows, And Columns
Performing Simple Sorts
Creating And Using Named Ranges
Automatically Naming Ranges
Manually Naming Ranges
Navigating With Named Ranges
Using Range Names In Formulas
Pasting A List Of Named Ranges
Managing (Editing & Deleting) Names Using The Name Manager
Creating Named Constants
Module 4 - Formatting The Worksheet Excel Basics in excel 2007
Note: It is possible to customise and tailor each Microsoft Excel course ot meet your training objectives. There is usually no extra charge for customising your training course.
