# 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

0/5

## Excel Zero To Hero Learn Excel Smart Tips For Beginners

### 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

### Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Introduce Yourself To Your Fellow Students And Tell Us What You Want To Learn

Lecture 3 Let’s Celebrate Your Progress In This Course: 25% > 50% > 75% > 100%!!

Section 2: Excel Smart Tips – Formatting

Lecture 4 Learn How To Format An Excel Worksheet

Lecture 5 Learn How To Apply Advanced Formatting To An Excel Worksheet

Lecture 6 Learn To Do Copy & Pasting Smartly

Lecture 7 You’ve Achieved 25% >> Let’s Celebrate Your Progress And Keep Going To 50% >>

Section 3: Excel Smart Tips – Functions & Formulas

Lecture 8 Learn How To Use Basic Formulas In Excel

Lecture 9 Learn How To Use New Excel Functions

Lecture 10 Learn Finance Functions And Formulas In Excel

Lecture 11 Learn Rounding Functions In Excel

Lecture 12 You’ve Achieved 50% >> Let’s Celebrate Your Progress And Keep Going To 75% >>

Lecture 13 Learn To Extract Data Using Excel Text Functions

Lecture 14 Change case functions and TRIM function

Lecture 15 Transpose Data

Lecture 16 XLOOKUP Function

Section 4: Excel Smart Tips – Pivot

Lecture 17 Learn How To Create Pivot Tables In Excel

Lecture 18 Learn How To Create Pivot Charts In Excel

Lecture 19 You’ve Achieved 75% >> Let’s Celebrate Your Progress And Keep Going To 100% >>

Section 5: Excel Smart Tips – Tools

Lecture 20 Flash Fill

Lecture 21 Learn How To Do Excel Auditing

Lecture 22 Learn To Create & Break Excel Passwords

Lecture 23 Learn To Manage Excel External Links

Lecture 24 Learn To Print An Excel Worksheet

Lecture 25 You’ve Achieved 100% >> Let’s Celebrate! Remember To Share Your Certificate!!