Excel Zero To Hero: Learn Excel Smart Tips For Beginners
https://DevCourseWeb.com
Published 2/2023
Created by Peter Alkema
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 25 Lectures ( 2h 44m ) | Size: 1.46 GB
Master Excel Formulas, Functions, Pivot Tables, Charts, Lookups, Passwords & Finance Functions PLUS Loads Of Quizzes
What you'll learn
Formatting for fonts/ numbers/ cells, freezing rows & columns, Use Text-to-Columns feature effectively, essential Excel shortcuts
Essential Excel functions such as SUM, SUMPRODUCT, CONCATENATE, VLOOKUP, HLOOKUP, COUNT, COUNTA, COUNTIF, SUMIF, AVERAGE, MAX, MIN
Latest Excel text functions such as TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSECOLS, CHOOSEROWS, TAKE, DROP
Excel Finance Functions such as NPV, XNPV, IRR, XIRR, MIRR, RATE, NPER, PV, PMT, IPMT, FV, FVSCHEDULE, EFFECT
Protect and unprotect Excel sheets and break the password when you forget the password
Explore amazing copy & paste options such as Paste math operations, Paste column widths, Paste visible cells, Paste comments
Switch rows and columns - TRANSPOSE function, copy & paste using transpose, #SPILL! error
Rounding functions such as ROUND, ROUNDDOWN, ROUNDUP, TRUNC, INT, MROUND, CEILING, FLOOR, EVEN, ODD
How to use XLOOKUP and how to effectively use the XLOOKUP arguments
Managing external links, printing an Excel workbook
Flash Fill to quickly merge and extract data
Pivot Tables and Pivot Charts
Change case and remove unnecessary spaces
LEFT MID RIGHT functions to extract data from cells
Requirements
There are no requirements or pre-requisites