Setup Menus in Admin Panel

Give us a Call: M: (+971) 52 955 8232

Search Courses
Generic filters
Exact matches only
Filter by Custom Post Type

This training programme, covers the more intermediate levels of Microsoft Excel in addition to looking at advanced topics as well. The course offers a plethora of knowledge on Microsoft excel and will equip participants to display a better grasp of its use. The training program outline is up to date and pertinent to marketplace requirements, thus catering well to all analytical prediction of training needs in the specified area. A customised proposal can also be arranged, to suit the training requirement of your team.


Course Objectives:

By the end of this course, participants will be able to:

  • Understand the intermediate functions of Microsoft® Excel 2010, and how it is different from the basic version
  • Understand how to navigate efficiently to the relevant tools within the Microsoft® Excel Chart Basics
  • Prepare and format Microsoft® Excel sheets and working with multi worksheets
  • Be able to format various chart styles
  • Proficiently use Advanced Charting
  • Be able to use different viewing options
  • Be able to use all advanced formatting and display options
  • Be able to consolidate data and formatting charts
  • Inserting pivot tables and charts into your Excel sheets
  • Be able to secure, protect and customise your workbook
  • Understand how to use macros and be able to use all logical and statistical functions
  • Understand advanced financial functions including all Lookup functions
  • Understand and utilise advanced data management

Course Outlines:

  • Creating and Working with Tables
  • Working With Multiple Excel Worksheets
    – Renaming Your Sheet
    – Inserting & Deleting Sheets
    – Changing The Order Of Your Sheets
    – Creating A Copy Of A Sheet
  • Creating Charts Within Microsoft® Excel
  • Chart Basics
    – Viewing Various Preset Chart Options Available Within Microsoft® Excel
    – Resizing A Chart
    – Formatting The Text, Colour, Etc., Within A Chart
    – Copying & Moving Charts Within Worksheets
  • Advanced Charting
    – Chart Formatting Options
    – Combination Charts
    – Graphical Elements
  • Using The Different View Options Available & Understanding Their Benefits
  • Setting The Print Area For Your Sheet
  • Inserting Headers & Footers
  • Repeating Rows & Columns On Printed Sheets For Easy Viewing
  • Using The Paste Special Options
  • Importing & Exporting Text
  • Naming Cell Ranges For Easy Viewing
  • Advanced Formatting
  • Working With Subtotals
    – Creating & Removing Subtotals
  • Formatting & Display
    – Formatting Tables Using Preset Styles
    – Customising Preset Styles
    – Using Conditional Formatting Options For Easy Formatting As You Type
    – Hiding & Unhiding Rows, Columns & Worksheets
  • Use The Sort & Query Functions
    – Customising The Sort Function
    – Applying Single / Multiple Filters To Data
    – Customising The Filter Queries
    – Removing Filters
  • Consolidating Data
    – Combining Data From Various Cells Into A Single Cell
    – Linking Cells, Charts, Etc., – In Same & Different Sheets
  • Formatting The Following In Your Charts:
    – Pie Chart Angles
    – Formatting & Positioning The Chart Axis, Chart Title & Chart Legend
    – Changing The Chart Design After A Chart Has Been Created
    – Adding & Deleting A Data Series Within A Chart
  • Inserting Pivot Tables & Charts Into Your Excel Sheets
  • Protecting Your Workbook
    – Adding A Password Protection For Your Workbook
    – Finalising Your Workbook As ‘Read Only’
    – Defining Data Entry Rules To Prevent Incorrect Information Being Entered
    – Customised Protection For Your Workbook To Allow Selective Editing
  • Macros
    – Recording Macros To Speed Up Frequently Performed Actions
    – Assigning Shortcut Keys To Recorded Macros
  • Customising The Quick Access Toolbar
  • Logical & Statistical Functions
  • Financial Functions
    – Using PMT Functions
  • Lookup Functions
  • VLOOKUP AND HLOOKUP
  • Advanced Data Management
    – Observing Data Validation
    – Creating Data Validation Rule

Who Should Attend?

Individuals who would like to be able to work comfortably with Microsoft® Excel, users who have a good understanding and knowledge of Microsoft® Excel and those who are keen to further their working knowledge of Microsoft® Excel.


General Notes

  • All our courses can be facilitated as Customized In-House Training course.
  • Course duration is flexible and the contents can be modified to fit any number of days.
  • As for Open Enrolment Courses, we offer our clients the flexibility to chose the location, date, and time and our team of experts who are spread around the globe will assist in facilitating the course.
  • The course fee includes facilitation, training materials, 2 coffee breaks, buffet lunch and a Certificate of successful completion of Training.
  • FREE Consultation and Coaching provided during and after the course.
Online Courses
Note
Customized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
ZOE Talent Solutions Logo


Address

Middle East – Head Office

918, Blue Bay Towers,

Al Abraj Street (Marassi Drive),

Business Bay, Dubai, UAE

Join Our Team as a Trainer

We are proud to have a team of highly experienced expert training professionals from all over the world.

If you feel you have the right skills to become a part of our training team. Please use the link below.

>Apply Now

Copyright © Zoe Talent Solutions 2020

Live Online Training

Due to the recent COVID-19 pandemic, we've decided to offer live online webinar training classes for all of our courses.


You can participate in our training sessions with the safety & comfort of your own home or office. This helps you fulfill your learning requirements, while availing massive discount on regular course fees.


Register for a live online session now.


To register for a course, please fill the information request form on the course page, or reach us through the live chat or WhatsApp using the apps below.