Excel Zero To Hero: Learn Excel Smart Tips For Beginners

Focused View

Peter Alkema

2:44:43

84 View

1. Introduction

1. Introduction.mp4

02:01

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

3.1 Lets+Celebrate+Your+Progress.pdf

3. Lets Celebrate Your Progress In This Course 25% 50% 75% 100%!!.mp4

01:20

2. Excel Smart Tips - Formatting

1.1 Before and After file - Formatting an Excel Worksheet.xlsx

1. Learn How To Format An Excel Worksheet.mp4

07:25

2. Formatting an Excel Worksheet.html

3.1 Advanced Formatting - Excel Guide.pdf

3.2 Before and After file - Advanced Formatting.xlsx

3.3 Before Report - Advanced Formatting PDF .pdf

3. Learn How To Apply Advanced Formatting To An Excel Worksheet.mp4

09:49

4. Advance Formatting.html

5.1 After File - Excel Copy & Paste.xlsx

5.2 Before File - Excel Copy & Paste.xlsx

5.3 Copy & Paste - Excel Guide.pdf

5. Learn To Do Copy & Pasting Smartly.mp4

12:10

6. Copy & Paste.html

7.1 Quarter+Complete+-+Well+Done+Keep+Going.pdf

7. Youve Achieved 25% Lets Celebrate Your Progress And Keep Going To 50% .mp4

00:24

3. Excel Smart Tips - Functions & Formulas

1.1 Basic Formulas - Excel Guide.pdf

1.2 Before and After file - Excel Basic Formulas.xlsx

1. Learn How To Use Basic Formulas In Excel.mp4

10:08

2. Basic Formulas.html

3.1 After file - Exploring New Excel Functions.xlsx

3.2 Before file - Exploring New Excel Functions.xlsx

3. Learn How To Use New Excel Functions.mp4

10:23

4. New Excel Functions.html

5.1 After File - Excel Finance Functions & Formulas.xlsx

5.2 Before File - Excel Finance Functions & Formulas.xlsx

5.3 Finance Functions & Formulas - Excel Guide.pdf

5. Learn Finance Functions And Formulas In Excel.mp4

12:19

6. Excel Finance Functions & Formulas.html

7.1 Rounding Data - Excel Guide.pdf

7.2 Rounding Data.xlsx

7. Learn Rounding Functions In Excel.mp4

11:02

8. Rounding Functions.html

9.1 Half+Complete+-+Well+Done+Keep+Going.pdf

9. Youve Achieved 50% Lets Celebrate Your Progress And Keep Going To 75% .mp4

00:29

10.1 After file - LEFT MID RIGHT functions.xlsx

10.2 Before file - LEFT MID RIGHT functions.xlsx

10.3 LEFT MID RIGHT functions - Excel Guide.pdf

10. Learn To Extract Data Using Excel Text Functions.mp4

09:50

11. LEFT MID RIGHT Function.html

12.1 After file - Change case functions & TRIM function.xlsx

12.2 Before file - Change case functions & TRIM function.xlsx

12.3 Change case & trim - Guide.pdf

12. Change case functions and TRIM function.mp4

05:28

13. Change case functions and TRIM function.html

14.1 After file - Transpose.xlsx

14.2 Before file - Transpose.xlsx

14. Transpose Data.mp4

04:40

15. Transpose Data.html

16.1 After file - XLOOKUP.xlsx

16.2 Before file - XLOOKUP.xlsx

16. XLOOKUP Function.mp4

05:40

4. Excel Smart Tips - Pivot

1.1 Before and After file - Excel Pivot Tables.xlsx

1.2 Pivot Tables - Excel Guide.pdf

1. Learn How To Create Pivot Tables In Excel.mp4

09:34

2. Excel Pivot Tables.html

3.1 After File - Excel Pivot Charts.xlsx

3.2 Before File - Excel Pivot Charts.xlsx

3.3 Pivot Charts - Excel Guide.pdf

3. Learn How To Create Pivot Charts In Excel.mp4

09:54

4. Pivot Charts.html

5.1 3+Quarters+Complete+-+Well+Done+Keep+Going.pdf

5. Youve Achieved 75% Lets Celebrate Your Progress And Keep Going To 100% .mp4

00:31

5. Excel Smart Tips - Tools

1.1 After File - Flash fill.xlsx

1.2 Before File - Flash fill.xlsx

1.3 Flash Fill - Guide.pdf

1. Flash Fill.mp4

05:39

2. Flash Fill.html

3.1 After File - Excel Auditing.xlsx

3.2 Before File - Excel Auditing.xlsx

3. Learn How To Do Excel Auditing.mp4

11:29

4. Excel Auditing.html

5.1 After File - Excel Passwords - Unlocked Calculator.xlsx

5.2 Before File - Excel Passwords.xlsx

5.3 Passwords - Excel Guide.pdf

5. Learn To Create & Break Excel Passwords.mp4

07:53

6. Excel Passwords.html

7.1 After file - Managing Excel External Links.xlsx

7.2 Managing Excel External Links.zip

7.3 Managing External Links - Excel Guide.pdf

7. Learn To Manage Excel External Links.mp4

05:18

8. Managing Excel External Links.html

9.1 After File - Printing.xlsx

9.2 Before File - Printing.xlsx

9.3 Print Output 1.pdf

9.4 Print Output 2.pdf

9.5 Printing - Excel Guide.pdf

9. Learn To Print An Excel Worksheet.mp4

10:13

10. Printing.html

11.1 All+Complete+-+Well+Done.pdf

11. Youve Achieved 100% Lets Celebrate! Remember To Share Your Certificate!!.mp4

01:04

Description

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

Who is this for?

Everyone who wants to learn more about Excel

More details

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!
Who this course is for:
Everyone who wants to learn more about Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Peter Alkema

Instructor's Courses

In my courses you learn practical skills: "I feel like I am in a real classroom." - Kira Minehart "What an amazing course! After finishing this course, I have confidence. Thank so much Dr Peter Alkema". Or Tulongeni Shilunga: "This is exactly the jump-start I needed. Very clear and concise"I also help lead digital transformation at FirstRand, the biggest financial services group in Africa. I've been featured on CNBC Africa and won the Gartner CIO Of The Year in 2016. I founded and led the largest banking hackathon in South Africa which was published in 2019 as a case study by Harvard Business School.I've taught over 17,000 students about business, academics and self-development. In 2020 I completed my PhD at Wits University In Johannesburg. The study introduced a ground-breaking theory of Agile software development teams. My woodworking book was published in 2014 and has sold over 10,000 copies.Olugbenga Gbadegesin: "Excellent delivery" / Lebogang Tswelapele: "This is what I have been longing for" / Paskalia Ndapandula: "Peter speaks with so much clarity" / Amantle Mangwedi: "It was straight to the point and the sections are cut into nice short segments which made it easier to go through" Kathy Bermudez: "Excellent material. Well organized..."Werner van Wyk: "Thank you Peter, once again your lesson and course have given me so much knowledge and understanding" / Yvonne Rudolph "I really look forward to take everything i learned in action" / Josephine Mahlangu: "exactly what I needed to know, absolutely valuable and helpful for my personal growth"

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.

language english
Training sessions 24
duration 2:44:43
Release Date 2023/04/09

Courses related to Excel

Udemy Excel Pivot Tables 2024 by Lemmy Kawonga

2:39:50

05/20/2024

Udemy Microsoft Excel For Beginners (2023)

1:55:08

03/07/2023

Linkedin Learning Excel: Economic Analysis and Data Analytics

2:17:07

01/05/2023