Don’t be part of these statistics!
You’ll be redirected to Thinkific checkout.
Don’t be part of these statistics!
You’ll be redirected to Thinkific checkout.
See how we’ll help you turn the tide.
The aim is to make you a very confident user of Excel functions within 3 weeks. And your access is for an entire year. In addition to the recorded lectures, you will have access to:
You’ll be redirected to Thinkific checkout.
Leverage your knowledge with our monthly Mini-Challenges in your email box. This bonus was designed to put your new skills set in use for many months after completing the course.
Step-by-step instructions in PDF format, backed by spreadsheet templates and explanatory videos on YouTube, making sure you can apply your knowledge in a dynamic way.
The mini challenges are a great support to mimic real-world examples demanding advanced knowledge of Excel functions, especially nested functions.
After completing our 4-hour practical course, split in 7 well-structured modules, you will gain access to a case study where you will have the opportunity to build up a simplified financial projection, using the functions you learned from all previous modules of the course journey.
M1: Supporting Excel File
Logical Functions – Part I
Logical Functions – Part II
Quiz M1: Logical Functions
Understanding logical functions in Excel will give the basis for any analysis you need to perform in your spreadsheets. Here we cover the functions: IF / OR / AND / RIGHT / LEFT / IFERROR.
M2: Supporting Excel File
Math Functions – Part I
Math Functions – Part II
Quiz M2: Math Functions
In this module you will learn how to easily perform math calculations to quickly assess your data. Here you will learn the functions: SUMPRODUCT / SUM / SUMIF / SUMIFS / ROUND / ROUNDUP / ROUNDDOWN / MROUND / MOD / RAND / RANDBETWEEN / ABS.
M3: Supporting Excel File
Statistical Functions – Part I
Statistical Functions – Part II
Quiz M3: Statistical Functions
At this stage you will complement your analytical skillset with statistical functions. Here we cover the functions: AVERAGE / AVERAGEIF / AVERAGEIFS / COUNT / COUNTIF / COUNTIFS / COUNTA / COUNTBLANK / SMALL / LARGE / MIN / MAX.
M4: Supporting Excel File
Reference Functions – Part I
Reference Functions – Part II
Quiz M4: Reference Functions
Reference functions are important for more complex assessments in your spreadsheets. You will be able to do that with the functions: MATCH / INDEX / OFFSET.
M5: Supporting Excel File
Lookup Functions – Part I
Lookup Functions – Part II
Quiz M5: Lookup Functions
Learning how to quickly extract data points from a dataset is a crucial skill you must have. Here you will learn the functions: VLOOKUP / HLOOKUP / LOOKUP.
M6: Supporting Excel File
Date & Time Functions – Part I
Date & Time Functions – Part II
Quiz M6: Date & Time Functions
Almost every spreadsheet contains date variables, and you must work with them precisely. In this module you learn the functions: TODAY / MONTH / DAY / YEAR / DATE / EOMONTH / EDATE / NOW.
M7: Supporting Excel File
Financial Functions – Part I
Financial Functions – Part II
Quiz M7: Financial Functions
This is the heart of the course. If you want to go one step ahead and correctly learn how to handle financial functions in Excel, you need to master this module. Here you will learn the functions: FUTURE VALUE (FV) / PRESENT VALUE (PV) / PMT / RATE / NPER / NPV / IRR.
M8: Case Study – Instruction
M8: Case Study – Supporting Excel File
Case Study – Part I
Case Study – Part II
Case Study – Part III
Conclusion
After studying all the 50 functions in the first 7 modules of the training, here you will be able to apply everything you learned in a financial projection case study.
Instant access: £ 79
You’ll be redirected to Thinkific checkout.
This intense course was designed to offer practical knowledge, allowing you to firmly face complex tasks like never before. Don’t miss this opportunity to become one of those rare professionals who truly understand Excel functions.
Join the KEF 50 course now and completely improve your efficiency and
preciseness at work.
Click on the button below
to guarantee your spot!
Whether you’re a beginner looking for new skills or a seasoned professional looking to improve, our students experiences can give you valuable insight into what you can achieve.
The course is straight to the point with clear explanations provided by the instructor. The KEF 50 training course helped me not only to learn the functions in isolation which used to be a hard task for me, but it also guided me on how to combine the main functions which helped me to tackle complex and routine Excel calculations I need to perform in my business. I do recommend it!
I purchased the course because I needed to understand how a new product project could yield results, and I had no idea how to track that in Excel. The functions explained by Keynance throughout the course unlocked my knowledge, and now I feel much more confident in financially managing the launch of new products for my company. It has made a significant difference in advancing my business model. I highly recommend it.
We strongly believe our KEF 50 Course will be a major supporting tool on your journey to becoming an advanced Excel user and that it will help your career in more ways than one. But, in case you are not happy with the course for any reason, we have a 14-day money-back guarantee. So, there is no risk for you!
Over 17 years of experience working on complex financial modelling transactions for banks and investors.
CFA (Chartered Financial Analyst) charterholder since 2014.
Graduated in Economics from the University of São Paulo (USP).
Very experienced in using Microsoft Excel spreadsheets.
Created Keynance in 2019, based on his own experience with problems he has faced and solved throughout the years, to help individuals and companies manage their work in Excel most efficiently.
Passionate about finance, Excel, and saving time.
Determined to demystify the world of Finance, particularly Finance in Excel.
Approximately 20k views on YouTube and Instagram videos about Excel and Finance.
"*" indicates required fields
E-mail:
info@keynance.com
Created Keynance in 2019, based on his own experience with problems he has faced and solved throughout the years, to help individuals and companies manage their work in Excel most efficiently. 
