Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.
Excel Data Analysis in Finance
VIRTUAL TRAINING
Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning.
CORPORATE TRAINING
Our Corporate training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.
TRAINING HIGHLIGHTS
High quality training from Certified & Industry Experts
Earn 8 PDUs
Course Completion Certificates
Extensive documentation provided
Reimbursement guaranteed if the training is not satisfied
Our approach is both practical and inspirational. Our training is carefully designed and tested to develop the key skills and confidence needed while being highly participatory and fun
Features, functions and techniques for analysing & visualising large data sets using Excel.
Agenda:
Analysing Data Held in Excel
- Importing data files
- Useful functions: splitting cells, combining cells, linking multiple tables of data together
- Error checking and error handling
- Autofilter
- Advanced Filters
- Sorting
Excel’s Analysis Tools
- Group & Outline
- Conditional Formatting
- Charting Techniques
- Pivot Tables
- Pivot Charts
Analysing External Data
-
- Database Fundamentals
- Connecting to databases
- Using Microsoft Query
- OLAP Cube Fundamentals
- Analysing OLAP Cube data
Learning Objectives:
- A sound working knowledge of a range of tools and techniques you can use to visualize and analyse data quickly and efficiently.
- Enhanced skills and knowledge of presentation techniques using the latest Excel functions and features.
- All staff who analyse large data sets or databases
- Business/Finance Analysts
- Internal/External/IS Auditors
- Systems Accountants
- Finance/Accounting staff
What Does Academy for Pros provide me on the day of the course?
What experience does Instructor has?
All our Instructors are Certified & Industry Experts and they have years of experience in teaching Agile Courses
Does this course includes exam?
This course does not include exams as this is non-certifications course. once after the training we provide course completion certificate with each credit per hour (SEU,s or PDU’s)