Excel Data Management: Fundamentals to PivotTables
Course
This course introduces essential Excel skills for managing and analyzing data, from basic navigation and calculations to working with larger datasets and summarizing information using PivotTables.
Skills you’ll gain: navigating the Excel interface, entering and formatting data, creating basic formulas, handling common errors, sorting and filtering datasets, using core functions (SUM, AVERAGE, COUNT), creating charts, building and customizing PivotTables, and managing and sharing workbooks.
Here is the course outline:
1. Excel Fundamentals and Basic CalculationsCovers the Excel interface, workbook and worksheet structure, and basic data entry techniques, along with simple formatting and creating formulas using arithmetic operations to calculate totals and averages, including handling common formula errors. 5 sections
|
|||||
|
2. Data Management and Visualization BasicsFocuses on managing larger datasets using sorting, filtering, and find and replace, applying core functions such as SUM, AVERAGE, and COUNT, and creating and formatting charts for basic data visualization. 5 sections
|
|||||
|
3. PivotTables, Advanced Visualization, and CollaborationIntroduces PivotTables for summarizing data, along with advanced chart formatting techniques, and explores collaboration tools such as sharing workbooks, adding comments, and tracking changes. 7 sections
|
|||||||
|
4. Advanced PivotTables and Workbook ManagementCovers deeper PivotTable operations such as modifying fields, grouping data, applying filters, and updating data sources, along with workbook management tasks like printing, sharing, protecting data, and using Excel shortcuts. 4 sections
|
||||
|
5. We want to hear from you!Learning Management System — NPS 1 section
|
|
|