About this course:

Teacher: Saad Nadeem

Status: Enrollment Open

Fee/Duration: 3,000 (5 Days)

Course Overview

In this modern world most businesses survival rest on the manipulation and analysis of data and majority of them uses Excel to achieve this. Having known its computing power and capabilities Excel is still the most underutilized tool. Majority of people uses Excel basic functions and use it for nothing more than a spreadsheet for simple bookkeeping. They also know that a lot more can be achieved with this program and its true understanding can yield truly fantastic results for any business in general and data analysis in particular. This Excel training course can help the business and finance user to become smart workers and use this program’s potential to enhance their productivity, efficiency and job enrichment

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 beginners to intermediate level candidates who want to learn and implement MS Excel.

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

  • Knowledge of worksheet (creating multiple sheets and navigating)
  • Printing and exporting to multiple file extensions
  • Layouts (freezing, splitting panes, themes, backgrounds)
  • Data basics (entering data, fill handle, flash fill)
  • Undo & redo, find & replacing data, data validation
  • Formatting (changing cell, font, border, merging & wrapping cells)
  • Alignment, format painter
  • Basic formulas & functions (Sum, Avg, Count, If, SumIF functions)
  • Max & Min functions, cell grouping, etc
  • Tables (creating tables, tables sorting, table filters, etc)
  • Basic graphs
  • Using smart short keys
  • Data filtering techniques
  • Introduction to basics of IF condition
  • Graphical objects (smart art, shapes, screenshots, pictures)
  • Advanced formatting (built in conditional formatting, custom conditional formatting, comments)
  • Security (workbook protection & locking/hiding cells, cell protection)
  • Advanced navigation & handling (Useful shortcuts, hyperlinks, quick analysis)
  • Introduction to intermediate concepts (data & What IF analysis, pivot table)
  • Advanced functions & external data, excel tool development

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.