Excel Zero To Hero: Learn Excel Smart Tips For Beginners

Master Excel Formulas, Functions, Pivot Tables, Charts, Lookups, Passwords & Finance Functions PLUS Loads Of Quizzes

Created by: Peter Alkema
Business | Technology | Self Development

Created by: Quentin Ballard-Tremeer
Business Ownership | Operations Directorship | BSc Eng Mech

What Will I 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

Target audience

• Everyone who wants to learn more about Excel