Valley of Experts Training Institute Al Garhoud, Dubai – UAE

logo-voe

Advanced Training Course in Microsoft Excel for Finance and Accounting in Dubai

1,500 د.إ- AED

Description

Unlock the full potential of Microsoft Excel for finance and accounting with our advanced training course. Enhance your skills and streamline your work with complex functions, data analysis, and financial modeling. Join us and take your career to the next level. Enroll now!

ABOUT THE COURSE

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed.

The Microsoft Excel Training course from the Continuing Education Center of VOE provides effective tips, techniques and formulas to the individuals that will effectively help them to make the best use of Excel in their organization.

COURSE OBJECTIVES

In this course, students will learn from basic to advanced Excel skills, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications. In this course student will learn how to create documents from basic to advanced and managing excel sheet with the ability to use shortcut skills and control professional worksheet.

ASSESSMENT

Students will undertake a placement test prior to the course start date in order to be able to cater them based on their level.

Participants will undergo an ongoing evaluation of achievements throughout the course. All assessments will be based on and aligned to the course objectives.

COURSE OUTLINE

Basic Level
  • Navigating in Excel
  • Ribbon and Tabs
  • Quick Access
  • Toolbar (QAT)
  • Dialogue Box and Task Panes
  • Customizing Ribbons
  • Basic Shortcuts
  • Introduction to Autofill
  • Introduction to Number Formatting
  • Formatting Tools
    Alignment
    Font
    Borders
    Color and Shading
    Format Painter
  • Named Styles
  • Navigating Through Worksheets
  • Changing Worksheet Name and Color
  • Adding/Deleting and Hiding/Un-hiding Worksheets 
  • Moving and Copying Worksheets
  • Worksheet Views
    Comparing Sheets Side by Side
    Splitting Worksheets into Panes
  • Freezing Panes
  • Saving and Opening Workbooks
  • Accessing Number Formatting Options
  • Number Formatting Using Dialogue Box
  • Custom Number Formatting
  • Absolute/Relative Cell References
  • Copying/Pasting Formula
  • Formula Auditing and Debugging
  • Basic functions (sum, average, max, min, count, countA, countBlank, round, roundup, rounddown and if statement)
Intermediate Level
  • AND function
  • OR function
  • NOT function
  • Merge deferent functions
  • IFERROR function
  • RANK
    Date functions
  • Working with Multiple Worksheets and Workbooks Simultaneously
  • Use Links and External References
  • Consolidate Data Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Automating Workbook Functionality
  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros Applying Conditional Logic
  • Use Formulas and Functions to Apply Conditional Formatting
  • Auditing Worksheets
  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas Using Automated Analysis Tools
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis Tools
  • Use Advanced Chart Features
  • Create Sparkline
Advanced Level
  • Sumif function
  • Sumifs function
  • Database functions
  • Text functions
  • Vlookup function
  • Data Validation Criteria
    Input Message
    Customizing Error Messages
    Circle Invalid Entries
    Advanced Data Validation Tricks
    Create Dependent Validation
    Make Subheadings in Validation
    Creating Dynamic Drop-Down List
  • Advanced Conditional Formatting
  • Pivot table
  • Pivot chart
  • Dashboard
  • Protect workbook, worksheet, and cells
  • Introduction to visual basic
    Forms
    Messages
    Buttons
    Links
  • Statistical functions
  • Count functions
    Count
    countA
    countBlank
    countifs
  • Mode.SNGL
  • Standard deviation (STDEV)
  • Forecast function
  • Financial functions
    Pmt
    Pv
    Ppmt
    Fvschedule
    SNL
  • Introduction to power BI

CONTACT US

This course is intended for corporate training; if you would like to add additional topics or want to know more details and avail discount price, please contact

 +971 50 874 4466 

or email us

director@voe.ae

English