Excel Proficiency Skills
Free Course
The objective of this course is to help you become proficient in Excel. As with most learning, you will get 10 per cent of what you need from this course; a further 20 per cent from trying things out in a safe environment and asking follow up questions; and 70 per cent from doing it for real.
Book Your Course
| Date | Format | Location | Duration | Instructor | Price | |
|---|---|---|---|---|---|---|
| As requested | Video-based | As requested | As requested | Any | Free | Book Free Course |
Our Clients
Course Content
What will I learn?
Welcome to this online course on becoming proficient in Excel. Whether your interest has come from finding us by accident, or a heartfelt desire to become an Excel ninja or because you are booked on one of F1F9’s classroom courses and wanted to prepare, you are very welcome:
Course Topics
- Using the Alt key
- Keyboard shortcuts and the mouse
- Edit directly in cell
- Move selection after Enter
- Macro security and developer tab
- Analysis toolpak
- Reducing worksheet clutter
- Windows explorer settings
- Basic worksheet navigation
- Selecting, adding and deleting content
- Inserting rows and columns
- Adding and deleting worksheets
- Using the function keys
- Group mode
- Standard Excel shortcuts
- Excel Proficiency Skills - self-assessment
- Now you've finished
Meet Our Instructors
John Dimberline
John has 18+ years of experience and has led advisory teams on many complex projects supporting both public sector procurers, private sector bidders and corporates. Formerly head of financial modelling at Grant Thornton, John leads the senior management team at F1F9.
Andrew Berkley
With a background in business education and financial advisory work, Andrew leads training delivery at F1F9. Andrew has delivered financial modelling courses to numerous institutions including European Bank of Reconstruction and Development, Deloitte, KPMG, Grant Thornton and Siemens.
Omar Shaker
Omar is a highly experienced financial modeller having spent 15+ years building FAST compliant and best practice models in the project finance advisory (debt and equity) sector. He has worked on some of the largest transactions globally with an aggregate value exceeding USD 20bn. He is fluent in Arabic both written and spoken.
Morten Siersted
Morten founded F1F9 in 1999. He has played a key role in developing the FAST Standard, including setting up the FAST Standard Organisation in 2011.
Client Reviews
S. C. Invest NL
I liked the format and the fact that you are building up the model. i think the course was most helpful when you needed to think for yourself and build a part – perhaps more time spent doing this would have been good.
S. V.EBRD
Thanks a lot for the course, it was very useful and well structured. The instructor explained it awesome!
Jord W.
Excellent training! well thought program, really guiding you through the process of setting a financial model! I can really recommend it to everybody who is interested in following a financial modelling course.
Maryam Ahmed Network Rail
Great course- has given me a solid foundation to understand and build basic models within my role. Pacing is good and found the tutor’s instructions to be very straighforward to follow. Highly informative and will definitely consider coming back for the next level once I have put some of the skills learnt on this course into practice. Thank you
Charles Serinet SUEZ
Very useful to understand the impact of changes in revenue, gearing, DSCR on CFADS, Average DSCR, Div and Equity IRR. Very interesting as well to build step by step the balance sheet, P&L and CF to understand the connections between each statements. The track and resources tabs are really useful too.
Michael Leonhart KPN
The structure of the course was good and gave a good insight in how to build the consistent model. Sometimes, it was more about doing rather than really understanding why, so maybe a little more time spend on that topic would be nice. In general I learned a lot about the various shortcuts an modelling in general.
Mthandeni Vilakazi, AIIM
Specifically found the shortcuts and best-practice principles on model construction particularly helpful in improving productivity and efficiency. I also appreciated the use of a tracking sheet, as well as the time taken to explore alternative functions and approaches to understand their limitations.
Agie Turowska, Network Rail
The practical tools were great and will be very handy to pass on and help my colleagues too. The format was very good and easy to follow. I liked that we had two instructors helping when anyone got stuck while the rest were able to carry on.
Anonymous
Andrew was comprehensive, friendly and attentive. He managed the group very well, catered to all learning speeds, and ensured everyone’s questions were answered without disrupting the flow of the course.
Mthandeni Vilakazi, AIIM
The shortcuts and model construction best practices were particularly helpful in improving my productivity and efficiency. Andrew and Judith were phenomenal, the pace of teaching was excellent and very accommodating.
Get In Touch
Are you or your team looking to increase their financial modelling skills? Are you interested in team-based training focused on best practice and standardised approaches? Are you hoping to build up your own skills and expertise?
Our financial modelling instructors would be pleased to hear from you…