Course Overview

Trained Over 1500 Professionals on Excel

Lynchpin is the leader in providing Excel Training in Dubai & Abu Dhabi. Our expert Microsoft Excel Trainer deliver both public Excel Training Programs as well as in-house Excel Training Programs in Dubai, Abu Dhabi and across UAE.

Looking for Excel Training in Dubai and Abu Dhabi? Its time to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application Microsoft Excel

  • Discover methods to dramatically reduce the time you spend on spreadsheets
  • Develop practical solutions to your business problems through superior spreadsheet design
  • Upgrade your spreadsheet skills with advanced data management techniques
  • Consolidate worksheets from different sources into one workbook
  • Develop efficient techniques for using charts

Course Details

Training Dates

14 January 2025

Key Takeaways

Skills

Use spreadsheet skills for advanced financial applications

Create

Create, format and troubleshoot pivot tables

Analyze

Analyze data accurately using pivot tables and slicers

Adopt

Adopt logical methods to solve complex problems by analyzing data accurately using pivot tablesControls over Financial Statements

Efficient

Efficient working with related worksheets and workbooks by benefitting from new reporting and presentation techniques

Course Outline

Unit 1: Filling Data
  • Understanding Filling
  • Filling A SeriesCreating A Custom Fill List
  • Modifying A Custom Fill List
  • Deleting A Custom Fill List
  • Absolute and Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Other basic formulas
  • Creating Names for the range
  • Using Names In New Formulas
  • Creating Names Using The Name Box
  • Using Names To Select Ranges
  • Pasting Names Into Formulas
  • Creating Names From A Selection
  • Using The Name Manager
  • Understanding Logical Function
  • Using IF To Display Text
  • Using IF To Calculate Values
  • Nesting IF Functions
  • Using IFERROR
  • Using AND
  • Using OR
  • Vlookup function
  • Multiple Vlookup
  • Formatting Cells Containing Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top & Bottom Ten Items
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Sparkline (New feature)
  • Creating Sparklines
  • Editing Sparklines
  • Creating drop down in cells
  • Restriction values from list only
  • Creating error message
  • Creating dependent list
  • Count, CountA, CountIF & CountBlank
  • Sum, SumIF & SumIFs
  • Networkdays
  • Networkdays International (For ver 2010)
  • Today & Now function
  • Trim (Removing unwanted spaces)
  • Concatenate (Combining columns)
  • Converting data into table
  • Automation calculation in table
  • Converting table to normal range
  • Using table in Charts & Vlookup
  • Understanding Lists
  • Performing An Alphabetical Sort
  • Performing A Numerical Sort
  • Sorting On More Than One Column
  • Sorting By Rows
  • Working with subtotal
  • Paste special
  • Hyperlink
  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing A Chart
  • Dragging A Chart
  • Changing The Chart Type
  • Adding A Chart Title
  • Adding Axes Titles
  • Positioning The Legend
  • Showing Data Labels
  • Showing A Data Table
  • Modifying The Axes
  • Showing Gridlines
  • Adding a Trendline
  • Adding a TextBox To a Chart
  • Creating combination chart
  • Creating 2 Axis chart
  • Understanding Pivot Tables
  • Creating A PivotTable Shell
  • Dropping Fields Into A PivotTable
  • Filtering A PivotTable Report
  • Clearing A Report Filter
  • Calculation in pivot
  • Formatting A PivotTable Report
  • Dynamic range for pivot
  • Understanding Slicers (New Feature)
  • Creating Slicers (New Feature)
  • Recording & Running Macros
  • Creating button to run the macro
  • Assigning shortcut to macro
  • Deleting Macros
  • Relative reference in Macros
  • Open & Modify file password
  • Sheet protection
  • Protecting your sheet from deletion
  • Protecting few cell, rows or cols
  • Protecting your data from copying

FULLY CUSTOMIZED - ACCORDING TO YOUR NEEDS!

Run This Course In-House

Enjoy this certified program at your premise of choice, with:

What Our Clients Have to say

“I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training”

Manager Learning & development

The Executive Council of Dubai

"Trainer is very knowledgeable and patient and passionate with training. He make sure the trainees have fun ensuring they have learning as well. I have been with Lynchpin for CMA and now this and for both i felt well taken care of."

Didith

Accountant – Arthur D Little

"Very Persuasive approach by Lynchpin , very accurate and worth for whole day listening to the trainer. The group work in inhouse program is worth attending.Excel is never delivered like this before."

Director Sales

Ferrari World

"Lynchpin trainer is brilliant and have excellent delivery skills – a new way to learn Finance for Non-Finance."

VP Human Resource

Thuraya UAE

"Excellent experience with Lynchpin and this session I will never forget. Their Trainer is very knowledgeable and has lots of examples from his experience. Keep up the good work lynchpin team !"

Finance Manager

Civil Aviation Authority Abu Dhabi

Required training from the company. It's useful especially in the Finance as most of us are using formulas anddoing reports. It's was nice to learn a lot of new things in excel.

Ma Angelica Petere

Majid Al Futtaim Accor Hotels Hospitality Services

I take this opportunity to thanks Mr. Farrukh Baig who gave us great training which is quite helpful for our daily work practice.

Muhammad Umair

Majid Al Futtaim Hospitality Services

The training was very useful to us who's working in finance especially that we are dealings with numbers that needed excel reports.

Ana Rose P. Dumocmat

Majid Al Futtaim Hospitality

Very interesting training and program! Also the trainer was very helpful and taught us interesting tricks and formulas!

Diane Roukoz

Obegi Home

The training was excellent and the trainor as well especially in explaining all the information.

ANA MARIE JAMONER

MAJID AL FUTTAIM HOSPITALITY SERVICES LLC

I would appreciate if they could have had more clarity on few line items.

Abdul Rahim

HWH Investments LLC

Training was with live examples and case studies, Trainer has delivered the training with passion and sincerity. Both Venue and Training were Good.

Sr. Manager Reporting

Dubai World

Lynchpin workshop was great learning with my current tasks at work, which was taking me long time before the training.

Faiza Nasir

Portfolio Manager, NBAD

Fun learning and I am implementing my real work in the training as it applies fully to what I do and it came to me at the right time, strategising now for my work based on the learnings from training

Head of Finance

YAS Water World

Lynchpin’s session was informative and required for business heads. Trainer went to the required level of audience to make them understand the concept. (Head of Corporate Planning, Eurostar) Everything was well organized,Lynchpin is very respectable Training Company –

Accounts Manager

Al Wazan Oil & Gas

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15