Office Skills and Administration

⦁ Personal Assistant

⦁ Admin Support

• Administrative Management

• Organisational Skills

• Telephone Etiquette

• Business Writing

• Time Management

• Body Language and Effective Communication

• Meeting Management

• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Use Excel Help
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools
• Apply Text Formats
• Apply Number Format
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates
• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties

• Customize the User Interface
• Set PowerPoint 2016 Options
• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master
• Create SmartArt
• Modify SmartArt
• Write Math Equations
• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions
• Review a Presentation
• Store and Share Presentations on the Web
• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation
• Secure a Presentation
• Broadcast a Slide Show
• Create a Video or a CD