Microsoft Office Excel 2021-2024: Part 1

via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Paid Certificate Available
Duration & workload

11 hours 5 minutes
Sessions

On-Demand
Level

Beginner
Subtitles

English

Found in

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional penand- paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This material will benefit users of any current Office version. The course setup is based on Office 2021. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2021): Exam MO-200 and Excel Expert (Office 365 and Office 2021): Exam MO-201 certifications. This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel that is necessary to create and work with electronic spreadsheets. Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will: • Get started with Microsoft Office Excel 2021. • Perform calculations. • Modify a worksheet. • Format a worksheet. • Print workbooks. • Manage workbooks. This course requires that you have Microsoft Excel installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

Syllabus

Getting Started with Excel 2021

You want to use Microsoft® Office Excel® 2021 to store and analyze data for your organization, but you're new to Excel and it's hard to know where to begin. In order to take advantage of everything Excel has to offer, you must first understand the "lay of the land." How do you interact with Excel? What, exactly, can it do? How do you get Excel to do these things for you? It is precisely these types of questions this lesson aims to answer. Like many Microsoft Office applications, Excel has a standard layout that provides you with access to all of the commands, work areas, options, and settings you will need to begin developing and using electronic worksheets in your day-to-day life. Taking the time to become familiar with Excel's layout, its various parts, its commands, and its terminology is a critical first step toward your goal of storing and analyzing organizational data.

Performing Calculations

The true power of Microsoft® Office Excel® 2021 lies in its ability to help you analyze your organizational data. Excel contains an incredible array of functionality to help you do this, particularly when it comes to working with numerical data. In order to take full advantage of Excel's abilities to quickly, efficiently, and accurately calculate data, you must first understand how Excel "thinks," and how to tell it what to do. In this lesson, you'll do just that.

Modifying a Worksheet

From time to time, you'll need to make changes to your worksheets and workbooks. What if the changes you need to make go beyond simply re-entering a formula or updating a value? What if you need to add a whole new column or row to your worksheet? What if that column or row is in the middle of existing data? Also, what if you discover you've made the same mistake over and over? Or, what if you need to check your spelling throughout all worksheets in a workbook? Microsoft® Office Excel® 2021 provides you with a wide variety of options for making significant changes like these to your worksheets. Understanding how this functionality works will help you keep your documents updated without throwing away all of the valuable work you've already done.

Formatting a Worksheet

Large worksheets with thousands, or perhaps millions, of data entries can be difficult to read. This can be especially true if you're working with a variety of data types, such as text, dollar amounts, percentages, and more. You may need to organize your data according to department, region, job role, or other important distinctions. And some data is simply more important than other data, and should stand out even at first glance. Fortunately, Microsoft® Office Excel® 2021 allows you to present data in a wide variety of formats that can suit your specific needs. Understanding how to use and, perhaps more importantly, when and why to use these formatting options, will help you make your worksheets easy to read, professional in their appearance, and more useful.

Printing Workbooks

You put a lot of work into creating, populating, and formatting your workbook. Now you may need to print hard copies of your workbooks to share with your colleagues, supervisor, or organizational leaders. Your workbooks may contain multiple worksheets, each of which could contain thousands of data entries, formulas, and results. Instead of printing all of this indiscriminately, you will need to print only what is necessary to deliver critical information to your audience. Microsoft® Office Excel® 2021 has a wide variety of printing options that can save your document recipients from having to sift through mounds of irrelevant data.

Managing Workbooks

So far, you have largely worked within workbooks and worksheets to enter, view, analyze, format, and present your organizational data. But there's more to being proficient in Microsoft® Office Excel® 2021 than simply working within your workbooks. Managing the overall structure of your workbooks, manipulating how you view your workbooks, and knowing how to find the workbook you need, when you need it, are all critical tasks you'll need to perform from time to time. Understanding what functionality is available and knowing how to use it will ensure you're able to get the most out of the workbooks, worksheets, and data you've already worked so hard to create.