Facebook
Twitter
Instagram
Linkedin
Search
Generic filters
Topics
Certifications
Industries

Advanced Microsoft Excel

overview

This course provides users with the knowledge to use the more complex features of Excel. It is designed to give an insight into some of the more advanced features in Excel and will be of particular interest to those who want to build or work with financial models, carry out detailed data analysis and automate tasks by recording macros.

course details
COURSE DURATIONLANGUAGECERTIFICATE
12 Hours – 2 Hours per DayEnglishDISS Certificate
 *Please notify us if an interpretation is required 

 

course benefits/progression opportunities
Course objectives

By the end of the program, participants will be able to:

  • Develop skills for advanced use of excel
  • Identify the different use of excel functions and shortcuts
  • Learn how to perform complex functions
  • Develop skills in analysis using excel
  • Learn how to present data using charts and tables
  • Master the use of excel macros and pivot tables.
course outline
Day 1   
Module 1: Advanced Excel Shortcuts Module 2: Data Presentation with charts Module 3: Sorting And Filtering dataModule 4: Manipulating Dates
  • Extensive exercise on excel shortcuts
  • Identify the different use of excel functions and shortcuts
  • Mastering the shortcut window
  • Extensive exercise on excel shortcuts
  • Types of charts and their specific uses- Trend line and advanced charts.
  • Modifying and formatting existing charts.
  • Sort data as per value, colour, icons
  • Filter based on Font/Cell colour
  • Turning Auto Filter off
  • Use subtotal features and work with database functions Understanding References
  • Relative, Absolute & Mixed reference
  • Referencing different workbooks & Merging
  • Consolidating data, linking cells in different work books
  • Utilizing Dynamic Named Ranges for writing formulas and functions
  • Dates formats
  • Extracting Day, Month or Year from a date value
  • Extracting Day, Month or Year from a date value using TEXT Formula
  • Extracting end month from a date value
Module 5: Advanced Excel Formulas  Module 6: Text Formulas    Module 7: Data Validations and Protection      
  • Logical Functions
  • Ifs and Nested Ifs Statements
  • AND, OR and NOT Functions
  • Error handling using IFERROR, ISNA and ISERROR
  • Logical functions
  • Ifs and nested ifs statements
  • Text formulas
  • Concatenate
  • Find v/s search
  • Left, right, mid
  • Upper, proper, lower lookup formulas
  • Vlookup & Hlookup
  • Index & match
  • Sumproduct function
  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Creating Drop down list
  • Managing Themes, creating and use of templates
Day 2    
Module 8: What-if AnalysisModule 9: Data TablesModule 10:  Working with OutlinesModule 11:  Analysing Data with Pivot TablesModule 12: Excel Macros
  • Using the Scenario Manager
  • Creating and editing scenario
  • Creating a Scenario Report
  • Using Goal Seek
  • The single-variable data table
  • The two-variable data table
  • Adding conditional formatting
  • Applying an outline
  • Automatic outlining
  • Displaying and collapsing levels
  • Modifying outline settings
  • Creating subtotals
  • Creating a pivot table
  • Defining the source range
  • moving and deleting fields
  • Showing and hiding fields
  • Grouping and ungrouping fields
  • Renaming fields
  • Defining field properties
  • Formatting a pivot table
  • Refreshing a pivot table
  • Drilling down
  • About macros and VBA
  • Macro security
  • Recording macros
  • Running a Macro
  • Absolute and relative references
  • Saving and distributing macros
  • Assigning a macro to a button
  • Editing macro code
  • Automatic macros
Register Now
Brochure
Course Calendar

COURSE TYPE: WEBINAR

DATEDAYQATAR TIME
5-6 Apr 21Mon-Tue09:00-15:00
3-4 May 21Mon-Tue09:00-15:00
2-3 Jun 21Wed-Thu09:00-15:00
5-6 Jul 21Mon-Tue09:00-15:00
2-3 Aug 21Mon-Tue09:00-15:00
1-2 Sep 21Wed-Thu09:00-15:00
4-5 Oct 21Mon-Tue09:00-15:00
1-2 Nov 21Mon-Tue09:00-15:00
1-2 Dec 21Wed-Thu09:00-15:00
TESTIMONIAL

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name

Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor. Click edit button to change this text. Lorem ipsum dolor sit amet consectetur adipiscing elit dolor

Person name
Meet THE INSTRUCTORS
instructor
Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

instructor2
Instructor Name
Profession

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Related Courses
HSE COURSES
BUSINESS COURSES
QUICK LINKS
CONTACT INFORMATION

TELEPHONE:
+974 4466 6792

TOLL FREE:
800 DISS (3477)

TRAINING ACADEMY:
Villa No 8, St. No 44 Ahmed Bin Zoudin
Al Hilal, Doha, Qatar.

EMAIL:
info@diss.com.qa

Facebook-f
Twitter
Instagram
Linkedin-in
Envelope

© All rights reserved. DISS 2019

This website is owned and managed by DISS Qatar.