Microsoft Office Masterclass

Microsoft Office Masterclass

by ISM Training

6,780 AED

(VAT inclusive)

Microsoft Office Masterclass

6,780 AED

(VAT inclusive)

by:
when:
Tue, 15 Dec 2020 9:00AM + 2 dates
(see timings & price options)
where:
Dubai - Barsha Heights - TECOM
level:
All Levels
Cancellation Policy: 48 hours prior to course start with full refund
We offer a best price guarantee for our classes. If you get a better price, let us know & we'll give you a free AED 100 voucher.
Description:

Master the ins and outs of Microsoft Office with this 3-day workshop.

Not only will you gain a thorough understanding of how to use Microsoft Excel, Outlook, and PowerPoint, you will also learn some tips and tricks to use the Office Suite comfortably. Day 1 will focus on Microsoft Excel, whereas days 2 and 3 will be devoted to Microsoft Outlook and PowerPoint respectively.

Day 1: Microsoft Excel with Gary York

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of Financial Modelling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

Course Outline:

  • An overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using hyperlinks

Key Learning Points:

  • Work comfortably with Microsoft Excel and many of its advanced features
  • Learn what's new in Excel
  • Be much quicker at carrying out regular tasks
  • Use sophisticated functions that will improve the quality of your work
  • Knowledge of how to protect your worksheets and data
  • Knowledge of how to create various reports from your data using tools such as PivotTables and PivotCharts

Day 2: Microsoft Outlook with Graham Chambers

Over the years, applications such as Microsoft Outlook have grown in sophistication and refinement to the point where they really can help you do your job better, and take some of the pressure off. This Outlook training is designed to help you do this.

Outlook is now a mature and fully-fledged assistant for you; learning to exploit its capabilities will help you make the most of your time and simplify and automate other office tasks that until now have been tediously manual or just impossible.

Course Outline:

  • Outlook essentials
  • How to optimize Outlook
  • Outlook to save time
  • Communicating with mail
  • Organizing contacts
  • Scheduling with calendar
  • Tasks
  • Keeping a journal and using notes

Key Learning Points:

  • Use Outlook to organize your day
  • Use Outlook mail as your email editor
  • Track and group your messages to organize your mail
  • Use the calendar to schedule and view events
  • Prioritize and delegate tasks to manage your time
  • Manage contact records for quick access to addresses

Day 3: Microsoft PowerPoint with Graham Chambers

The aim of this course is to look at all the features of PowerPoint and how to produce memorable slides to help the audience remember what the presenter is delivering. Don't make do with basic Microsoft templates when you can easily create stunning corporate presentations yourself. This is a practical, hands-on course, where you get the opportunity to practice creating stunning slides and not just bullet-point type presentations.

Course Outline:

  • Creating and managing presentations
  • Using PowerPoint templates, themes, and backgrounds
  • Using Slide Masters
  • Presentation options and views
  • Configuring and presenting slideshows
  • Creating, inserting, and formatting slides
  • Working with slide elements and style
  • Ordering and grouping shapes and slides
  • Using layouts
  • Working and modifying text, tables, charts, and smart
  • Inserting and formating media
  • Working with transitions and animations
  • Protecting and sharing presentations
  • Managing reviews

Key Learning Points:

  • Make more powerful choices when designing and using your slide deck
  • Use PowerPoint to enhance the impact of your presentations
  • Make PowerPoint work for you and your audience
  • Better slide management
  • Make your presentation stand out

Read more

Skill Level:

All Levels

Materials:

* Students are recommended to bring their own laptops with MS Office installed

Cancellation Policy:

48 hours prior to course start with full refund

Age Requirements:

18 and older

Additional Info:

* Certificate of attendance will be provided by the institute after course completion

Location:

TIME Oak Hotel & Suites - Abdulla Omran Tayram St.
Al Thanyah 1
Barsha Heights - TECOM
Dubai

Register for the class
Schedule
# Sessions
Price
Click here for schedule information
This course consists of multiple sessions, view schedule for sessions below:
Tuesday
15 DEC
9:00AM - 5:00PM
Wednesday
16 DEC
9:00AM - 5:00PM
Thursday
17 DEC
9:00AM - 5:00PM
Share this class:

Categories