Office User

Objective:

This course is designed for the existing user who has been using Word and Excel and would now like to take their knowledge to the next level.   The student will be led via a series of hands on exercises through the steps necessary to manage topics such as pivot tables and macros in spreadsheets and mailmerge etc in Word.

Topics:

Excel
Shortcuts and Tips
The File Tab / Options
The Ribbon / The Quick Access Toolbar
Using Multi Sheets
3D Data Entry / 3D FormulaUsing Multiple WindowsLinked FilesLink and Pasting to other Applications
Validation Rules / Creating Drop down lists
Formula
IF Statements / IF AND OR Statements
Nested Functions
Data Handling
UPPER / LOWER / PROPER / CONCATENATE
LEFT / RIGHT / MID / LEN / TEXT TO COLUMNS
Date &Time Calculations
Sorting a Table / Sort Keys / Sorting Left to Right
Using AutoFilter / Advanced Filter
Pivot Tables
Creating / Slicers / Drilling Data
Charts / Reports
Introduction to Macros
Macro Recorder
Macro Recorder / Using Relative References
Macro Enabled Workbooks
Changing Security SettingsEmbedded Buttons / Adding to Ribbon
Word
Table of Contents
Creating Fillin Form Fields
Legacy ToolsDrop Down form Field / Check Box / Form Field
Drop Down List Content Control / Properties
FootnotesTracking Changes / Show Markup / Accepting / Rejecting
Watermarks
Working with Mail Merge
Using the Toolbar
Creating the Data File / Mailing Letters / Creating Merge /
Using If then Else
Merging Envelopes / Merging Labels
Hyperlinks / Shapes
Working with Pictures / Pictures and Illustrations / Charts
Brightness / Contrast
Picture Styles / Picture ShapesArrange / Position / Alignment / Text Wrapping / RotationSizing and CroppingClip Art / Smart Art / Smart Shapes

QUESTIONS & ANSWERS

 Special Features and Facilities

The course is devoted to a practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained.   The session is fully documented, and each person attending will have unlimited access to our after training back up service

Print Friendly