LEARN: Module 3 - Lesson 2: Working with Formulas, Functions, Tables, and Charts

Now that you know how to navigate through Excel workbooks, you are ready to go further to see how Excel can work with your data and perform mathematical calculations. In this lesson, you will discover how to create formulas, functions, and tables that can enhance and provide more clarity to the data presented through Excel. As we come to a close on our study of Microsoft Excel, we will now create and manipulate charts. You will gain the skills to move and resize basic charts, and make them more robust by applying layouts and styles, and customizing chart elements. Additionally, you will create pie charts as well as sparklines, which make charts easier to read by summarizing data in a visual format

Readings

• Excel 2016: Relative and Absolute Cell References Links to an external site.
• Excel 2016: Understanding Number Formats Links to an external site.
• Excel 2016: Functions Links to an external site.
• Excel 2016: Tables Links to an external site.
• Excel 2016: Filtering Data Links to an external site.
• Excel 2016: Conditional Formatting Links to an external site.
• Excel 2016: Charts Links to an external site.
• Excel Sparklines Links to an external site.

Videos

View the following videos about functions in Excel:

Use the Today & Now functions (5:28)

How to Use Date Functions in Excel (8:53)

Excel 2016: Understanding Number Formats (5:43)

How to Create a Dynamic Excel Pie Chart (8:34)