Did you know that 95% of
financial analysts
don’t know how to combine functions to solve complex tasks in Excel?

Don’t be part of these statistics!

Get Started Now

You’ll be redirected to Thinkific checkout.

Excel Master Course

Are you tired of spending hours managing spreadsheets because you still haven’t dominated MS Excel? Stop fighting against them and optimize your time!

Get Started Now

Instant access to annual subscription: £ 199

Excel Master course

14 hours of recorded
lectures plus Live Classes

Excel Master is a 14-hour modular training course carefully designed and which covers everything you need to know to become an Excel specialist. From basic functions to advanced Excel data management tools. 
 
  • Easy to follow modular curriculum.
  • Practical learning method with downloadable spreadsheets.
  • Case study to wrap up all you learned during the entire course.
Key Features

At the end of this course, you will not feel lost anymore in Excel and you will start leading your workload with efficiency. Become a confident and advanced Excel expert, ready to overcome any obstacles when it comes to finance in Excel. Inside the course you will find:

Applied Content

The 14-hour modular course is split into 10 different sections, from the fundamentals of Excel all the way to the more complex Excel topics, ending in a Case Study which integrates all the acquired knowledge!

Extra Support

In addition to the recorded lectures, you will have access to quizzes, forum for questions, live classes every month and a completion certificate to demonstrate your progress at work!

12-month Access 

Here you have access to all resources for an entire year which will help to revisit the lectures, practice the quizzes and exercises and ask any questions you may have!
Find Out How To Use Excel More Efficiently

Instant access to annual subscription: £ 199

Course Curriculum

Upgrade your skills with a course carefully split into 10 sections.
Here’s what you can expect:

Course Curriculum

Upgrade your skills with a course carefully split into 10 sections.
Here’s what you can expect:

Fundamentals of Excel

1.1 Course Overview

1.2 Excel Overview

2.1 Data Entry  

2.2 Basic Formatting  

2.3 Inserting Formulas  

2.4 Go to Special  

2.5 Data Extraction  

2.6 Data Validation  

Ex. 2 Exercise S.2  

3.1 Protection  

3.2 Excel Visualization  

3.3 Paste Special  

3.4 Excel Shortcuts  

3.5 Hyperlinks  

Ex. 3 Exercise S.3  

4.1 Basic Formulas (Parts I & II)  

4.2 Cells Reference  

4.3 Range Names  

4.4 What-If Analysis  

4.5 Formula Tools & Tips (Parts I & II)  

Ex. 4 Exercise S.4  

Functions

5.1 Logical Functions (Parts I & II)  

5.2 Math Functions (Parts I & II)  

5.3 Statistical Functions (Parts I & II)  

5.4 Reference Functions (Parts I & II)  

5.5 Lookup Functions (Parts I & II)  

5.6 Date & Time Functions (Parts I & II)  

5.7 Financial Functions (Parts I, II & III)  

Ex. 5 Exercise S.5  

Analytical Tools

6.1 Data Sorting (Parts I & II)  

6.2 Data Filtering  

6.3 Data Cleaning  

6.4 Find & Replace  

6.5 Excel Tables  

Ex. 6 Exercise S.6  

7.1 Charts – Introduction  

7.2 Variance & Combo Charts  

7.3 Charts – Special Features  

Ex. 7 Exercise S.7  

8.1 Pivot Table – Introduction  

8.2 Pivot Table – Management  

8.3 Pivot Table – Important Tools  

Ex. 8 Exercise S.8  

9.1 Advanced Formatting  

9.2 Conditional Formatting  

9.3 Printing Techniques  

Ex. 9 Exercise S.9  

Case Study

10.1 Case Resolution – Part I  

10.2 Case Resolution – Part II  

10.3 Case Resolution – Part III

I WANT FULL ACCESS TO THE EXCEL MASTER COURSE

Instant access to annual subscription: £ 199

Live Classes

Direct access to your mentor Kleber Hernandez
In the Excel Master course, we not only offer high-quality content, but we also give you the opportunity to attend live classes twice a month, where you can interact directly with your mentor Kleber Hernandez. These live classes are crucial for you to deep dive in the 4 big areas of the program.

Interactivity and Personalized Support 

During the live classes you will not just be watching the explanations. You will also be able to ask questions and receive answers in real time on the most relevant questions. This will enable you to effectively apply all the acquired knowledge at work.

Join us and transform your
proficiency in Excel

Sign up today and start the journey to become an Excel Master with the support from those who understand this topic!

Join our exclusive community!

In the Excel Master Course, we understand the learning is more effective when the knowledge is shared. That’s the reason we created an exclusive community for the students of this course. The Keynance Excel Master Community (KEMC) is a space where you will be able to explore, discuss and overcome challenges in a group environment with people from all over the world and who have the same goals.

Analytical Tools

The KEMC members can start out new discussions about complex Excel issues they face at work, receiving support and new perspectives on how to tackle real-world problems.

Problem Solving Focus

The topics covered in the discussions inside the Keynance Excel Master Community (KEMC) are not limited only to those covered inside the course. Any Excel related questions can be raised where participants and the instructor will interact accordingly.

Ongoing Support

The community offers ongoing support throughout the entire duration of your license. This will enhance your knowledge after you complete watching the lectures.

Examples
of
Success

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.

Your Instructor

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.  

SEE MORE ABOUT THE INSTRUCTOR
Your
Instructor


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.

SEE MORE ABOUT THE INSTRUCTOR
Your
Instructor


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.

SEE MORE ABOUT THE INSTRUCTOR

Target Audience

Do you feel you are not getting the most out of Excel?

Are you often confused as to which type of function to use or how to select the right tool for any given task?

Do you feel like you are falling behind your peers?

This course is addressed to all those who want to become better Excel users and learn more about finance in a practical way. We aim to provide the correct Excel foundation to complete beginners and even experienced users who want to improve and refine their Excel skills. 

The lectures are based on Finance-related topics like revenue, cost, and investment calculations, which is helpful for professionals in different areas, such as those who work in administration, accounting, accounts payable and receivables, finance, cost control, business planning/development, and related areas. Of course, people from all areas of expertise are welcome to this course, as it helps anyone who wants to master Excel. 

SPEED UP YOUR ANALYTICAL SKILLS IN SPREADSHEETS

Instant access to annual subscription: £ 199

Course Benefits

Increase your employability and salary prospects  

A deep understanding of Microsoft Excel can open many doors in the professional career. It’s widely used in every industry in the world, so dominating Excel can boost your growth at work and improve your career prospects so you can enjoy a better salary. The choice is in your hands! 

Become more productive in how you work   

Are you using the most practical Excel tools? Learn shortcuts or functions that will allow you to achieve your tasks more efficiently. If you value your career and personal time, don’t spend hours working on a spreadsheet when you can finish it within minutes if you know the correct approach.

Learn new critical skills that will speed up your work in Excel

Learn autonomously and put your new skills to the test immediately. Excel can do a lot more than you can imagine. If you’re feeling frustrated at work because you find Excel hard to use, start upskilling right now. Stop working extra hours and being stuck at work! 

Increase your job satisfaction and confidence  

At the end of this course, you will have a solid foundation of Excel skills that will allow you to complete simple or complex tasks with confidence and much faster than ever before. Stop being intimidated by Excel! 

Bonus

Exclusive community

Our community is waiting for you, and they will give you the extra support you deserve! In addition to the whole course package, you also have access for a full year to a powerful community moderated by the instructor in which Excel Master students from all over the world will be able to share their own experiences, connect and exchange Excel tips. The Keynance Excel Master Community (KEMC) provides valuable additional support that will improve your learning experience by allowing you to learn not only from the instructor but also from your fellows!

Don’t let the lack of advanced Excel skills block your growth potential. Join the hundreds of professionals who are already making the difference in their careers with our Excel Master course.

I WANT TO BE PART OF THE KEYNANCE EXCEL MASTER COMMUNITY TOO

Instant access to annual subscription: £ 199

Money-back Guarantee

We strongly believe our Excel Master Training package 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!

FAQ

No. This is for anyone interested in applying Excel correctly, in a transparent, logical, and time-efficient manner. I designed this course to suit a variety of professionals from areas like finance, administration, accounting, business development, cost control, FP&A, and more. The sole purpose is to provide straightforward and practical explanations, which are based on situations I had to face myself over the years. People from any profession will also be able to gain a lot from this course.

If you are not satisfied with the course, you have the right to request a refund up to fourteen days after enrolling. There’s no risk whatsoever for you.

This is a self-paced training, meaning you can watch and practise the content whenever you want. The Excel forums are always available as well, so you can post questions at any time and our team will answer promptly. As a complement to the training, you will be able to join 4 different live classes covering each of the 4 major areas of this 10-section course. These live events are basically recaps of topics already covered in the recorded lectures and there will be live Q&A sessions. All live classes are repeated every 2 months. So, in case you miss one of them, you can always attend the next one available during your 12-month license period. This is the real ongoing support that you need to succeed in Excel!

The course and live classes are designed for a student to complete the entire course in 2 months. However, you receive one-year access with your purchase and the renewal is automatic. As such, you can watch and practise the content as often as you need to during these 12 months and keep asking questions in the Forums and the Keynance Excel Master Community (KEMC).

Remember that this is a sequential modular course, which is split into sections, lectures, and topics. This allows you to find Excel topics quickly so you can review specific lessons according to your needs. In other words, Keynance Learning is a long-term partner in your journey toward Excel mastery!

Once you are already a Keynance student, you will be able to renew access to the course content (including all the training resources and live classes) and the Keynance Excel Master Community (KEMC) for one more year with a potential discount.

The only requirement is the willingness to learn and grow. The course was designed for users of all levels of expertise, from people who want to learn how to use Excel correctly from scratch all the way up to advanced users who want to fill in the gaps in their Excel knowledge.

Important Note: All video lectures were recorded using Microsoft Excel on Windows. Therefore, some Excel shortcuts may differ for Mac Users. A list of the Excel shortcuts in Windows (with the corresponding ones in Mac) is available for download after you log into the course.

Send an e-mail to info@keynance.com or click on the WhatsApp icon on the bottom right corner of your screen to start a conversation. We will be happy to help you!

I WANT TO BECOME MY COMPANY’S EXCEL EXPERT

Instant access to annual subscription: £ 199

Subscribe to our newsletter

Form 2: Newsletter

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Privacy Policy
Cookies Policy
Terms & Conditions


Privacy Policy | Cookie Policy | Terms & Conditions


Privacy Policy | Cookie Policy | Terms & Conditions

© 2024. KEYNANCE LEARNING LTD. Registered in England and Wales. Company Number: 12126888.
  Developed by Digital Bees ®

Follow by Email
LinkedIn
Share
WhatsApp