Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions

Master Excel Charts, Pivot table, Maps. Learn Functions such as SUMIF, SUMIFS, IFS, SWITCH, TEXT, Date/Time functions
4.63 (4 reviews)
Udemy
platform
English
language
Microsoft
category
Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions
14
students
28.5 hours
content
Sep 2024
last update
$19.99
regular price

What you will learn

Understand the basics of Excel and how to manipulate the workbook tabs, ribbons and tools

Creating and designing different types of charts - Histogram, Pareto, Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more

Get a good grip on how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, ,LCM, SIN, COS, TAN, etc

Master how to work with Logical Functions - IF, IFERROR, IFS, SWITCH, NOT, OR, AND, etc

Enjoy how to work with Text Functions - LET, CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc

Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, etc

Master the skill of tracing dependents and precedents of data

Create 3D Map with Time Line

Related Topics
4806020
udemy ID
7/29/2022
course created date
10/19/2022
course indexed date
Bot
course submited by