|
Microsoft Excel 2007- Essentials
Get Three Levels of Microsoft Excel in Two Powerful Days!
This "Essentials" class is designed to be the only Excel 2007 course you'll ever need.
Microsoft Excel is by far the most widely used and the most user friendly spreadsheet program available. The powerful software program allows you to make quick and accurate numerical calculations. Entering data onto a spreadsheet (or worksheet as they are called in Excel) is quick and easy. Once data has been entered in a worksheet, Excel can instantly :
- Make calculations, such as commission, mortgage payments or tax amounts
- Create charts to present the information so it is easily understood
- Combine with other data and sort by multiple factors
After years of using and teaching Excel we recognize that there is an overwhelming number of tricks that one can learn about using the program. Therefore, we decided to listen to our clients needs and boil down three Excel courses into one, teaching the key topics that most people should know to maximize productivity. The two-day format provides plenty of time for hands-on practice and in-class exercises. You also get the whole manual, so you walk away with training materials and practice data files for the entire Excel program, and you never have to take another Excel 2007 course!
Course Outline
Section 1: The Fundamentals
Understanding the Excel Program Screen
Understanding the Ribbon
Using the Office Button and Quick Access Toolbar
Inserting and Deleting Worksheets
Renaming, Moving and Copying Worksheets
Navigating a Worksheet
Entering Labels & Values
Selecting a Cell Range
Editing Cell Contents
Cutting, Copying, and Pasting Cells
Inserting/Deleting Cells, Rows and Columns
Using Cell Comments
Section 2: Formatting and Print Options
Formatting Labels
Formatting Values
Adjusting Row Height and Column Width
Working with Cell Alignment
Adding Cell Borders, Background Colours and Patterns
Using the Format Painter
Using Cell Styles
Creating Headers and Footers
Using Page Breaks
Adjusting Margins and Orientation
Adjusting Size and Scale
Adding Print Titles, Gridlines and Headings
Advanced Printing Options
Section 3: Formulas and Functions
Formulas with Multiple Operators
Absolute and Relative Addressing
Order of Precedence - BEDMAS
Inserting and Editing a Function
Defining Names
Using and Managing Defined Names
Displaying and Tracing Formulas
Understanding Formula Errors
Protecting a Workbook &Worksheets
Section 4:Charts
Creating a Chart
Resizing and Moving Chart
Changing Chart Type
Applying Built-In Chart Layouts and Styles
Working with Chart Labels
Working with Chart Axes
Working with Chart Backgrounds
Working with Chart Analysis commands
Formatting Chart Elements
Changing Chart Source Data
Using Chart Templates
Section 5: Organizing Data
Conditional Formatting
Sorting by Single and Multiple Columns
Sorting by Colors or Icons
Create a custom list
Filtering Data
Remove Filtering
Creating a Custom AutoFilter
Using an Advanced Filter
Using Subtotals
Consolidating Data Using Formulas
Goal Seek
Section 6: Pivot Tables
Creating a PivotTable
Specifying PivotTable Data
Changing a PivotTable's Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart
Student Practice Files for this class are located here. | 
