Microsoft Office and Administrative Skills

DAY 1

Taking Control of Your Work Life

• Introductions – Getting to know each other

• Understanding and clarifying purpose, vision and mission

• External and internal customer service

• The secret to working smarter rather than harder

• Using high leverage activities to achieve more in less time

• Controlling, prioritizing and organizing your work

• Making a long term plan to create the best office in the company!

• Streamlining your office systems

• Getting your paperwork under control

• Making your office user friendly and efficient

Essential Administrative Skills

• Harnessing the power of the mind – through Mind Mapping Techniques

• Right brain/left brain theory

• Managing larger projects to meet deadlines

• Planning skills – using a Gannt chart to chart work progress

• Problem-solving techniques

• Becoming more proactive

• Decision-Making tools

• Managing meetings effectively

• Keeping minutes of meetings

• Working with more than one manager

Day 3

Introduction to Microsoft Word

• Document Views

• Entering and Editing Text

• Saving and Opening Documents

• Navigating and Selecting Text

• Editing, Copying, and Moving Text

• Formatting Documents

• Using Bulleted and Numbered Lists

• Using Tabs

• Introduction to Tables

• Inserting Pictures

• Page Layout and Printing

• Introduction to Styles, Themes, and Templates

• Managing Bulleted and Numbered Lists

• Customizing Tables and using Formulas

• Inserting Text Objects

• Inserting Graphic Objects

• Using Quick Parts

• Multi-Section Documents

• Headers and Footers in large documents

• Proofing Tools

Day 4

Introduction to Microsoft Excel

• Entering and Amending Data

• Saving and Opening Workbooks

• Navigating and Selecting Ranges

• Entering Formulas

• Inserting/Deleting Rows and Columns

• Formatting Worksheets

• Using Simple Functions

• Copying, Moving and AutoFill

• Relative vs. Absolute References

• Previewing and Printing

• Find and Replace

• Introduction to Range Names

• Using Multiple Worksheets

• Cell Styles and Conditional Formatting

• Paste Special

• Text and Date Formulas

• IF Function

• Using Charts

• Sorting and Filtering Lists

• Using Tables

• SmartArt and Drawings

• Comments and Hyperlinks

• Importing and Exporting Data

• Managing Range Names

• Date and Time Formulas

• Custom Formats

• IF and Related Functions

• VLOOKUP and Related Functions

• Advanced Filter / Subtotals

• Database Functions

• Multiple Workbooks / Consolidation

• Data Validation

• Auditing

• Pivot Tables

• Shared Workbooks / Tracking

• Protecting Worksheets

• Using Templates

Day 5

• Workshop on the whole material

• small projects

• revising the material