Microsoft Excel from Beginner to Advanced: Including Pivot Tables, Charts, and Power Query

Master Microsoft Excel in this 2-hour live training, from basic functions to advanced techniques like Pivot Tables, dynamic Charts, and Power Query for data transformation.

Productivity

2 Hours

Description

This live, hands-on training is designed to take you from beginner to advanced level in Microsoft Excel. Whether you're new to Excel or looking to enhance your skills, this session covers everything from fundamental features to powerful tools like Pivot Tables, Charts, and Power Query. By the end of the session, you will be able to confidently analyze, visualize, and transform your data for better decision-making and efficiency in your day-to-day tasks.

Course Objectives

Understand and apply basic and advanced Excel functions and features.

Learn to create and manipulate Pivot Tables for advanced data analysis.

Master Excel charts to visualize data effectively.

Gain proficiency in Power Query to clean and transform data from multiple sources.

Develop skills to automate common tasks and optimize workflow with Excel's advanced tools.

Target Audience

Professionals looking to improve their Excel skills.

Data analysts, managers, and business users who work with large data sets.

Anyone aiming to transition from beginner to intermediate/advanced proficiency in Excel.

Basic Understanding

Basic computer skills.

Familiarity with navigating Excel’s user interface (e.g., opening, saving files, basic formula usage).

Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

Microsoft Excel from Beginner to Advanced: Including Pivot Tables, Charts, and Power Query

Session 1: Introduction to Excel (Beginner Level)

  1. Navigating the Excel interface.
  2. Basic Excel functions: SUM, AVERAGE, COUNT, etc.
  3. Formatting cells and worksheets.
  4. Basic data entry and organization techniques.

Session 2: Intermediate Excel Skills

  1. Working with multiple worksheets and workbooks.
  2. Advanced formulas: VLOOKUP, HLOOKUP, IF, COUNTIF, SUMIF.
  3. Conditional formatting for better data visualization.
  4. Sorting and filtering data.

Session 3: Pivot Tables (Advanced)

  1. What are Pivot Tables and why use them?
  2. Creating and customizing Pivot Tables.
  3. Grouping and summarizing data with Pivot Tables.
  4. Advanced Pivot Table features: Calculated Fields, Slicers, and Timeline.

Session 4: Charts and Data Visualization (Advanced)

  1. Creating and customizing different types of charts (e.g., column, line, pie, scatter).
  2. Using Excel's recommended charts and their best applications.
  3. Combining multiple data series in a single chart.
  4. Dynamic charts: Creating interactive dashboards.

Session 5: Power Query (Advanced)

  1. Introduction to Power Query and its capabilities.
  2. Importing and transforming data from various sources (Excel files, CSV, databases).
  3. Cleaning and reshaping data (removing duplicates, splitting columns, changing data types).
  4. Using Power Query to automate data refresh and merge data from multiple sources.

Session 6: Tips & Tricks for Efficiency

  1. Keyboard shortcuts and productivity hacks.
  2. Data validation and drop-down lists for improved data entry.
  3. Excel add-ins and tools to enhance functionality.
  4. Time-saving tricks with Excel templates.

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients