Microsoft Excel, Part 1
Learn the basics of Microsoft Excel, such as how to start a new worksheet, add a table, and change cell format, including width of columns and rows.
$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
Earn a credential
Overview
Develop basic Excel skills quickly in this online Excel tutorial. This self-paced course will help you develop new Microsoft Excel skills that you can use for personal or business data and information. In this online Excel course, you'll learn to start a new Excel worksheet, add a table, and change cell format, including width of columns and rows. You will also learn how to flash fill information and use the AutoSum feature.
Excel is a versatile workspace that not only helps you organize information, but it can help you to see data differently and better understand the data you have. Thanks to the functions, flexible organizational structure and settings within Excel, you can create worksheets of information that automatically calculate numbers, automatically populates data, or verifies whether entered data is accurate, saving you time. Start learning how to use Excel today and understand how the program can be used for all manner of information.
About this course
- Create a new Excel workbook: a workbook is an entire file of data in Excel, including the tabs within your series of spreadsheets. Learn to create a file, or workbook, within Excel.
- Add data to a table: learn how to populate the fields within Excel with the information you need to organize.
- Apply table styles: Format the data within your table or Excel spreadsheet, so that you can easily read the contents within the columns and rows.
- Apply cell styles: Excel styles go well beyond the test size and format. Use formatting in Excel to verify your data within your workbook.
- Change cell format: alter the format for your rows and columns to ensure data displays accurately for each cell, like formatting your dates so they all appear in the same format, or to ensure that monetary values place the decimal in the correct place.
- Add, delete, and move columns and rows: rearrange your table to add space and move sets of data to the correct position.
- Change width of columns and rows: format the layout of your workbook to fit all the information you need to place in each cell.
- Use Flash Fill: In Excel, Flash Fill is a tool that helps you automate the entry of data into your workbook based off patterns within the data you've already entered. Use Flash Fill to save time and energy when creating your workbook!
- Use AutoSum button: AutoSum will save you time entering numerical data into a calculator. Instead of typing the data into a separate program, use AutoSum to automatically tally information you've included in your workbook!
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.