• views: 134
• date: 20 August 2022
• posted by: voska89

What you'll learn
Introduction of MS Excel
Text Functions and Numerical functions
Formatting types in Excel
Inserting Images,Shapes, Charts and lot more things.
Sorting and filtering of data
IF Functions
Pivot Tables and Charts
Conditional and lookup functions
IF Function
IF Or Function Count if
VLOOKUP
HLOOKUP
INDEX FUNCTION
MATCH FUNCTION
Precedent and dependent
Watch Window
Pivot charts
Excel Power pivot
Key Performance Indicator (KPI)
Requirements
Basic computing knowledge
Description
Excel is the most powerful tool to manage and analyze various types of Data. This perfectly designed Excel course will begin with an introduction to Excel and will take you through various features of Excel. If you're an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. Grow your career as a Data Analyst through knowing Data Analysis in Excel. Everything that is very important to know like Functions and Formulas, Data Validation, Pivot Table, Power Pivot, VLookup, HLookup, KPI and many more things are discussed in details in this course. This course will help you to make yourself one step ahead of everyone. All the resources are given that will help you to practice.
This course is designed perfectly, from introduction to advanced will be covered through various features of excel. You will get familiarized with Cell Refencing, Table formation, Customizing Cell Style, Border, Formula and Functions, Conditional Statements, Data Sorting, Filtering, Validation.
You will get notion of use Descriptive Statistics through the use of Average, Median, Count, Max, Min functions. An in-depth knowledge of using Chart and Graphs to analyse data, and presenting data through pivot table using of power pivot and KPI.
Who this course is for
Aspiring Excel Data Analyst


Homepage

https://www.udemy.com/course/complete-hands-on-advanced-excel/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.