3 -Day Online Training on Data Management and Analysis using Advanced Excel

Master the essentials of Data Management and Analysis using Advanced Excel at the comfort of your location. Grab our 3 Day Easter Special offer and gain Advanced Excel Skills at an extremely pocket friendly investment. Data Analysis and Management using Advanced Excel is designed to provide participants with a comprehensive and hands-on approach to harness the full potential of Microsoft Excel for data analytics. The course begins with an introduction to fundamental Excel functions and formulas, gradually progressing to advanced features like pivot tables, Power Query, and Power Pivot. Participants will gain proficiency in organizing, cleaning, and analyzing large datasets, enhancing their ability to derive meaningful insights.

Program Objectives

• Familiarize with advanced formulas and functions in Microsoft Excel
• Easily combine, link and export data
• Create key outputs from data (tables and graphs)
• Reduce the amount of time spent in delivering output through Microsoft Excel through time-saving keyboard shortcuts.
• Easily summarize, analyze, and present data through pivot tables and charts.

Modules

Module 1: Excel Basics

• Navigating within the sheet
• Making selection
• Entering data
• Data management in Excel
• Deleting unwanted data
• Find errors, conditional formatting, and data validation.

Module 2: Introduction to Excel Formatting

• Adjusting Numeric Formats
• Controlling Fonts, Borders, and Cell Color
• Alignment Tools & Other formatting Tools
• Row, Column and Sheet Adjustment & Adding Picture
• Referencing in Excel
• Working with Structured tables
• Excel Formula Basics
• Keyboard shortcuts in Excel

Module 3: Pivot Table and Pivot Charts

• Preparing data for use with Pivot Table
• Creating Pivoting Tables
• Summarizing PivotTable Data
• Sorting and Filtering Pivot Table
• Formatting PivotTable
• Applying Conditional Formatting
• Working with Calculated Fields
• Grouping Data
• Filters and Advanced Filter
• Advanced Data Field Settings
• Creating Pivot Chart
• Power Query
• Printing Pivot Tables and Pivot Charts

Module 4: Excel Functions

• Lookup/Ref Functions
• String/Text Functions
• Date/Time Functions
• Math/Trig Functions
• Statistical Functions
• Logical Functions
• Information Functions
• Financial Functions
• Database Functions

Certification

Upon successful completion of the training, participants will be awarded Cynet East Africa Consultancy certificate.