Tutor available for Ms Excel / MS Office / Tally and Computer

Umm al Quwain Umm al Quwain >
Community Community >
Education Education >
https://dbzstatic-a.akamaihd.net/.dist_4c67cb181e13f37de333dafaf42c9896706c74ae/ 9918169

Description: Posted on: 11th April 2018

Everybody knows Excel to some extent.....want to go further.....
Take this course to take your Excel skills to the next level.....

What I cover in this course ?

* Understanding and familiarizing yourself with the Excel 2016 environment and Ribbon
* Start from Filtering Data with different techniques
* Learn how to use subtotals to summarize large data sets
* Master the commonly used formulas for summing thousands of rows
* Understanding when and how to use Absolute Reference and Relative reference
* Counting, Summing and Average Formulas with multiple criteria
* Running Advanced Filter with multiple criteria
* Extract unique entries from thousands of rows
* Master Formulas, Audit them, Decode them, Build Formulas inside Formulas, Arrays
* IF formulas, with AND criteria
* Vlookup with single and multiple criterias
* Text Formulas and its uses
* How to use sparklines
* Goal Seek, Data tables, Sensitivity Analysis
* Use of Index, Match , Offset Formulas
* Formula Auditing tools
* Use of Pivot tables in depth
* Slicers and how to use them effectively
* Conditional Formatting in Excel
* Flash Fill
* Named Ranges and why and how to use them
* Introduction to Macros
* Effective use of Excel Tables
* Using PasteSpecial and its features effectively
* Tons of Excel shortcuts to make you an Excel Star
* How to make effective Charts
* Introduction to Macros, what they are, why use them with live examples.

Days and timings flexible as per your call.
One to One training to get the maximum benefit.

Tag along a friend for the course and get yourself a 30% Discount!!

Other courses I offer:
* Charts and Dashboards
* PowerPoint Essentials
* Mastering Pivot tables in 3 hours
* MS Word for Beginners to Intermediate

Anywhere in Dubai, Sharjah, and Ajman

Call: Show Phone Number

Share with friends


Reply to this Ad:

Scam Warning:
(Examples of scams)

Never wire money or financial info to a seller on the internet. For your security, all transactions should be done in person.

Please report scams.

Show Phone Number
Chat With Seller Show Phone Number

No Location Specified