About this course:

Teacher: Saad Nadeem

Status: Enrollment Open

Fee/Duration: 5,000 (10 Days)

Course Overview

This course starts from where Excel Intermediate level ends. It covers a variety of topics in Excel, from intermediate to advance. You will learn various Excel features, tips for creating easy-to-read and correct formulas, a series of useful data analysis tools, importing external data into Excel, and tools to make your spreadsheets more professional.

This is an interactive course will consist of live session, recorded lectures, quizzes, assignments, discussion and 24/7 access to the teachers. Student will also have round the clock access to all recordings so to clear any concept they are not able to able to understand. This course is designed for all excel competent users who want to become "expert users".

The following topics and areas will be covered in this course:

  • Overview of basic excel
  1. Customizing common options
  2. Absolute and relative cells
  3. Protecting and un-protecting worksheets & cells

  • Working with functions
  1. Writing conditional expressions (using IF)
  2. Using logical functions (AND, OR, NOT)
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  4. VlookUP with exact match, approximate match
  5. Nested VlookUP with exact match
  6. VlookUP with tables, dynamic ranges
  7. Nested VlookUP with exact match
  8. Using VLookUP to consolidate data from multiple sheets
  • Data validation
  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell
  • Working with templates
  1. Designing the structure of a template
  2. Using templates for standardization of worksheet

  • Sorting & filtering data
  1. Sorting tables
  2. Using multiple-level sorting
  3. Using custom sorting
  4. Filtering data for selected view (AutoFilter)
  5. Using advanced filter options

  • Working with reports
  1. Creating subtotals
  2. Multiple-level subtotals
  3. Creating pivot tables
  4. Formatting and customizing pivot tables
  5. Using advanced options of pivot tables
  6. Pivot charts
  7. Consolidating data from multiple sheets and files using Pivot tables
  8. Using external data sources
  9. Viewing subtotal under pivot

  • More functions
  1. Date and time functions
  2. Text functions
  3. Database functions
  4. Power Functions (CountIf, CountIFS, SumIF, SumIfS)

  • Formatting
  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells

  • Macros
  1. Relative & absolute macros
  2. Editing macro's

  • WhatIF analysis
  1. Goal seek
  2. Data tables
  3. Scenario manager

  • Charts
  1. Using charts
  2. Formatting charts
  3. Using bar and line chart together
  4. Sharing charts with PowerPoint / MS Word, dynamically

About The Teacher

Mr. Saad Nadeem is a qualified ACCA, BSc (Accounting and Finance UK) and a Certified MS Office Specialist, Associate Certified Financial Accountant, having more than 8 years of diversified industry exposure. He has been associated the industry as specialist practitioner, trainer and consultant. Saad is associated with SKANS School Of Accountancy and KBM Training & Recruitment as Professional Trainer. He has been involved in corporate trainings, workshops, and seminars for MS Outlook, MS Office Data Analysis, and Dashboard Reporting, Microsoft Office Spreadsheets Techniques, Advanced Charting Techniques and Advanced Reports Development. He is an expert in MS Outlook, MS Word and Advanced Microsoft Office building Financial Modeling using Microsoft Office Dynamic Dashboards in Microsoft Office.

How to Register for this Course

  • Create a new account --> http://www.tutocademy.com/login/signup.php?
  • Activate your account via the email sent to your specified email address
  • Deposit payment via one of the methods --> http://bit.ly/2uuWWlC
  • Share proof of payment by send the copy of the payment slip to contact@tutocademy.com
  • Our team will verify you payment details and give you access to the course
  • For any queries, please contact 0343-3783377

Show More Show Less

Created by: TutoCademy

Taught by: Saad Nadeem

Thanks for subscribing to the course(s). Your trial subscription will end in 7 days. To renew, please contact administrator at support@tutocademy.com.
Your free trail is over. Please contact administrator at support@tutocademy.com.