Overview
Microsoft Excel is the most used software for reporting and database. Almost every organisation use excel on daily bases regardless of their size, industry or nature of work. In this course learn advanced formulas, functions and accounting reports. This course is suitable for anyone who has a basic understanding of excel and want to upgrade to advanced level.
- Master advanced functions
- Learn advanced formulas
- Create accounting reports
- Scenario based training
- Data analysis
At Centre of Accountancy Careers & Training Ltd we provide hand-on practical training on Excel and delivered by Highly Qualified Trainers who have years of experience in the industry. Enroll now for our Advanced Excel course and become confident.
CONTENT
- Pivot tables
- Use of Pivot Table Slicers
- Summing Techniques
- IF, AND /OR functions
- Basic Macros & Scenarios
- Database Formulas
- Conditional Formatting
- Charts & Graphs
- Data Tables
- Line charts & Column
- IFERROR
- Using lookup and reference functions (VLOOKUP, HLOOKUP)
- VlookUP with Exact Match, Approximate Match
- Outlining & Groupings
- Filtering data for selected view (AutoFilter)
- Using advanced filter options
- Goal Seek
- Data Validation
- Hyperlinks
- Preparation of advance excel spreadsheet
COST & DURATION
Flexible timing
- Full time / Part time
Mode of Study
- In office or Online
Duration
- 2 Days
Cost
- Please contact us for the quotation
Let's Talk