Expand your knowledge of Microsoft Excel.

In this online course you will learn how to take your financial and data analysis to a deeper level through interactive tutorials and simulation-based exercises. Explore intermediate formulas and formatting, charts and tables. You will also learn how to manage data, print and distribute, and collaborate. Enhancements for 2019 include six new or improved functions, new form capabilities and the ability to create automated workflows.

By the end of the course, you will be able to:

• Use intermediate formulas including cell and range names, absolute and relative references as well as display and date formulas.
• Apply intermediate functions including insert, CONCAT and PMT function.
• Use intermediate formatting to apply and remove cell styles, create and modify cell styles, find and replace, apply conditional formatting and apply themes.
• Create, move and resize charts, add titles and legends, modify chart data, and create dual-access charts and sparklines.
• Manage data, including flash fill, data validation, outline and subtotal, quick analysis, and importing and exporting.
• Build tables, sort and filter data, add rows and columns, modify styles, add slicers and remove duplicates.
• Set print area and page breaks, monitor page size and scale and inspect print documents for quality control.
• Share and co-author workbooks, add cell comments and version history, and protect your worksheets and workbook structure.