This advanced excel training course is designed to provide students with knowledge and skills to use a spreadsheet and other advanced features of excel sheet. The course aims to provide students with the extensive knowledge to create and edit complex data by optimising advanced features of excel sheet.
Microsoft Excel is an essential business tool used by organisations of all sizes across the globe. Our Excel training courses are the best choice for improving your general Excel skills. On completion of this training, you will be more confident with using Excel to set up reports, tables, charts and more complex formulas.
Our Microsoft Excel courses are led by trainers who are experts in their field and are passionate about helping you become proficient in Excel.
Excel for Accountant:
Excel is an amazingly powerful tool for accountants and Bookkeeper. If you’re a newly qualified accountant, just about to begin an accountancy degree or just a small business owner who’d like to manage their finances better, then these course is ideal for you to learn.
Course Content
- Creating worksheets, formatting text
- Simple and complex formulas
- Handling rows and columns
- Autocomplete, using styles, headers and footers,
- Average, max and min functions and using charts.
- Use of IF Formula
- Summing Techniques
- Cell References
- Formula Linking
- Sumifs
- Tables and Bordering
- Look up References (Vlookup, Hlookup,etc)
- Data Validation
- Conditional Formatting
- Date & Time Formulas
- Charts & Graphs
- Protection & Security
- Creating Pivot Table
- Pivot Table Analysis
Class Duration:
Classroom Based – 2 weeks
Study Option:
Classroom Based: we offer Daytime and Weekend session for Advanced Excel Training course
Why Choose Us?
- Our courses represent outstanding value for money
- Tutorial support
- High quality e-learning study materials and mock exams.
- Each course is designed by industry experts, using an innovative interactive learning approach
- Benefit of applying NUS extra Discount Card.
- Anytime & Anywhere Learning.
- Recognized Accredited Qualification.
- Study in a user friendly, advanced Virtual learning platform
- Excellent student support and administrative support
