Get up to speed with Microsoft Excel, the world’s most popular spreadsheet program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells
Worksheets live in workbooks in Excel and create the building blocks of documenting, analyzing, manipulating, and presenting data. This module will help you get started by creating worksheets and workbooks. You’ll also learn how to navigate your way around Excel worksheets and workbooks. We’ll take a look at formatting both worksheets and workbooks.
LessonsCreate Worksheets and Workbooks Navigate in Workbooks and Worksheets Modify Worksheets Format Workbooks Customize Options and Views Configure Worksheets and Workbooks
Tables help you sort, filter, and summarize data. Tables data is managed independently from data in the other rows and columns on the worksheet. In this module, you’ll learn to create and manage tables, apply styles and configure table style options, and work with filtering and sorting strategies.
LessonsCreate and Manage Tables Manage Table Styles and Options Filter and Sort a Table
Excel’s power lies in its ability to make calculations that help you analyze data. This module explains how to build the formulas and use the functions that can help you make your calculations. You’ll learn about formulas, basic functions, conditional functions and using functions to format and modify text.
LessonsBuilding Formulas Perform Basic Functions Perform Conditional Functions Format and Modify Text Using Functions
Quick Analysis includes a number of formatting, charts, and totals shortcuts to help you visualize your data. Recommended Charts are another way of quickly visualizing your information. This module looks at these shortcuts, as well as creating and formatting your own charts and using and formatting other types of objects.