Microsoft Excel for Office 365 (Desktop or Online): 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

10 hours 40 minutes
Sessions

On-Demand
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® 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 pen-and-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. Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using Excel for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version. This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps): Exam MO-210 and Microsoft Excel Expert (Microsoft 365 Apps): Exam MO-211 certification exams. This course is intended for students who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. In this course, you will: familiarize yourself with Excel's layout, its various parts, its commands, and its terminology; outline Excel's abilities to quickly, efficiently, and accurately calculate data; update worksheets without throwing away all of the valuable work you've already done; format a worksheet and organize your data; print workbooks; and manage the overall structure of your 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

You want to use Microsoft® Excel® 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® Excel® 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® Excel® 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® Excel® 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® Excel® 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® Excel® 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.