Excel Basics: Formulas, Functions, and Formatting

play_circle6 Assets
schedule7 Hours
Excel
Excel
Data Analysis
Data Analysis
Business Analytics
Business Analytics
Data Visualization
Data Visualization
Data Strategy
Data Strategy
Advanced Analytics
Advanced Analytics

Let’s create your free account

GoogleGoogleMicrosoftMicrosoftLinkedInLinkedIn

OR

visibility

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

About This Path

In this learning path, you'll embark on a journey through Excel's foundational functionalities. Uncover the essentials of the IF function, delve into the utility of text functions, and understand the significance of data cleaning for clear analysis. Familiarize yourself with the difference between formulas and functions. With Excel, it's not merely about calculations; it's about crafting a coherent narrative with your data, presenting information with clarity and insight.

Who Should Take This Path

  • Individuals keen on harnessing Excel's potential for data analysis and reporting
  • Those who aspire to streamline data processes and enhance decision-making using Excel

What Are The Path Requirements

  • Basic familiarity with Microsoft Excel's interface and features
  • A willingness to explore and experiment with various Excel functions and techniques
  • Access to Microsoft Excel software for hands-on practice

Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips Cover

Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips

This guide is here to simplify your journey with Excel, offering you the key tools, shortcuts, and techniques at your fingertips, so make sure to save it for future reference. 

school Resource Filewatch_later 1 hours
Excel Formulas Cheat Sheet: Intermediate Guide Cover

Excel Formulas Cheat Sheet: Intermediate Guide

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

school Resource Filewatch_later 1 hours
Microsoft Excel for Beginners Cover

Microsoft Excel for Beginners

Begin with the basics and rapidly progress to Excel mastery. This course takes you from simple spreadsheets to complex data analysis, laying a solid foundation for advanced Excel skills.

school Coursewatch_later 4 hours
Excel Tips and Tricks Cover

Excel Tips and Tricks

This lesson will show the easy and quick ways to get things done with Excel. Bob will show you a potpourri of tips & tricks not widely known.

school Eventwatch_later 1 hours
Excel Charts with Dynamic Arrays Cover

Excel Charts with Dynamic Arrays

Learn how to create interactive Excel charts using the Excel's new functions: Dynamic Arrays.

school Eventwatch_later 1 hours
Excel Formulas Cheat Sheet: Advanced Guide Cover

Excel Formulas Cheat Sheet: Advanced Guide

This Excel formulas cheat sheet covers advanced forecasting formulas, statistical analysis, data manipulation functions, error handling, and more.

school Resource Filewatch_later 1 hours

Get full access to unparalleled

training & skill-building resources
power-bi-custom-visuals

FOR INDIVIDUALS

Enterprise DNA

For Individuals

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

Learn More chevron_right

FOR BUSINESS

Enterprise DNA

For Business

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

Learn More chevron_right
power-bi-custom-visuals