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
- 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)
- 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
- 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
