• Post category:Udemy (Jan 2022)
  • Reading time:4 mins read


What you will learn

How to work on an Excel Worksheet?

What are the different ways to format data in Excel?

How to customize the Excel Worksheets?

What are the different formulas and shortcuts in Excel to make the calculation easier?

How to insert tables, charts, and images in Excel for presentation purposes?

How to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel?

How to use the Data validation function of Excel?

How to make reports using Excel?

How to use Pivot tables and charts in Excel?

What is the importance of advanced filters of Excel?

How to do Advanced Sorting?

How to Import data in Excel?

How To Use Sparklines?

If Function And Its Usage

Vlookup And Hlookup Function

Index Match

Data Validation And Indirect Function

Report Making In Excel

Excel – Offset Function

Usage Of Pivot Table

Creating Dashboard Using Pivot Table

Advanced Filters

Advance Sorting

Importing Data From Csv

What If Analysis Function

Query Editor In Excel

Creation Of Macros

Creating & Navigating Through A Worksheet

How To Format Data In Excel Worksheet?

How To Customize And View A Worksheet?

Configure Worksheets To Save & Print .

How To Insert And Format Data In Excel Worksheet?

Conditional Formatting & Group Cells & Ranges

Different Formulas & Functions In Excel

Averageif & Countif Functions In Excel

How To Create & Format Charts In Excel Worksheet?

Images And Smartart In Excel

Description

This course explains the advanced features of Microsoft Excel. The course discusses how to use different tools and functions of Excel to increase the productivity and efficiency of business processes and create dashboards for better understanding. The course will help you to:

  • Learn how to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel

  • Learn how to use the Data validation function of Excel

  • Learn how to make reports using Excel

  • Learn how to use Pivot tables and charts in Excel

  • Importance of Advanced filters of Excel

  • Learn how to do Advanced Sorting

  • Learn how to Import data in Excel

  • Learn how to work on an Excel Worksheet

  • Ways to format data in Excel

  • Learn how to customize Excel Worksheets

  • Different formulas and short cuts in Excel to make calculation easier

  • Learn how to insert tables, charts, and images in Excel for presentation purposes

Key Learnings of the Course

  • How to work on an Excel Worksheet?

  • What are the different ways to format data in Excel?

  • How to customize the Excel Worksheets?

  • What are the different formulas and shortcuts in Excel to make the calculation easier?

  • How to insert tables, charts, and images in Excel for presentation purposes?

  • How to use What-if, LOOKUP, INDEX, and various other Advance functions of Excel?

  • How to use the Data validation function of Excel?

  • How to make reports using Excel?

  • How to use Pivot tables and charts in Excel?

  • What is the importance of advanced filters of Excel?

  • How to do Advanced Sorting?

  • How to Import data in Excel?

Course Benefits & Outcomes


Subscribe to latest coupons on our Telegram channel.

  • Understand how to work on an Excel Worksheet

  • Know the ways to format data in Excel

  • Learn how to customize Excel Worksheets

  • Different formulas and short cuts in Excel to make calculation easier Learn how to insert tables, charts, and images in Excel for presentation purposes

  • Learn the What-if, LOOKUP, INDEX, and various other Advance functions of Excel

  • Use the Data validation function of Excel

  • Make reports using Excel

  • Use Pivot tables and charts in Excel

  • Importance of Advanced filters of Excel

  • Learn the Advanced Sorting

  • Import data in Excel

मराठी
language

Content

Introduction

Introduction Learning Excel
Creating & Navigating Through A Worksheet
How To Format Data In Excel Worksheet?
How To Customize And View A Worksheet?
Configure Worksheets To Save & Print .
How To Insert And Format Data In Excel Worksheet?
Conditional Formatting & Group Cells & Ranges
Creating
Different Formulas & Functions In Excel
Averageif & Countif Functions In Excel
How To Create & Format Charts In Excel Worksheet?
Images And Smartart In Excel
Learning Excel Summary
Advance Excel Introduction
How To Use Sparklines?
If Function And Its Usage
Vlookup And Hlookup Function
Index Match
Data Validation And Indirect Function
Report Making In Excel
Excel – Offset Function
Usage Of Pivot Table
Creating Dashboard Using Pivot Table
Advanced Filters
Advance Sorting
Importing Data From Csv
What If Analysis Function
Query Editor In Excel
Creation Of Macros
Summary

Enroll for Free


💠 Follow this Video to Get Free Courses on Every Udemy Topics! 💠