|
Provided by: 2e2 Microsoft Excel FundamentalsMicrosoft Office |
 |
Training
Provided by 2e2
Objectives: By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
|
|
||||||||||||
Microsoft Excel Fundamentals
Course Content:
Excel Basics
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
Printing
Preparing To Print
Page Set Up Options
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
Other Formatting Features
Creating Charts
Chart Basics
Printing Charts
Web Features
Saving Worksheets As Web Pages
Hyperlinks
Workbooks And Email
Excel Basics
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
Printing
Preparing To Print
Page Set Up Options
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
Other Formatting Features
Creating Charts
Chart Basics
Printing Charts
Web Features
Saving Worksheets As Web Pages
Hyperlinks
Workbooks And Email
About The Training Provider: 2e2
2e2 - 2e2 is a training provider focussing on the end-user, providing courses in the following areas:
Desktop Applications training (e. g. Microsoft Office)
Unified Communications training (e. g. IP Telephony)
Service Management (including ITIL)
Web Development
Training Room Hire
We deliver public courses in London, Leeds and Birmingham and...
