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 + 6 =

LOCATION

Featured Courses

Conflict Management & Resolution

        2 days 11 - 12 July 2019 £450 Jurys Inn Croydon Wellesley Rd, Croydon CR0 9XY In a busy...

Effective Management Of Account Payable

5 days 25 - 29 Mar, 24 - 28 June 22 - 26 July, 19 - 23 Aug 16 - 20 Sept 2019£3850 Jurys Inn...

Petroleum Finance And Accounting Principles

5 days 25-29 Mar, 27-31 May, 22-26 Jul, 23-27 Sep, 25-29 Nov 2019 £2350 Jurys Inn Croydon...

Coaching And Mentoring For Leaders And Managers

      5 days 8 -12 Jul, 4 - 8 Nov, 9 - 18 Dec 2019 £3850 Jurys Inn Croydon...

Essentials of Contracting and Contract Negotiation

        5 days 1 – 5 July 2019,  23 – 27 September 2019, 4 – 8 November 2019...

Strategy and Effective Performance Management

      5 days 24 - 28 Jun 2019, 18 - 22 Nov 2019, 21 - 25 Oct 2019 £3850 Holiday Inn...

Upcoming Courses

Supervising Safety for Train the Trainers

5 days 11-15 Feb, 15-19 Mar, 10-14 Jun, 12-16...

Business Ethics and Corporate Social Responsibility

5 days 14-18 Oct 2019, 18-22 Nov 2019 £3850...

Empower trade unions: create relevance and industrial harmony

5 days 11-15 Feb, 15-19 Mar, 10-14 Jun, 12-16...

Fire safety, prevention and fighting

5 days 25-29 Mar, 27-31 May, 22-26 Jul, 23-27...

Course Search

LOCATION