Excel Formulas: Beginners Level I
About Course
Excel Formulas Beginners Level I Course
Welcome to the Excel Formulas Beginners Level where we show you how to learn Excel! This course is designed to help you become a pro at learning Microsoft Excel without any tricky stuff.
We’ll start by showing you how to use Excel in a simple way. You’ll learn how to move around the program, make new files, and type in information. Once you’ve got the hang of that, we’ll move on to making your work look nice. You’ll find out how to change the way things look, make graphs, and print out your work.
We’ll teach you how to save your work and keep it organized. You’ll understand how Excel files are structured and how to move around inside them using your mouse or special keyboard shortcuts.
Learn Microsoft Excel
Learning Microsoft Excel, we’ll talk about cool things like the Ribbon, shortcut menus, and the Quick Access Toolbar customization. But don’t worry, we won’t play any tricks on you. You’ll also learn about boxes that pop up, how to make, change, and organize your files, and how to put different kinds of information into your files, like fractions, dates, and times. And of course, we’ll show you how to make math calculations and use formulas.
It’s Simple
As you get better, we’ll go even further. You’ll learn about different ways to look at your Excel sheets, how to make things look exactly the way you want them to, and how to hide and show parts of your work. We’ll also get into the nitty-gritty of Excel, like creating fancy tables, sorting and filtering your data, and using functions and formulas for calculations. We’ll even cover things like money calculations and statistics.
And there’s more! We’ll teach you how to search for information, make things look special based on certain conditions, and work with text in cool ways. You’ll get the hang of working with dates and times, rounding numbers, and dealing with percentages.
By the time you finish this course, you’ll have all the tools you need to use Excel like a pro. You’ll know how to do everything from the basics to some pretty advanced stuff. This will help you work with data, figure things out, and show your work while you learn Microsoft Excel. So, let’s get started on this Excel adventure!
Course Content
SUMPRODUCT Function
-
9-B Excel Beginner: Calculate Vehicle Prices in Minutes with Sumproduct!
08:38 -
Calculate Vehicle Prices in Minutes with Sumproduct
-
10-B Excel Beginners: Count Golf Scores with Sumproduct!
04:34 -
Count Golf Scores with Sumproduct
-
21-B Excel for Beginners: Learn How to Total Characters with Sumproduct
08:15 -
Learn How to Total Characters with Sumproduct
-
22-B Say Goodbye to Confusing Formulas: Unlock the Magic of SUMPRODUCT Function
04:17 -
Unlock the Magic of SUMPRODUCT Function
-
30-B Excel Made Easy: Counting Holidays Between Dates with SUMPRODUCT!
07:58 -
Counting Holidays Between Dates with SUMPRODUCT
-
35-B Learn Excel: How to Total Dates by Year!
07:38 -
How to Total Dates by Year
-
43-B Excel Beginners: Count Matching Rows with SUMPRODUCT!
04:37 -
Count Matching Rows with SUMPRODUCT
-
50-B Excel Workarounds for Beginners: Mastering SUMPRODUCT Formulas
09:18 -
Mastering Sumproduct Formulas
-
541-B Excel Beginners! Learn How to use SUMPRODUCT for Accurate Character Counts
02:54 -
Learn How to use SUMPRODUCT for Accurate Character Counts