Excel Formulas Cheat Sheet: Intermediate Guide

Let’s create your free account


By continuing, you accept our Enterprise DNA Terms & Conditions , our Privacy & Cookie Policy and that your data is stored.

If you have an account Login here

This Microsoft Excel intermediate cheat sheet covers a wide range of topics that will level up your skills in numerical analysis, text processing, and complex date and time logic. By having the Excel Intermediate Cheat Sheet as a desktop reference, you can dive deep into the more powerful formulas and functions of Microsoft Excel.

As you become more comfortable with the various formulas and functions highlighted in this cheat sheet, you’ll find yourself better equipped to handle increasingly complex tasks and projects. This is just a taste of what Excel’s intermediate functions can do to simplify your work, streamline your analyses, and help you uncover insights from your data.

What our Students Say
Your Author
Empty image or helper icon


Data & AI

At Enterprise DNA, we're more than just an online platform—we're your partner in advancing your data analytics and artificial intelligence capabilities. Our mission is to equip you with the tools to future-proof your career through mastery of data skills and upskilling in AI. We tailor training pathways to fit your unique learning journey and provide live data exercises and challenges to build hands-on experience. Together, we transform data into knowledge and skills into success.

Frequently Asked


Get full access to unparalleled

training & skill-building resources


Enterprise DNA

For Individuals

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities.

Learn More chevron_right


Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace.

Learn More chevron_right
Latest Guides