Microsoft Excel 2007 Fundamentals
Dates:TBC
Time: 9am to 4pm
Venue:AP Courses Training Room
Cost: £295
Included in the price: Learning manual for the course; lunch, refreshments and post-course support
Course Description
Microsoft Excel 2007 Fundamentals is designed for users who are keen to extend their understanding and knowledge of the software. 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.
Course Design
The course is a full-day tutor-led course that combines tutoring and practical work.
Target Audience
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. The course is intended for those whose work involves using Microsoft Excel to create, maintain and populate basic spreadsheets, create charts and tables, change layout and appearance, print Excel documents using specific options, and understand the concept of basic formulas and functions.
Learning Objectives
At the completion of Microsoft Excel 2007 Fundamentals you should be able to:
·
Work within the basic Excel environment
·
Create a new workbook
·
Open and navigate within workbooks and worksheets
·
Make changes to data in a workbook
·
Understand and work with ranges in a worksheet
·
Copy and paste data in Excel
·
Understand, create and work with formulas and functions used to perform calculations
·
Format rows and columns in a worksheet
·
Understand and use the number formatting features in Excel
·
Use font formatting techniques to greatly enhance the look of a worksheet
·
Print your workbook data
·
Create effective charts in Microsoft Excel
Course Content
Getting to Know Excel
Starting Excel
The Excel Screen
Using the Ribbon
Using Key Tip 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
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
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 and 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
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
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
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
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
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