Explore formulas in Excel – the premier way to handle calculations.
While computers are good at many different tasks, they still thrive most in the areas of math and automation. Excel formulas, which combine both aspects, have thus become an important facet in regular business activity and made compiling important data much easier.
You’ll explore the foundations of using formulas to manipulate your data in more dynamic and calculative ways. From adding numbers in two different cells together, to doing more advanced logic with dates, you’ll learn valuable techniques that simplify how you obtain certain data without ever pulling out a separate calculator.
Regardless of your skills in math or goals, Excel formulas will allow you to unlock the full power of spreadsheet management and automate many tedious tasks that can hamper productivity.
This course assumes basic Excel skills.
You will learn how to:
- Set up mathematical operations
- Use absolute references for easy auto-filling
- Access basic functions, such as averaging
- Reference data on other sheets
- Manipulate dates using formula logic
- Deal with named ranges in formulas
YOUR COURSES, YOUR WAY
Learn with project-based courses that are designed to be flexible – access them 24/7, fit them around your schedule, and choose the learning materials that suit you best.
You can even download your course videos and watch them offline using the Zenva app, available on iOS and Android.
✅ Watch video lessons
✅ Read text summaries
✅ Explore interactive lessons
✅ Practice with source code
✅ Build real projects
✅ Earn completion certificates
ACHIEVE REAL RESULTS
Our community of 1,000,000+ learners and developers have used the skills learned with us to publish their own games and websites, land their dream jobs, and even start their own businesses – and you have the potential to do the same!
Check out what our learners think below:
I love the lectures, concise course objectives, and how they not only teach you enough to get started, but prepare you for the advanced stuff later down the road.
With Zenva, I started learning a more accurate way to approach problems and develop solutions. It’s full of interesting topics that I love to learn in conjunction with my work.
I chose Zenva because of the large selection of topics and the fact that I can choose what courses I want to take whenever I want to take them. That level of freedom is unique to Zenva.
The Unity courses at Zenva helped me achieve a level of comfort with game development that I didn’t think was possible. They give you the confidence to expand your skills, and were so easy to understand.
LEARN FROM WORLD-CLASS INSTRUCTORS
Our course instructors participate in elite developer programs and have been recognized for their demonstrated excellence in development and teaching.
That way, you can be confident that you’re learning the most up-to-date content from industry experts.