This course introduces you to many different aspects of working with data, beginning with a look at formulas and functions. You will then look at working with data as a whole and managing rows and columns. Finally, you will learn how to customize data display with sort and filter.
The first lesson covers logging into Office 365 and Excel Online as well as how to navigate in the app. Students will learn how to open, save, share and print workbooks as well as how to use a few different help tools.
Students will learn about the wide variety of charts that are available and how to insert them. They will also learn about the best way to modify and format charts.
In this course, customizing workbooks using comments, hyperlinks and pictures are covered. We also go over modifying worksheets using the accessibility checker, managing fonts, and how to add alternative text to objects.