Microsoft Excel For Professionals (Zero to Advanced Course)

Microsoft Excel For Professionals (Zero to Advanced Course), available at $59.99, has an average rating of 4, with 66 lectures, 3 quizzes, based on 45 reviews, and has 225 subscribers.

You will learn about Master Microsoft excel from scratch and build strong understanding on the basics of Microsoft excel by watching short screen cast made by keeping in mind the attention span of average learner. Learn how to deal with large data sets, and write powerful and dynamic (Appropriate) excel formulas from scratch. Learn the tools and techniques for data analysis such as sorting and filtering the data, Data validation, Conditional formatting, Data Consolidation and many more. Learn how create dynamic reports by mastering one of the most popular tools pivot table and slicer, also learn to prepare charts and graphs professionally Increase your efficiency by learning some Ninja tips and Shortcuts Revolutionize your workflow with excel This course is ideal for individuals who are Beginner and the professionals who are curious about to learn the advanced tools in excel so as to increase their efficiency at work, It is particularly useful for Beginner and the professionals who are curious about to learn the advanced tools in excel so as to increase their efficiency at work,.

Enroll now: Microsoft Excel For Professionals (Zero to Advanced Course)

Summary

Title: Microsoft Excel For Professionals (Zero to Advanced Course)

Price: $59.99

Average Rating: 4

Number of Lectures: 66

Number of Quizzes: 3

Number of Published Lectures: 66

Number of Published Quizzes: 3

Number of Curriculum Items: 69

Number of Published Curriculum Objects: 69

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Master Microsoft excel from scratch and build strong understanding on the basics of Microsoft excel by watching short screen cast made by keeping in mind the attention span of average learner.

Learn how to deal with large data sets, and write powerful and dynamic (Appropriate) excel formulas from scratch.

Learn the tools and techniques for data analysis such as sorting and filtering the data, Data validation, Conditional formatting, Data Consolidation and many more.

Learn how create dynamic reports by mastering one of the most popular tools pivot table and slicer, also learn to prepare charts and graphs professionally

Increase your efficiency by learning some Ninja tips and Shortcuts

Revolutionize your workflow with excel

Who Should Attend

Beginner and the professionals who are curious about to learn the advanced tools in excel so as to increase their efficiency at work,

Target Audiences

Beginner and the professionals who are curious about to learn the advanced tools in excel so as to increase their efficiency at work,

It’s time to jump into Excel, whether you are starting from zero or want to become an absolute excel master, you have come to the right place at right time.

This course will take you from the basics to the advanced stages of excel. Where you will explore the beauty of excel.

While most of the excel course focuses on dictating the use of formulas, I teach through hands-on relevant examples designed to showcase why these formulas are great and how they can be used in different ways.

Here you do not need to remember any function and formula syntax, after doing this course eventually you will think like Excel. Because every video is made by keeping in mind the attention span of the average learner, and also by using screencast software these videos are made very easy to understand the topic explained in the video.

By the end of this course, you will be able to

Easily identify and use dynamic tools and excel dashboards to filter, display and analyze your data.

Design your own conditional formatting rules.

Pick up and connect the datasets from multiple sources with excels V-H Lookup, Offset, Index, and Match functions.

Use date function and logical functions.

Create pivot table

Create slicer

Apply data validation

Create charts suits to your dataset analysis.

Course Curriculum

Chapter 1: Introduction To Excel

Lecture 1: Introduction to Excel

Lecture 2: Navigating and Selecting

Lecture 3: View Options

Lecture 4: Data Entry, Data Types

Lecture 5: Fill Handle

Lecture 6: Copy, Cut and Paste

Lecture 7: Formulas In Context

Chapter 2: Performing Calculations

Lecture 1: Formulas

Lecture 2: Sum and Autosum

Lecture 3: Average, Max and Min

Lecture 4: Absolute Cell Referencing-I

Lecture 5: Absolute Cell Referencing-II

Lecture 6: Calculations Across Sheets

Chapter 3: Formatting

Lecture 1: Font Formatting

Lecture 2: Applying Borders

Lecture 3: Alignment Tools

Lecture 4: Format Painter

Lecture 5: Number Formats

Lecture 6: Styles and Themes

Chapter 4: Working With Data

Lecture 1: Managing Rows and Columns

Lecture 2: Find and Replace

Lecture 3: Filtering

Lecture 4: Sorting-Single and Multiple Columns

Lecture 5: Conditional Formatting

Chapter 5: Printing Spreadsheets

Lecture 1: Print Preview

Lecture 2: Margins and Scale

Lecture 3: Page Breaks

Lecture 4: Print Titles

Lecture 5: Headers and Footers

Chapter 6: Multiple Worksheets and Workbooks

Lecture 1: Multiple Worksheets

Lecture 2: 3D Formulas

Lecture 3: Linking Workbooks

Lecture 4: Consolidate By Position

Lecture 5: Consolidate By Reference

Chapter 7: Text and Date Functions

Lecture 1: Combining Text ( CONCATE, CONCATENATE )

Lecture 2: Changing Text Case ( UPPER, LOWER, PROPER )

Lecture 3: Extracting Text ( LEFT, MID, RIGHT )

Lecture 4: Finding Text ( FIND )

Lecture 5: Date Calculations ( NOW, TODAY, YEARFRAC )

Chapter 8: Named Ranges

Lecture 1: Introduction to Named Ranges

Lecture 2: Creating Named Ranges

Lecture 3: Managing Named Ranges

Lecture 4: Named Ranges in Formulas

Lecture 5: Managing Named Ranges

Lecture 6: Count Functions

Chapter 9: Summarizing Data

Lecture 1: Count With Criteria (COUNTIFS)

Lecture 2: Adding With Criteria (SUMIFS)

Chapter 10: Tables

Lecture 1: Creating and Formatting Tables

Lecture 2: Working With Tables

Lecture 3: Sorting and Filtering

Lecture 4: Automation With Tables

Lecture 5: Converting to Range and Subtotaling

Chapter 11: Pivot Tables, Charts and Slicers

Lecture 1: Creating and Modifying Pivot Tables

Lecture 2: Value Field Settings

Lecture 3: Sorting and Filtering A Pivot Table

Lecture 4: Report Filter Pages

Lecture 5: Pivoting Charts

Chapter 12: Data Validation and Conditional Formatting

Lecture 1: Data Validation

Lecture 2: Creating Drop-Down Lists

Lecture 3: Pivoting Slicers

Lecture 4: Using Formulas in Data Validation

Lecture 5: Working With Data Validation

Lecture 6: Advanced Conditional Formatting

Chapter 13: Conditional Logic

Lecture 1: Logical Functions I: IF

Lecture 2: Logical Functions II: AND, OR

Lecture 3: Combining Logical Functions I: IF, AND, OR

Instructors

Sonawane Manoj Sayaji
Mechanical Engineer

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 4 votes

4 stars: 14 votes

5 stars: 26 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!