Microsoft Excel- Complete Master Program in MS Excel

Microsoft Excel- Complete Master Program in MS Excel, available at $49.99, has an average rating of 4, with 209 lectures, based on 271 reviews, and has 17605 subscribers.

You will learn about ******At End of this course you are become a master in Excel***** *****You will become a Master in Excel Basics***** At end of the course you are become a Master in Pivot Tables, Data visualization with charts, dynamic Arrays, core formulas, excel shortcuts *****Build a solid understanding of ESSENTIAL Microsoft Excel functions***** Solve complicated Excel problems WITHIN MINUTES *****Conduct effective analytics – THOUSANDS OF TIMES FASTER***** ****Impress your boss, colleagues, partners by being THE BEST at Excel in the office**** Harness full potential of Excel by creating Pivot tables with slicers This course is ideal for individuals who are Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel or Anyone who uses Excel to work with data and would like to be more effective It is particularly useful for Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel or Anyone who uses Excel to work with data and would like to be more effective.

Enroll now: Microsoft Excel- Complete Master Program in MS Excel

Summary

Title: Microsoft Excel- Complete Master Program in MS Excel

Price: $49.99

Average Rating: 4

Number of Lectures: 209

Number of Published Lectures: 203

Number of Curriculum Items: 209

Number of Published Curriculum Objects: 203

Original Price: ₹1,999

Quality Status: approved

Status: Live

What You Will Learn

******At End of this course you are become a master in Excel*****
*****You will become a Master in Excel Basics*****
At end of the course you are become a Master in Pivot Tables, Data visualization with charts, dynamic Arrays, core formulas, excel shortcuts
*****Build a solid understanding of ESSENTIAL Microsoft Excel functions*****
Solve complicated Excel problems WITHIN MINUTES
*****Conduct effective analytics – THOUSANDS OF TIMES FASTER*****
****Impress your boss, colleagues, partners by being THE BEST at Excel in the office****
Harness full potential of Excel by creating Pivot tables with slicers

Who Should Attend

Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel
Anyone who uses Excel to work with data and would like to be more effective

Target Audiences

Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel
Anyone who uses Excel to work with data and would like to be more effective

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Microsoft Excel- Complete Master Program in MS Excel [2021] will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy Expert you can build on.

What you’ll learn

An accelerated, step-by-step program to give you a strong foundation to Expert Level Skills

Core Excel

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Core Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy foundation you can build on.

Core Excel Formulas and Functions

Formulas are the key to getting work done in Excel. In this accelerated video course, you’ll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You’ll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas and Functions today.

Core Pivot

If you use Excel, but don’t know how to use Pivot Tables, you’re missing out…wasting time trying to do things that a Pivot Table can do for you automatically. With a small investment, Pivot Tables will pay you back again and again.

Core Charts

A picture is worth a thousand words. Nothing beats an effective chart for presenting data in a way people can instantly understand. Excel has a powerful and deep charting engine built right in, so you already have the tools you need to create a wide range of charts and visualizations. This course will untangle and demystify Excel’s powerful charting tools, so you can create effective charts quickly and painlessly.

Excel Shortcuts

Shortcuts turbocharge your productivity in Excel: they help you work faster & more accurately, they let you focus on your work (not Excel’s interface), and they unlock Excel’s most powerful features. But shortcuts require practice to master. This video course covers over 200 Excel shortcuts, and includes a full set of practice worksheets. Start using more Excel shortcuts today!

Excel Tables

Excel Tables offer an easy way to create dynamic ranges that adjust when data changes. This makes tables perfect for pivot tables, charts, and dashboards that need to show the latest data. This course covers the key benefits of tables, including a detailed review of structured references, the special formula language for tables. Examples include VLOOKUP, INDEX and MATCH, and SUMIFS. The course also covers, table styles, slicers, filtering, sorting, and removing duplicates.

Conditional Formatting

One of the hottest trends today is data visualization. Why? Because when data is presented visually, people understand it immediately. This course will show you how to use Excel’s conditional formatting to communicate key insights with clarity and impact. This is an accelerated program that takes you step-by-step through the capabilities of this powerful tool.

Happy Learning!

Course Curriculum

Chapter 1: Introduction

Lecture 1: How i Design this course

Chapter 2: Practice Files Download

Lecture 1: How to Download Practice Files

Chapter 3: A Tour of Excel

Lecture 1: A Tour of Excel Interface

Lecture 2: A tour of Excel Ribbon

Lecture 3: A tour of File Tab

Chapter 4: Microsoft Excel Basics >>>>> (Module-I) <<<<<

Lecture 1: Excel – Overview

Lecture 2: Open and Close Excel Appilication

Lecture 3: Excel Start Screen

Lecture 4: Window controls to Maximize, Minimize and Restore Excel Window

Lecture 5: Resize and Move Excel Window

Lecture 6: Components of excel workbook user interface

Lecture 7: Customize Excel Ribbon

Lecture 8: Quick Access Tool Bar in Excel

Lecture 9: Row, Column and Cells in Excel Worksheets

Lecture 10: Change Row Height in Excel

Lecture 11: AutoFit Row Height

Lecture 12: Change Column Width in Excel

Lecture 13: Hide and unhide Rows and Columns in Excel

Lecture 14: Insert Rows and Columns in Excel

Lecture 15: Insert and Delete cells in Excel

Lecture 16: Cell Modes in Excel

Lecture 17: Delete Rows and Columns in Excel

Lecture 18: Range and Types of Ranges in Excel

Lecture 19: Free panes Rows and Columns in Excel

Chapter 5: Building a Workbook

Lecture 1: Create a New Workbook

Lecture 2: Save Workbook

Lecture 3: Save Workbook in different format

Lecture 4: Navigate workbook in Excel

Lecture 5: Find and Open Recent Workbooks

Lecture 6: Insert and Delete Worksheets

Lecture 7: Name and Format Worksheet Tabs

Lecture 8: Move and Copy Worksheets

Lecture 9: Move and Copy Worksheets to another Workbook

Lecture 10: Hide and Unhide Worksheets

Chapter 6: Entering Data in Excel

Lecture 1: Enter Data in Excel

Lecture 2: Delete Data in Excel

Lecture 3: Edit Data in Excel

Lecture 4: Enter Dates in Excel

Lecture 5: Use the fill handle to enter data in Excel

Lecture 6: enter custom patterns with the fill handle in Excel

Lecture 7: Move data in Excel

Lecture 8: Duplicate Data in Excel

Lecture 9: Use drag and drop in Excel

Chapter 7: Find and Replace in Excel

Lecture 1: find a value in Excel

Lecture 2: find a formatted value in Excel

Lecture 3: find all matches at once in Excel

Lecture 4: find and replace a value

Lecture 5: find and replace formatted values in Excel

Chapter 8: Font Formatting in Excel

Lecture 1: Format Font and Font Size

Lecture 2: Bold, italic and underlining styles

Lecture 3: Change font colour

Lecture 4: Different Underlining options in Excel

Lecture 5: apply subscript, superscript, and strikethrough formatting in Excel

Lecture 6: insert symbols and special characters in Excel

Lecture 7: format individual characters in Excel

Chapter 9: Borders and fills

Lecture 1: apply a border to cells in Excel

Lecture 2: apply a fill to cells in Excel

Lecture 3: draw borders and border grids in Excel

Lecture 4: apply a border using ribbon presets in Excel

Lecture 5: remove existing borders and fills in Excel

Chapter 10: Conditional Formatting in Excel >>>>> (Module -II) <<<<<

Lecture 1: What is Conditional Formatting

Lecture 2: Create Conditional formatting Rule

Lecture 3: Edit Conditional formatting Rule

Lecture 4: Add Additional conditional formatting Rule

Lecture 5: Delete Conditional formatting Rule

Chapter 11: Built in Conditional Format Rules

Lecture 1: Highlight Top and Bottom Values

Lecture 2: highlight above and below average values

Lecture 3: use data bars with conditional formatting

Lecture 4: use color scales with conditional formatting

Lecture 5: use Icon sets with conditional formatting

Lecture 6: highlight text values with conditional formatting

Lecture 7: show duplicate values with conditional formatting

Chapter 12: Conditional formatting with formulas

Lecture 1: apply conditional formatting with a formula

Lecture 2: Conditional formatting based on a different cell

Lecture 3: Conditional formatting with one variable input

Lecture 4: Conditional formatting with two variable inputs

Lecture 5: highlight rows with conditional formatting

Lecture 6: highlight rows using multiple criteria

Lecture 7: add a conditional formatting key

Lecture 8: check line length with conditional formatting

Lecture 9: build a search box with conditional formatting

Lecture 10: create zebra stripes with conditional formatting

Lecture 11: compare two lists and highlight differences

Chapter 13: Core Formulas and Functions ->>>>> (Module III) <<<<<

Lecture 1: What is a Formula and function?

Lecture 2: Formula vs Function

Lecture 3: How to edit formula

Lecture 4: How to use operators in formulas

Instructors

Rajesh Reddy
40k+ Students

Rating Distribution

1 stars: 6 votes
2 stars: 7 votes
3 stars: 42 votes
4 stars: 97 votes
5 stars: 119 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