Introduction to the charting capability of Excel.
Use of Pivot tables with categorical as well as numerical data.A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel.
#HOW CAN I LEARN EXCEL ONLINE HOW TO#
You’ll learn how to set filters in data to selectively access data.
This module introduces various data filtering capabilities of Excel. Week 3, Module 3: Introduction to Filtering, Pivot Tables, and Charts Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel. This module introduces various Excel functions to organize and query data. Week 2, Module 2: Spreadsheet Functions to Organize Data