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
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
