Microsoft Excel: from ZERO to ADVANCED

Microsoft Excel: from ZERO to ADVANCED, available at $49.99, has an average rating of 4.5, with 42 lectures, based on 4 reviews, and has 19 subscribers.

You will learn about Getting Started with Excel Working with Formulas and Functions Creating Charts and Other Visualizations Managing and Analyzing Data Understanding Power Pivot and Power Query Automating Excel with Macros on VBA This course is ideal for individuals who are Beginners in Microsoft Excel who want a complete course to gain all the required skills! It is particularly useful for Beginners in Microsoft Excel who want a complete course to gain all the required skills!.

Enroll now: Microsoft Excel: from ZERO to ADVANCED

Summary

Title: Microsoft Excel: from ZERO to ADVANCED

Price: $49.99

Average Rating: 4.5

Number of Lectures: 42

Number of Published Lectures: 42

Number of Curriculum Items: 42

Number of Published Curriculum Objects: 42

Original Price: €219.99

Quality Status: approved

Status: Live

What You Will Learn

Getting Started with Excel
Working with Formulas and Functions
Creating Charts and Other Visualizations
Managing and Analyzing Data
Understanding Power Pivot and Power Query
Automating Excel with Macros on VBA

Who Should Attend

Beginners in Microsoft Excel who want a complete course to gain all the required skills!

Target Audiences

Beginners in Microsoft Excel who want a complete course to gain all the required skills!

Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.

If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.

The course is divided into the following sections and chapters:

Getting Started with Excel
- Introducing Excel
- Entering and Editing Worksheet Data
- Performing Basic Worksheet Operations
- Working with Excel Ranges and Tables
- Formatting Worksheets
- Understanding Excel Files and Templates
- Printing Your Work
- Customizing the Excel User Interface
Working with Formulas and Functions
- Introducing Formulas and Functions
- Using Formulas for Common Mathematical Operations
- Using Formulas to Manipulate Text
- Using Formulas with Dates and Times
- Using Formulas for Conditional Analysis
- Using Formulas for Matching and Lookups
- Using Formulas for Financial Analysis
- Using Formulas for Statistical Analysis
- Understanding and Using Array Formulas
- Making Your Formulas Error-Free
Creating Charts and Other Visualizations
- Getting Started with Excel Charts
- Using Advanced Charting Techniques
- Creating Sparkline Graphics
- Visualizing with Custom Number Formats and Shapes
- Implementing Excel Dashboarding Best Practices
Managing and Analyzing Data
- Importing and Cleaning Data
- Using Data Validation
- Creating and Using Worksheet Outlines
- Linking and Consolidating Worksheets
- Introduction to PivotTables and Data Analysis
- Performing Spreadsheet What-If Analysis
- Analyzing Data Using Goal Seeking and Solver
- Analyzing Data with the Analysis ToolPak
- Protecting Your Work
Understanding Power Pivot and Power Query
- Introducing Power Pivot
- Working Directly with the Internal Data Model
- Adding Formulas to Power Pivot
- Power Query
Automating Excel
- Introducing Visual Basic for Applications
- Creating Custom Worksheet Functions
- Creating UserForms
- Using UserForm Controls in a Worksheet through an Example
- Working with Excel Events
- Creating Custom Excel Add-Ins

Course Curriculum

Chapter 1: Getting Started with Excel

Lecture 1: Introducing Excel

Lecture 2: Entering and Editing Worksheet Data

Lecture 3: Performing Basic Worksheet Operations

Lecture 4: Working with Excel Ranges and Tables

Lecture 5: Formatting Worksheets

Lecture 6: Understanding Excel Files and Templates

Lecture 7: Printing Your Work

Lecture 8: Customizing the Excel User Interface

Chapter 2: Working with Formulas and Functions

Lecture 1: Introducing Formulas and Functions

Lecture 2: Using Formulas for Common Mathematical Operations

Lecture 3: Using Formulas to Manipulate Text

Lecture 4: Using Formulas with Dates and Times

Lecture 5: Using Formulas for Conditional Analysis

Lecture 6: Using Formulas for Matching and Lookups

Lecture 7: Using Formulas for Financial Analysis

Lecture 8: Using Formulas for Statistical Analysis

Lecture 9: Understanding and Using Array Formulas

Lecture 10: Making Your Formulas Error-Free

Chapter 3: Creating Charts and Other Visualizations

Lecture 1: Getting Started with Excel Charts

Lecture 2: Using Advanced Charting Techniques

Lecture 3: Creating Sparkline Graphics

Lecture 4: Visualizing with Custom Number Formats and Shapes

Lecture 5: Implementing Excel Dashboarding Best Practices

Chapter 4: Managing and Analyzing Data

Lecture 1: Importing and Cleaning Data

Lecture 2: Using Data Validation

Lecture 3: Creating and Using Worksheet Outlines

Lecture 4: Linking and Consolidating Worksheets

Lecture 5: Introduction to PivotTables and Data Analysis

Lecture 6: Performing Spreadsheet What-If Analysis

Lecture 7: Analyzing Data Using Goal Seeking and Solver

Lecture 8: Analyzing Data with the Analysis ToolPak

Lecture 9: Protecting Your Work

Chapter 5: Understanding Power Pivot and Power Query

Lecture 1: Introducing Power Pivot

Lecture 2: Working Directly with the Internal Data Model

Lecture 3: Adding Formulas to Power Pivot

Lecture 4: Power Query

Chapter 6: Automating Excel

Lecture 1: Introducing Visual Basic for Applications

Lecture 2: Creating Custom Worksheet Functions

Lecture 3: Creating UserForms

Lecture 4: Using UserForm Controls in a Worksheet through an Example

Lecture 5: Working with Excel Events

Lecture 6: Creating Custom Excel Add-Ins

Instructors

LearningWhilePracticing LWP
We aim to teach in a fun and useful way!

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 1 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu