Exploring essential functions in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 11 videos | 40m 33s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
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 2s
    This 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
  • 4m 44s
    The 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
  • Locked
    3.  Counting cells in Excel 365
    2m 42s
    Excel 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
  • Locked
    4.  Rounding numbers in Excel 365
    4m 30s
    Microsoft 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
  • Locked
    5.  Using the OFFSET() function to extract values in Excel 365
    3m 31s
    When 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
  • Locked
    6.  Generating random numbers & sequences in Excel 365
    4m 34s
    While 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
  • Locked
    7.  Cleaning up text in Excel 365
    4m 6s
    Excel 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() fuctions 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
  • Locked
    8.  Measuring text in Excel 365
    2m 54s
    In 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
  • Locked
    9.  Extracting text in Excel 365
    4m 2s
    Excel 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
  • Locked
    10.  Combining text in Excel 365
    3m 46s
    In 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
  • Locked
    11.  Replacing text in Excel 365
    4m 43s
    The 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.

YOU MIGHT ALSO LIKE

Course Adding & arranging data in Excel 365
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Working with tables in Excel 365 (2023)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Creating PivotTables and PivotCharts in Excel 365
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Getting started in Excel 365 (2023)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)