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
Description
If you’re looking to become an Excel pro and level up your skills, you’ve come to the right place. In this comprehensive course, you will learn everything from the basics of formatting and formulas to advanced techniques such as creating pivot tables and charts, working with text functions, and auditing your spreadsheets. Whether you’re a beginner or looking to brush up on your skills, this course is designed to take you from a basic level to an advanced level of proficiency in Excel.We will start with the basics of formatting, including how to format fonts, numbers, cells, freeze rows and columns, and use the Text-to-Columns feature effectively. Then, we will dive into essential Excel functions such as SUM, SUMPRODUCT, CONCATENATE, VLOOKUP, HLOOKUP, COUNT, COUNTA, COUNTIF, SUMIF, AVERAGE, MAX, MIN, and many more. You will learn how to create pivot tables and charts, and use the latest text functions such as TEXTBEFORE, TEXTAFTER, TEXTSPLIT, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, CHOOSECOLS, CHOOSEROWS, TAKE, DROP.Moving on, you will learn about Excel finance functions such as NPV, XNPV, IRR, XIRR, MIRR, RATE, NPER, PV, PMT, IPMT, FV, FVSCHEDULE, and EFFECT. Additionally, you will learn how to protect and unprotect sheets and break the password if you forget it. You will also explore amazing copy and paste options such as paste math operations, paste column widths, paste visible cells, and paste comments. You will learn how to manage external links, print an Excel workbook, and round numbers using functions such as ROUND, ROUNDDOWN, ROUNDUP, TRUNC, INT, MROUND, CEILING, FLOOR, EVEN, ODD.We will then cover functions to extract data from cells, including LEFT, MID, RIGHT, and the game-changing Flash Fill. You will learn how to switch rows and columns using the TRANSPOSE function, and how to use XLOOKUP effectively. Additionally, you will learn how to change the case of text and remove unnecessary spaces.By the end of this course, you will have a comprehensive understanding of Excel, and be able to confidently use it to analyze data, create reports, and make informed decisions. You will have the skills to take your career to the next level, and stand out as an Excel expert.So, what are you waiting for? Sign up for this Excel online course today and start your journey to becoming an Excel pro!
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!!
Everyone who wants to learn more about Excel
Course Information:
Udemy | English | 2h 45m | 1.47 GB
Created by: Peter Alkema
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com