Advanced Professional MS office Skills
(Part of Secretarial & Personal Assistants)
COURSE OVERVIEW
DURATION
5 days
DATE
25 – 29 Mar, 19 – 23 Aug, 14 – 18 Jan, 13 – 17 May, 9 – 13 Dec 2019
FEE
£3850
LOCATION
Holiday Inn Express Hotel 1 Priddys Yard Croydon CR0 1TS
Course Overview
Microsoft Office Professional for PC is generally ascribed as an innovative computer program that is highly recommended for people who are constantly on the go. Acquire essential skills for producing professional work with the Microsoft Office suite including Word, Excel, Power Point, and Access. This course bundle includes both basic and advance featured of Microsoft Word 2016, Excel, Power Point, and Outlook.
Who should attend?
Microsoft Office is widely used in businesses across all industries and this Training Programme is designed for those who wish to develop their skills of using Microsoft Office applications. This Qualification is helpful for any Office job, such as PA, Secretary, Admin Assistant, and Administrator, Office Manager or any other role in the office environment. Being able to demonstrate you have a high level of Microsoft Office skills will help you stand out to employers.
This course can also be taken in
Accra: 4 – 8 Mar, 15 – 19 Jul, 7 – 11 Oct, 16 – 20 Dec, 11 -15 Feb 2019
Dubai: 20 – 24 May, 1 – 5 Jul , 29 Jul – 2 Aug, 23 – 27 Sep, 25 – 29 Nov 2019
Texas: on request
Course Content
Microsoft word - beginner
- Introduction to Microsoft Word
- First Step to MS Word
- Text Editing & Formatting
- Formatting Paragraph and Pages
- Creating Styles, Themes, Number and Bullets
- Columns & Tables
- Macros and Proofing
- Sharing and Reviewing Documents
- Modify Word Document
- Exercise Files: Microsoft Word
Microsoft word - advance tricks and tips
- Introduction Word Advance Tricks and Tips
- Set a Default Front for Documents
- Text Replacement and Autoformat Options
- Use Different Tools
Microsoft excel - beginner
- Getting Started with Microsoft Excel
- Data Entering
- Creating Formulas and Functions
- Formatting
- Worksheet Views, Multiple Worksheets and Workbooks
- IF, VLOOKUP, and Power Functions, Security & Sharing
- Data Management, Data Analysis Tools
- PivotTables & Macros
- Exercise Files: Microsoft Excel
Microsoft excel - advance formulas & functions
- Introduction to Excel Advance Formula and Functions
- Values and Formulas
- Operations in Formulas
- IF, AND, OR and NOT Functions
- VLOOKUP and HLOOKUP
- Tabulating Data and Multiple Criteria
- Median, Mode and Ranking Data
- Date, Time and Functions
- Array Formulas and Frequency Functions
- OFFSET and INDIRECT Function
- Different TEXT & Information Functions
Microsoft excel - advance formatting and techniques
- Introduction to Excel Advance Formatting & Techniques
- Adjust Fonts, Font Sizes & Font Colours
- Adjust Cells and Tools
- Work with Formulas & Tables
- Adjust Row, Columns and Sheets
- Different Formatting Styles and Set up Data for Outlines
- Formatting Picture Styles
- Formatting Techniques – Restore Missing Data in a Column
Microsoft powerpoint
Getting Started with Microsoft PowerPoint
- Working with Presentations & Slides
- Adding Pictures & Contents to Slides
- Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides
- Preparing & Delivering the Presentation
- Reusing and Sharing Presentations
- Exercise Files: Microsoft PowerPoint
Microsoft access - beginner
- Introduction to MS Access
- Creating Tables & Setting up Properties
- Queries
- Creating Forms & Reports
- Working with Macros, Integrating Access with Office Suite
- Database Management
- Exercise Files- Microsoft Access
Microsoft access - advance questions in depth
- Introduction to Access Advance Questions in Depth
- Understanding Queries
- Query Criteria
- Parameters Queries
- Use Mathematical Operations and Functions
- Summarise Data with Aggregate Functions
- Dates, Time and Numbers Functions
- IF Function and Calculations
- Records and Database
- Explore the Basics of SQL
- Values, Database and Markup
Microsoft access - advance tricks and tips
- Introduction to Trick and Tips of Access
- Explore Startup Options
- Embed Queries in Reports
- Create a Back End and Front Ends
- Build the Forms and Reports
- Add Customised Functions and Visual Basics
Microsoft outlook
- Introduction to MS Access
- Creating Tables & Setting up Properties
- Queries
- Creating Forms & Reports
- Working with Macros, Integrating Access with Office Suite
- Database Management
Book this course
please send us your details & someone from our team will get back to you