Basic MS Excel Training Program in Dubai2019-01-03T11:49:58+00:00

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.

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

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

Performing Calculations

  • Insert, Delete, and Adjust Cells, Columns, and Rows

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting

Printing Workbooks

  • Preview and Print a Workbook
  • Define the Page Layout
  • Lesson 6: Arranging data and filtering
  • Sort
  • Filter

Formulas

  • Sum
  • Count
  • Max
  • Min
  • Average
  • CountA
  • CountBlank
  • If logical function

Lesson 8: Graphical Presentation using Charts

  • Column chart
  • Bar chart
  • Pie chart
  • Line chart

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.

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.

Quick Enquiry