Personal / Professional Skills
Academic Skills
Courses by Categories
Organizations from any size and industry can use Clever ED!
Quickly Browse
By: Random person
Code: 21345
Availability
This Course is Free, enroll to access
Students enrolled: 1,000
Availability: This course is free to own Sign in
Delivery: This course is self-paced
Published: June 7, 2021
Updated on March 9, 2023
In this course, you will learn various techniques to effectively manage data in Microsoft Excel. You will learn how to sort data in ascending or descending order based on one or multiple columns, and how to apply filters to refine your results.
You will also learn how to create, modify, and format tables, and use table features like sorting and filtering. Furthermore, you will discover how to create different types of charts, customize chart elements, and format charts to make them visually appealing.
In addition, you will learn how to work with date and time functions to perform calculations, extract specific information, and format dates and times. You will also understand how to use logical functions to make decisions and automate tasks, and lookup functions to retrieve data from other parts of the workbook.
You will learn how to collaborate with others on the same workbook, track changes, and use comments to communicate with others. Additionally, you will learn how to protect your workbooks and worksheet data to prevent unauthorized access or modifications.
By mastering these techniques, you will become more efficient and productive in managing and analyzing data in Excel.