|
Introduction to Excel
…Effective way to work with spreadsheets
Prerequisite
A working knowledge of Windows is required, or our Microsoft Windows
Introduction course. No experience of MS Excel is required.
Course Level
Foundational
Duration
1 Day
Who should attend?
Working professionals from any function,
currently working Windows-based PCs and wish to use MS Excel
Performance Focus
At the end of this course you will have a good working
knowledge of Excel basics. You will feel more confident using
Excel and be able to create a spreadsheet from scratch.
Understanding and using some of the built in calculation and
formula functionality will allow you to be more productive in
your work environments. Spreadsheets that you create will be
easier to use and look more presentable.
Content
Basic outline of the course:
Getting Started
Spreadsheet terminology
Exploring the Excel window
Getting help
Opening and navigating workbooks
Closing workbooks
Entering and editing data
Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks
Modifying a Worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges |
Using Functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX
Formatting Worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat
Printing
Preparing to print
Page Setup options
Printing worksheets
Creating Charts
Chart basics
Modifying charts
Printing charts
Recap & Closing |
|
|
|