© Blue Pecan Computer Training
Excel
Training
|
|
Basic Excel Training -
Basic Excel Training in Portsmouth & Southampton
Course Outline
Managing Lists & Tables
|
|
Sorting a table on more than one column
|
|
|
Hiding columns and then getting them back again
|
|
|
Changing the order of your columns
|
|
|
Freezing rows and columns so they stay on the page when you scroll
|
|
|
Filtering your list one or more criteria using AutoFilter
|
Excel Charts and Graphs
|
|
Which chart type is appropriate for my data?
|
|
|
Selecting a data source for a chart
|
|
|
Adding titiles and labels
|
|
|
Formatting chart elements
|
|
|
Creating a custom chart type
|
|
|
Setting a default chart
|
Excel Basics
|
|
Elements of a spreadsheet
|
|
|
Navigating your way around
|
|
|
Getting help when you need it
|
|
|
Worksheet and workbooks
|
|
|
Switching between multiple windows
|
Entering Data into Your Worksheet
|
|
Entering labels for columns and rows
|
|
|
Entering numbers, dates and times
|
|
|
Using simple formula to perform basic calculations
|
|
|
Creating new rows and columns
|
Formulae and Functions
|
|
Using the SUM function to add up rows and columns
|
|
|
Using the AVERAGE function
|
|
|
Using MIN and MAX to return the smallest and largest values in a range
|
|
|
Counting values with COUNT and COUNTA
|
|
|
Fixing cell references with absolute referencing
|
|
|
Using mixed cell referencing to avoid multiple formula in a table
|
|
|
Naming cells and ranges for database work and calculations
|
|
|
Looking at the logic behind IF statements
|
|
|
Performing calculations with dates and times
|
Printing Worksheets
|
|
Defining which part of your worksheet you want to print
|
|
|
Getting data to fit on one page
|
|
|
Including headers and footers on each page
|
|
|
Getting row and column headers to appear on each printed page
|
|
|
Printing gridlines
|