Your cart is empty.
Keep shopping
Formula Foundations and Functions: Learn Excel 365
1 students
Formula Foundations and Functions: Learn Excel 365
Build essential Excel 365 skills to manage data, apply formulas, and use functions for efficient, accurate spreadsheets.
Created bySimon Sez IT
Last updated 8/2025
English
What you'll learn
- Use Excel's relative reference to maintain formula integrity.
- Utilize absolute references to prevent value changes in formulas.
- Grasp the difference between Excel's formulas and functions.
- Proficiently copy formulas using the Autofill handle.
- Create formulas for addition, subtraction, multiplication, and division.
- Calculate averages and sums using the AVERAGE and SUM functions.
- Implement the COUNT function to count cells meeting criteria.
- Use the Insert Function dialog box to add functions without manual typing.
- Effectively leverage the auto-complete feature for formula entry.
- Combine multiple functions to achieve complex text manipulations.
- Use functions to extract years and months from dates and strings.
- Create dynamic spreadsheets that update automatically when data changes.
Explore related topics
Course content
2 sections • 12 lectures • 36m total length
Requirements
- Basic computer skills
- Access to Microsoft Excel 365
- Interest in working with data
- A computer with internet access
Description
This course includes downloadable course instructor files to work with and follow along.
Formula Foundations and Functions introduces you to the essential skills for working with formulas and functions in Excel 365. This course gives you a solid foundation to manage data efficiently, reduce repetitive tasks, and improve accuracy in your spreadsheets. You’ll explore practical tools and techniques that help you save time while increasing productivity.
You will begin by learning to set up an effective workspace and navigate Excel’s formula bar. You’ll practice creating formulas using arithmetic operations and discover how to use relative and absolute cell references to ensure accurate results when copying formulas. You can apply formulas quickly across your data with tips on using shortcuts and Autofill.
Next, you’ll explore Excel’s built-in functions such as SUM, AVERAGE, and COUNT, which simplify calculations and data analysis. You’ll also learn to use the Insert Function dialog box and function wizard to find and apply the right function for your needs. The course covers various categories of functions, including logical, text, date & time, and LOOKUP functions, giving you tools for multiple tasks.
You’ll also gain skills in transforming content with functions and ensuring consistency in your results. Applying these features allows you to build dynamic spreadsheets that adapt as your data changes.
By the end of this course, you will be able to create, edit, and manage formulas and functions confidently. You’ll work faster, make fewer mistakes, and present data in ways that are both accurate and easy to understand.
This course includes:
37 minutes of video tutorials
10 individual video lectures
Course Files to follow along
Certificate of completion
Who this course is for:
- Beginners to Excel who want to learn formulas and functions from the ground up.
- Students who need Excel skills to support academic work, projects, or research.
- Professionals in any field looking to save time and improve accuracy in spreadsheets.
- Small business owners and entrepreneurs who want to organize and analyze business data more effectively.
- Job seekers aiming to boost their resume with practical Excel skills that employers value.
- Anyone who uses spreadsheets and wants to work faster, make fewer errors, and create reliable, dynamic spreadsheets.