Microsoft Excel, Part 2
In this second of two online Excel classes, learn to use complex workbooks, sort and filter data, and use charts.
$229
Total: Course cost
2 hours to complete
modules
Online - self-paced
Learning modality
Earn a credential
View credential
$229
Total: Course cost
2 hours to complete
modules
Online - self-paced
Learning modality
Earn a credential
View credential
$229
Total: Course cost
2 hours to complete
modules
Online - self-paced
Learning modality
Earn a credential
View credential
$229
Total: Course cost
2 hours to complete
Duration
Online - self-paced
Overview
Advance your knowledge of Excel in this second of two self-paced online Excel classes. Learn how to use complex data sets and workbooks, and sort and filter through your Excel data in this online class. As your data sets grow and become complicated, you will save time and frustration by leveraging the tools and automation practices within Excel. Organize your data through sort, hide data that’s not relevant in the filters, and format cells to make your information easier to review. This online excel class will help you through personal and business use cases such as:
- Calculating the highest sales month in a year
- Taking an inventory of your stock and determining trends in specific wares
- Reviewing operating budget trends throughout the year
- Creating a graphic that visually represents your data accurately and easily
About this course
- Create a new workbook with more than one worksheet: new worksheets within a workbook help to organize information that is in particular groupings.
- Sort data in a table: sort your information in your workbook alphabetically, by numerical value, date or custom organization.
- Filter data in a table: Filtering information in your Excel workbook allows you to hide data without losing the information.
- Use the COUNTIF function: The COUNTIF function allows you to see how many times a certain piece of information appears in your worksheet.
- Use the IF function: Use the IF function to form a logic around certain sets of data in your workbook. For example, you can use this function to automatically see if your operating costs are under budget in your monthly spend entries throughout a year.
- Create a clustered column chart: A clustered column chart is sometimes called a bar graph because it shows data organized in solid shapes like pillars.
- Modify chart style: Choosing the format of your chart (bar, pie, line) can help you and your audience understand different components of your data. Learn how to create different chart types within Excel.
- Create sparklines: Sparklines are mini graphs that show up within the cell of your workbook to more easily communicate information for users in between your data.
- Create and apply conditional formatting: create organizational and formatting rules in your spreadsheet that treats specific data or data types differently. For example, if you want to see any case in which a customer ranks your services as poor within a million customer feedback entries, you can tell Excel to highlight the word “poor” in your data.
- Change page layout orientation: determine whether your information is better suited for horizontal (landscape) layout or a vertical (portrait) layout orientation.
- Change margins: Alter your margins to ensure your Workbook can easily print on a standard printer, or fit within a larger report or presentation.
Recommended resource
Try a free job simulation created by top companies to build skills relevant to this program.
Data Analytics Job Simulation
Take this free real-world job simulation to: Test drive a career/role and demonstrate skills to an employer.
Certificate program
This course is a part of the following certificate program:
Connect with our team
Complete a brief form to get program recommendations and answers to your questions.