EXCEL FOR ACCOUNTING: ADVANCED
The best solution for Advanced Excel AccountsA hands-on one-day course with free pre-course online skills testing
Note: this Excel for Accounting: Advanced course is CPD certified.
It is delivered as a classroom course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.
Full details of modules and topics covered in this one-day course
This course covers 2010, 2013 and 2016 versions
This is a one-day training course structured into 8 modules
This intensive, hands-on one-day training course is the ideal follow-on from our Excel for Accounting: Introduction course.
It takes you to the highest level of using Excel in an accounts function in the shortest time because it focuses on only those subjects and tools you need in this environment.
This course has been designed for anyone who wants to use the more advanced tools in Excel to record, analyse and present financial data, whether in an accounting department or a more general office environment.
Delegates do not need to be accountants but they must understand and be able to work with the subjects covered in our Excel for Accounting: Introduction course.
A SPECIALIST COURSE FOR ADVANCED ACCOUNTING FEATURES IN EXCEL
Building on the foundation laid in the Excel for Accounting: Introduction course, this course takes delegates to a level of skills that will suffice most people for a lifetime.
In 8 highly focused modules, it moves from Logical and Error functions, through modelling ans specialist financial functions, right up to Macros and higher levels of using Pivot Tables and LOOKUPS.
And to give your work an extra edge, we take you through advanced ways of working with charts that display your data in the clearest, most impressive light.
- Array Formulas
- IS Functions
- AND/NOT/OR Functions
- Creating a Forecast Sheet
- Using Solver
- Data Tables
- Goal Seek
- General: SLOPE, AVERAGE, EFFECT
- Depreciation: SLN, DB
- Rate of Return: IRR
- Loan repayments: NPER, RATE, PMT, IPMT, PPMT
- Future Value: FV
- Present Value of an Investment: PV, NPV and XNPV
- Using Timelines in Pivots
- Using the Classic PivotTable Layout
- Formatting a PivotTable
- Displaying Data in PivotTables
- Getting Started With PivotTables
- Making Custom Charts
- Advanced Chart Formatting
- Working With Chart Axes and Data Series
- Using Error Bars
- Creating Trendlines
- Creating 3D Charts
- Changing the Source Data
- Changing the Type of Chart
- Visual Basic and Macros
- Copying and Deleting Macros
- Recording and Playing Macros
- Using the INDIRECT Function
- Using INDEX and MATCH with Array Formulas
- Combining INDEX and MATCH
- Using MATCH
- Using INDEX
- Creating Custom PivotTable Styles
- Showing PivotTables in Other Formats
- Calculated Fields in PivotTables
- Importing PivotTable Tools
Don't see a date you want?
[Duration: one day]
- Introduction to Dashboards
- Inserting Graphics for a Dashboard
- Specialist Functions and Formulas
- Dashboard Navigation
- Preparing your Workbook's Layout and Structure
- Using Excel Objects for Specialist Dashboard Views
- Using Macros and VBA with Dashboards
[Duration: one day]
- Working with Functions and Formulas
- Outlining, Grouping and Sub Totals
- Protecting Your Spreadsheet
- Presenting Data with Charts
- Formatting Financial Data
- Data Tools: Managing Your Data
- Formula Auditing
- LOOKUP Functions
All Activia advanced excel accounts has been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.
Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.
Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.
For training at your offices, we can deliver classes of up to 10 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.
Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
Also note: If you are a private individual you must pay by credit card at the time of booking.
Note: Please allow 1 - 2 working days for your confirmation and invoice.
If you are coming to our centre, dress code is smart casual. Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:
Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !
For training at your offices, this itinerary can be varied by prior arrangement.
With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.
Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.