Basic Excel Training Program

Basic Excel Training Program in Dubai is aimed for those who wish to start learning Microsoft Excel. With so many features in MS Excel, at times for a beginner, it is very common to get confused. Lynchpin’s Basic Excel Training Program will help you to under the key features and functions of MS Excel to be used in daily work-life. You will learn it in an easy to understand manner with step-by-step guidance. You will get all exercise files for post-course practice.

Course Details

Training Dates

Tuesday 26 November 2024

Key Takeaway

By the end of the course participants will be able to:

  • Using Excel, formatting cells, fonts, alignment and basic functionalities
  • Performing basic Calculation, sorting and filtering
  • Using Excel, formatting cells, fonts, alignment and basic functionalities
  • Formulas to check whether cells pass or fail your rules
  • Create links between cells so that they all update automatically
    • Chart Manipulation
    • Performing basic Calculation, sorting and filtering
    • Highlight targets, trends, duplicates and errors with Conditional Formatting
    • Formatting and Print Options
    • Layout consistency by saving as a Template

 

Course Outline

Getting Started with Microsoft Office Excel
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Preview and Print a Workbook
  • Define the Page Layout
  • Lesson 6: Arranging data and filtering
  • Sort
  • Filter
  • Sum
  • Count
  • Max
  • Min
  • Average
  • CountA
  • CountBlank
  • If logical function
  • Column chart
  • Bar chart
  • Pie chart
  • Line chart

FULLY CUSTOMIZED - ACCORDING TO YOUR NEEDS!

Run This Course In-House

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

Trainer's Profile

Mr. Mirza Farrukh Baig

FCA |Harvard Trained | CEO Lynchpin Group |

Lead VAT Trainer & Consultant

Mirza Farrukh Baig-Harvard Trained, is one of our Decorated & Talented Trainer and Instructional Designer for Finance, Accounting, Risk Management training courses at Lynchpin Training. With him on the training venue, we guarantee the best style of delivery, team engagement, the energy level of the class and the WOW experience by your team is assured.

Experience

Mirza Farrukh Baig is a qualified Chartered Accountant and a career banker. He has over fifteen years of experience teaching CMA, ACCA, CFA and CA students. He is also the lead corporate trainer at Lynchpin delivering specialized training on Finance and Accounting He has served for eight years in a leading commercial bank in UAE where he was instrumental in strengthening the SME credit risk unit. Apart from approval of banking facilities for SME clients. He played an instrumental role in developing and implementing the SME credit risk policy of the bank.

Currently, he is the CEO of Lynchpin Training & Consulting and Chief Consultant for VAT Advisory, Consulting & Implementation. Farrukh carries extensive experience in dealing indirect taxes both for the UK and South Asia. Provided VAT (Value Added Tax) consultancy services with due care, experience, resources, and exposure to tax regimes.

Farrukh is an associate member of the Institute of Chartered Accountant of Pakistan (ICAP). He has been awarded a gold medal for outstanding performance in his CA final examination,by ICAP. He also went to Harvard Business School to Executive Entrepreneurship training program.

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