Advanced Professional MS office Skills

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

Advanced Professional MS office Skills

7 + 15 =

Our Latest Upcoming Courses

Petroleum risk and decision analysis

5 days 24-28 February 2020£3950Holiday Inn Express Hotel, London Croydon 1 Priddys Yard Croydon, CR0 1TS London, United Kingdom.  Running a successful petroleum operation...

Project and Resource Management

(Part of  oil and gas)5 days 23-27 March 2020£3950 Holiday Inn Express Hotel, London Croydon, 1 Priddys Yard Croydon CR0 1TS London United KingdomRunning a successful petroleum...

Risk Assessment & Risk Management in the Oil & Gas Industry

(Part of Oil and Gas) 5 days20-24 April 2020 £3950Holiday Inn Express Hotel, London Croydon, 1 Priddys Yard Croydon, CR0 1TS London, United Kingdom This training course will...

Essentials Of Contracting And Contract Negotiation

5 days 18-22 May 2020 £3950 Holiday Inn Express Hotel 1 Priddys Yard Croydon CR0 1TS LONDON The Essentials of Contracting and Contract Negotiation training course will help...

Coaching And Mentoring For Leaders And Managers

      5 days 8 -12 Jul, 4 - 8 Nov, 9 - 18 Dec 2019 £3850 Jurys Inn Croydon Wellesley Rd, Croydon CR0 9XY Leaders and managers are not generally looking to become...

Strategy and Effective Performance Management

      5 days 23-27 Mar 2020 £3950 Holiday Inn Express Hotel,London Croydon,1 Priddys Yard CroydonCR0 1TSLondon, United Kingdom. Strategy and Effective Performance...

LOCATION