Explore Financial Academy
About the Academy
Discover our Rich, 60-Year Journey
Jadarat
A Comprehensive System for Skill and Knowledge Development
Governance
Meet our Inspiring Leadership
Success Stories
Check out our Clients’ Reviews and Testimonials
...
(4.0/ 5) 5 Reviews
There is no doubt that Excel is the accountant's, finance and business professional's best friend! You and I know how overwhelmed we are with the abundance of unstructured data. Monthly, quarterly and annual closing are immensely data driven and require moving and exporting data from 'ERPs' and databases to Excel. This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and massaging of noisy data, preparation of reports, analysis and reconciliation. This course is Excel based allowing you to develop an exclusive level of expertise and adding immediate value to your job.
(4.0/ 5)
5 Learner Rating
There is no doubt that Excel is the accountant's, finance and business professional's best friend! You and I know how overwhelmed we are with the abundance of unstructured data. Monthly, quarterly and annual closing are immensely data driven and require moving and exporting data from 'ERPs' and databases to Excel. This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and massaging of noisy data, preparation of reports, analysis and reconciliation. This course is Excel based allowing you to develop an exclusive level of expertise and adding immediate value to your job.
Banking
Capital Market
Insurance
Financing
Not Exist
Business, finance and acc...
Business, finance and accounting professionals, senior and junior accountants, business analysts, research professionals, marketing and sales, administrative staff, supervisors, general business professionals.
This provides you with the opportunity to select the available times that suit you best for participation in our program. These times represent slots during which we are ready to welcome you and provide assistance and guidance.
Goal Seek
Creating new scenarios, editing and deleting scenarios
Summarizing scenarios in Pivot Tables
Scenario summary reports
Designing three types of spinners
Number spinners
Percent spinners
Text Spinners
Working around spinner restrictions
Performing selective and comparative analysis
Linking the check box to reports and graphs
Designing visualization
Linking data from different sources
Creating graphs
Designing a dynamic dashboard using list box
Linking Excel with text files
Using get and transform data
Splitting columns
Perform data transformation
Data properties
Performing automatic refresh of data
(Linking Excel with databases (Access
Linking Excel with multiple Excel files
Macro basics
Planning a macro
Designing your control board
Recording macro
Testing macro
Editing macro
Macro workshops
Advanced filter with macro
By completely attending this course, participants will be able to:
• Competency III: Design dynamic reporting models using different modelling techniques. Perform What-If-Analysis • Competency IV: Integrate Excel with many different file types such as access, web, text, SQL, and other databases. Reports will update automatically • Competency V: Perform repetitive tasks and generate reports efficiently by recording, running and editing.
