Home /
Training Courses /
Microsoft Excel 2007 Fundamentals
Microsoft Excel 2007 Fundamentals
Training Description
The skills and knowledge acquired in Microsoft Excel 2007 Fundamentals are sufficient to be able to use and operate the software at an efficient level.The Course Suits
Microsoft Excel 2007 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software. Microsoft Excel 2007 Fundamentals assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.Training Benefits
At the completion of Microsoft Excel 2007 Fundamentals you should be able to:
- work within the basic Excel environment
- find the information you need in Help
- create a new workbook
- open and navigate within workbooks and worksheets
- use a range of techniques to work with worksheets
- make changes to data in a workbook
- understand and work with ranges in a worksheet
- copy and paste data in Excel
- use the fill operations available to fill a data series
- move the contents of cells and ranges within and between workbooks
- understand, create and work with formulas and functions used to perform calculations
- understand and use formula cell referencing to create more complex formulas
- use font formatting techniques to greatly enhance the look of a worksheet
- align the contents of cells in a number of ways
- format rows and columns in a worksheet
- understand and use the number formatting features in Excel
- create effective charts in Microsoft Excel
- create a range of common charts
- print your workbook data
Course Timetable
The course focuses on practical work within the product giving delegates ample opportunity to use their PC skills through a series of graded exercisesTopics covered include:Getting To Know Excel
Starting Excel
The Excel Screen
Using The Ribbon
Using KeyTip Badges
Minimising The Ribbon
Shortcut Menus
Using Shortcut Menus
Understanding Dialog Boxes
Launching Dialog Boxes
The Quick Access Toolbar
Customising The Quick Access Toolbar
The Office Button
Using The Office Button
The Status Bar
Customising The Status Bar
Exiting Safely From Excel
Getting Help
Understanding How Help Works
Accessing The Help Window
Browsing For Help
Returning To The Home Page
Using The Table Of Contents
Searching Using Keywords
Disconnecting Online Help
Printing A Help Topic
Working With Screen Tips
Dialog Box Help
Other Sources Of Help
Creating A New Workbook
Understanding Workbooks
Using The Blank Workbook Template
Typing Text Into A Worksheet
The Save As Dialog Box
Saving A New Workbook
Typing Numbers Into A Worksheet
Typing Simple Formulas In A Worksheet
Easy Formulas
Typing Dates In A Worksheet
Easy Formatting
Checking Spelling In A Worksheet
Making And Saving Changes
Safely Closing A Workbook
Working With Workbooks
Moving About A Worksheet
Going To A Specific Location
The Open Dialog Box
Worksheet Techniques
Inserting And Deleting Worksheets
Copying A Worksheet
Renaming A Worksheet
Moving A Worksheet
Hiding A Worksheet
Unhiding A Worksheet
Copying A Worksheet To Another Workbook
Moving A Worksheet To Another Workbook
Changing Worksheet Tab Colours
Grouping Worksheets
Hiding Rows And Columns
Unhiding Rows And Columns
Freezing Rows And Columns
Splitting Windows
Editing In A Workbook
Understanding Data Editing
Overwriting Cell Contents
Editing Longer Cell Entries
Editing Formulas
Editing Functions
Clearing A Cell
Deleting In A Worksheet
Undoing And Redoing Operations
Selecting Ranges
Understanding Ranges
Selecting Ranges
Selecting Non-Contiguous Ranges
Using Special Selection Techniques
Selecting Larger Ranges
Selecting Rows
Selecting Columns
Viewing Range Calculations
Creating An Input Range
Copying Excel Data
Understanding Copying In Excel
Using Fill For Quick Copying
Copying From One Cell To Another
Copying From One Cell To A Range
Copying From One Range To Another
Copying Relative Formulas
Copying To A Non-Contiguous Range
Copying To Another Worksheet
Copying To Another Workbook
Filling Data
Filling A Series
Filling A Growth Series
Filling A Series Backwards
Filling Using Options
Creating A Custom Fill List
Modifying A Custom Fill List
Deleting A Custom Fill List
Moving Data
Understanding Moving In Excel
Moving Cells And Ranges
Moving Data To Other Worksheets
Moving Data To Other Workbooks
Formulas And Functions
Understanding Formulas
Creating Formulas That Add
Creating Formulas That Subtract
Formulas That Multiply And Divide
Understanding Functions
Using The SUM Function To Add
Summing Non-Contiguous Ranges
Calculating An Average
Finding A Maximum Value
Finding A Minimum Value
More Complex Formulas
What If Formulas
Formula Referencing
Absolute Versus Relative Referencing
Relative Formulas
Problems With Relative Formulas
Creating Absolute References
Creating Mixed References
Font Formatting
Understanding Font Formatting
Working With Live Preview
Changing Fonts
Changing Font Size
Growing And Shrinking Fonts
Making Cells Bold
Italicising Text
Underlining Text
Changing Font Colours
Changing Background Colours
Using The Format Painter
Applying Strikethrough
Subscripting Text
Superscripting Text
Cell Alignment
Understanding Cell Alignment
Aligning Right
Aligning To The Centre
Aligning Left
Aligning Top
Aligning Bottom
Aligning To The Middle
Rotating Text
Indenting Cells
Wrapping And Merging Text
Merging And Centring
Merging Cells
Unmerging Cells
Row And Column Formatting
Approximating Column Widths
Setting Precise Column Widths
Setting The Default Column Width
Approximating Row Height
Setting Precise Row Heights
Hiding Rows And Columns
Unhiding Rows And Columns
Number Formatting
Understanding Number Formatting
Applying General Formatting
Formatting As Currency
Formatting Percentages
Formatting As Fractions
Formatting As Dates
Using The Thousands Separator
Increasing And Decreasing Decimals
Creating Charts
Understanding The Charting Process
Choosing The Chart Type
Creating A New Chart
Working With An Embedded Chart
Resizing A Chart
Dragging A Chart
Printing An Embedded Chart
Creating A Chart Sheet
Changing The Chart Type
Changing The Chart Layout
Changing The Chart Style
Printing A Chart Sheet
Embedding A Chart Into A Worksheet
Deleting A Chart
Common Chart Types
Understanding Common Chart Types
Creating A Column Chart
Creating A Line Chart
Creating A Pie Chart
Creating A Bar Chart
Creating An Area Chart
Creating A Scatter Chart
Other Chart Types
Printing
Understanding Printing
Previewing Before You Print
Performing A Quick Print
Selecting A Printer
Printing A Range
Printing An Entire Workbook
Specifying The Number Of Copies
The Print Dialog Box
© PTP/X6M1
Please Choose from the list below:
Microsoft Excel 2007 Fundamentals training course available to book:
Related Items:
There's no related items for that course.
Quick Training Search
To perform a free text search for courses enter your chosen keyword/s below:
Special offers
Click here to find training related special offers in your area special offers
Open course schedule
One day open course schedule for the next month more info
U-Choose
Can't find the right date?
Can't find the right venue?
With U-Choose you can build the training package of your specification more info
Download our brochure
To download our brochure please click
here
To download our 2009 Open Schedule click
here
Special Offers Subscription
Subscribe to receive our special offers.