Home : Book details

Microsoft Excel Quick Replay free ebook download

Category:
Video (tutorials, how-to, etc.)

Views: 33
Likes: 41

Catalogue

Author(s):	Udemy

Date:	2021	Format:	MP4	Language:	English	ISBN/ASIN:	0000000000
Pages:		OCR:		Quality:		ISBN13:
Uploader:	oblivion	Upload Date:	12/30/2021 5:13:27 AM

To download click on link in the Links Table below

Description: Click to see full description

What you'll learn:
Filter and sort columns
Block row and column using $
Use conditional formatting
Use if functionmicrosoft-excel-quick-replay
Use text functions like left, right, mid
Creating a basic pivot table, pivot table chart
Creating a basic table (automatically and manually)
Vlookup function
Countif function
Countifs function
Nesting functions - how to connect a several functions in one cell
How to create a basic Macro
Counta functioncourse
Iferror function - using with vlookup function
Requirements
You have to have basic knowledge about Microsoft Excel
My course was prepared on Microsoft Excel 2013
Description
If you want to spend only 30 minutes than several hours to learn or repeat most often used Excel functions, you are in the right place!
In this course I will explain :
- howwww.udemy.com to make basic filter and sort (based on dates, text, amount),
- how to use $ to be able to block row and columns. To know what is the logic and to be able to remember it,
- how to use conditional formatting (greater than, less than, colors etc.),
- how to use IF function, what are the parts of function,
- what are the most often used text functions - LEFT, RIGHT, MID,
- how to create a basic pivot table, pivot table chart, what are their options,
- how to create a basic chart (manually and automatically),
- how to use VLOOKUP function, what are the parts of function,
- how to use COUNTIF function, like counting a cells based on one criteria,
- how to use COUNTIFS function, like counting a cells based on a several criteria,
- how to do nesting functions, connecting a several functions in one cell,
- how to create a basic MACRO, how to turn on Macro option,
- how to use COUNTA function, like counting a cells which have some text, amount, date,
- how to use IFERROR function, example with connecting with VLOOKUP function
Who this course is for
Beginners which want to learn most often used functions
Intermediate and advanced people which want to repeat most often used functions
Homepage
https:

Links Table

	Title	Link	Password	Size (MB)	Thank to	Inform Admin
3067576	Video	https://nitro.download/view/EE5927BAEBCD...		288.40	oblivion

Tags: Excel Microsoft Quick Replay

Title	Link	Password	Size	Reason

Those who downloaded this book also downloaded the following books:
Comments

New comment:

Microsoft Excel Quick Replay free ebook download

Category: Video (tutorials, how-to, etc.)

Description: Click to see full description

Category:
Video (tutorials, how-to, etc.)