Exploring essential functions in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 11 videos | 43m 32s
- Includes Assessment
- Earns a Badge
- CPE
Excel functions cover a wide array of uses, from formatting text to performing calculations. This course delves into several of the most common functions in Excel 365. The course begins by exploring fundamental functions for working with data. You will see how to perform operations based on specific conditions using the IF() function. Learn how to use functions to count cells, round numbers, and generate numeric data. You will also discover the OFFSET() function, which lets you extract specific values from a dataset. The second part of the course covers some helpful functions for working with text. See how to clean up your text by removing spaces and changing letter case. Find out how to count characters and character positions using LEN(), SEARCH(), and FIND(). Finally, you will see how to use functions to extract text, combine multiple text strings, and replace one string with another. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in the exploring essential functions in excel 365 course
Use the if() function to perform conditional operations
Use the count(), counta(), and countblank() functions to count cells in a range
Use the round(), roundup(), rounddown(), mround(), ceiling(), and floor() functions to round numbers
Use the offset() function to extract values from a data set
Use the sequence(), rand(), and randbetween() functions to generate sequences and random numbers -
Use the upper(), proper(), and lower() functions to modify the lettercase of a string
Use the len() function to count the number of characters in a string
Use the left(), right(), and mid() functions to extract text
Use the concat() and textjoin() functions to combine text strings
Use the substitute() and replace() functions to replace strings within text
IN THIS COURSE
-
1m 4sThis video outlines the key content covered in the Exploring essential functions in Excel 365 course, including using the IF() function, generating random numbers and sequences, and combining text. FREE ACCESS
-
5m 5sThe IF() function allows you to test a condition, then return one value if that condition is true and another if it is false. In this video, you will see how to use IF() to return text and perform calculations. You will also learn how to solve common errors that can arise when using IF(). This video aligns with MO-210 Microsoft Excel Exam objective: Perform conditional operations by using the IF() function. FREE ACCESS
-
3. Counting cells in Excel 3652m 48sExcel proposes several functions for counting cells. These functions can be useful if you need to take inventory of items, or simply want to get an idea of how complete your records are. In this video, you will see how to use COUNT(), COUNTA(), and COUNTBLANK() to count cells in a range. This video aligns with MO-210 Microsoft Excel Exam objective: Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions. FREE ACCESS
-
4. Rounding numbers in Excel 3655mMicrosoft Excel is precise to 15 decimal places! When you don't need to be so exact, however, it can be useful to round. In this video, you will learn how to use ROUND() and its related functions. You will also see how to use CEILING() and FLOOR() to find the nearest multiple of a given number. FREE ACCESS
-
5. Using the OFFSET() function to extract values in Excel 3653m 48sWhen you work with large volumes of data, it can be hard to keep track of specific values. Luckily, the OFFSET() formula allows you to easily extract specific cells and ranges from your dataset. Find out more in this tutorial. FREE ACCESS
-
6. Generating random numbers & sequences in Excel 3655m 6sWhile many functions are used to analyze existing data, you can also use functions to generate entirely new values. In this video, you will see how to use the SEQUENCE() function to create a linear series of numbers across rows or columns. You will also learn how to use RAND() and RANDBETWEEN() to generate random numbers. This video aligns with MO-210 Microsoft Excel Exam objective: Generate numeric data by using RANDBETWEEN() and SEQUENCE(). FREE ACCESS
-
7. Cleaning up text in Excel 3654m 18sExcel contains a few different formulas to help you polish the formatting of your text. In this video, you will see how to use the UPPER(), PROPER(), and LOWER() functions to change letter case. You will also learn how to use TRIM() to remove extraneous spaces. This video aligns with MO-210 Microsoft Excel Exam objective: Format text by using UPPER(), LOWER(), and LEN() functions. FREE ACCESS
-
8. Measuring text in Excel 3653m 4sIn Excel, there are different ways to measure the characters in a given text. LEN() returns the length of a text string, including spaces and punctuation. SEARCH() and FIND() both allow you to find the position number of a specific character or string within text. This video aligns with MO-210 Microsoft Excel Exam objective: Format text by using UPPER(), LOWER(), and LEN() functions. FREE ACCESS
-
9. Extracting text in Excel 3654m 20sExcel provides three functions for extracting text from strings: LEFT(), RIGHT(), and MID(). These functions can be used to extract specific parts of a text string based on their position within the string. Find out more in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Format text by using RIGHT(), LEFT(), and MID() functions. FREE ACCESS
-
10. Combining text in Excel 3653m 57sIn Excel, you can use formulas to combine text from two or more cells. You can use the CONCAT() function to combine strings of text, or use TEXTJOIN() to join text separated by a delineator, such as a space or comma. Discover both functions in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Format text by using the CONCAT() and TEXTJOIN() functions. FREE ACCESS
-
11. Replacing text in Excel 3655m 1sThe SUBSTITUTE() and REPLACE() functions both allow you to replace given text in a cell with new text. Whereas SUBSTITUTE() looks for an exact string and replaces it with the text you give it, the REPLACE() function changes the text at a particular position. Find out how to use both functions in this video. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
