Microsoft Excel - Sweet and Short

Focused View

Andre Louw,Ane Taljaard

2:15:36

53 View

1. Excel Essentials

1.1 Double click to open.xlsx

1. Opening a Workbook.mp4

01:14

2.1 Saving workbooks.xlsx

2. Saving a workbook.mp4

01:22

3. Managing the Backstage View.mp4

01:29

4.1 Comma Separated Values.csv

4. Familiarity with file formats.mp4

01:59

5.1 Comprehensive knowledge of the ribbon tabs.xlsx

5. Comprehensive knowledge of the ribbon tabs.mp4

02:13

6.1 Customize the Quick Access Tool Bar.xlsx

6. Customize the Quick Access Tool Bar.mp4

01:55

7.1 Excel Interface Overview.xlsx

7. Excel Interface Overview.mp4

02:03

8.1 Data Entry and Editing Techniques.xlsx

8. Data entry and editing techniques.mp4

01:25

9.1 Data Autofill.xlsx

9. Data Autofill.mp4

01:39

10.1 Working with Dates & Times.xlsx

10. Working with Dates & Times.mp4

02:17

11.1 adding comments2.zip

11. Adding notes and comments.mp4

01:34

12.1 simple formulas (totals and averages).zip

12. Simple Formulas (Totals & Averages).mp4

01:36

13.1 Formatting Rows & Columns - Worksheet.xlsx

13. Formatting Rows & Columns.mp4

01:20

14.1 Inserting pictures and shapes into Excel.xlsx

14.2 your logo.zip

14. Inserting pictures and shapes into Excel.mp4

01:52

15.1 Working with Themes.xlsx

15. Working with Themes.mp4

01:49

16.1 Freeze Panes.xlsx

16. Freeze Panes.mp4

01:37

17.1 Getting your sheet ready for printing.xlsx

17. Getting your sheet ready for printing.mp4

01:39

18.1 Page break preview.xlsx

18. Page break preview.mp4

01:24

19.1 Spell Checker.docx

19.2 Spell Checker.xlsx

19. Spell checker.mp4

01:52

20.1 Clear All Button.xlsx

20. Clear all Button.mp4

01:43

21.1 Find and Replace.xlsx

21. Find and Replace.mp4

02:05

22.1 Merge Cells.xlsx

22. Merge Cells.mp4

01:23

23.1 Microsoft Template.xlsx

23. Microsoft Templates.mp4

01:20

24. Excel Essential Quiz.html

2. Working with tables

1.1 Why use a table.xlsx

1. Why use a table.mp4

01:35

2.1 The components of a table.xlsx

2. The components of a table.mp4

01:43

3.1 Formatting of a table.xlsx

3. Formatting of a Table.mp4

01:38

4.1 Using Autofilter.xlsx

4. Using autofilter.mp4

02:14

5.1 Slicers with Tables.xlsx

5. Slicers with tables.mp4

01:20

6.1 Advanced Sorting.xlsx

6. Advanced Sorting.mp4

02:16

7.1 Calculating totals on a table.xlsx

7. Calculating totals on a table.mp4

01:48

8.1 Referencing within a table.xlsx

8. Referencing within a table.mp4

01:58

9. Working with Tables - Quiz.html

3. Formatting

1.1 What data really looks like.xlsx

1. What data really looks like.mp4

01:37

2.1 Applying formatting to a cell.xlsx

2. Applying formatting to a cell.mp4

01:50

3.1 Text vs Numerical Data.xlsx

3. Text vs Numerical Data.mp4

02:09

4.1 Formatting Dates.xlsx

4. Formatting Dates.mp4

02:11

5.1 Working with Currencies.xlsx

5. Working with Currencies.mp4

02:02

6.1 Formatting Percentages.xlsx

6. Formatting Percentages.mp4

01:19

7.1 Format Painter.xlsx

7. Format Painter.mp4

01:45

8.1 Conditional Formatting with a formula.xlsx

8. Conditional Formatting with a formula.mp4

02:16

9.1 Insert a screenshot - destination.xlsx

9.2 Insert a screenshot.xlsx

9. Insert a screenshot.mp4

01:33

10.1 Insert a shape of any type.xlsx

10. Insert a shape of any type.mp4

01:25

11.1 SmartArt.xlsx

11. Advanced Manipulation of SmartArt.mp4

01:26

12.1 Insert Symbols and Equations.xlsx

12. Insert symbols and equations.mp4

01:17

13.1 Formatting a graphic object.xlsx

13. Formatting a graphic object.mp4

01:41

14.1 Change the shape of a graphic object.xlsx

14. Change the shape of a graphic object.mp4

01:31

15.1 Selection pane.xlsx

15. Selection pane.mp4

01:30

16.1 Object Arrangement.xlsx

16. Object Arrangement.mp4

01:32

17.1 Perform multi-criteria sorts.xlsx

17. Perform multi-criteria sorts and customized sorts.mp4

01:55

18.1 Inputting in multiple cells.xlsx

18. Inputting in multiple cells.mp4

01:39

19.1 Advanced knowledge of custom lists.xlsx

19. Advanced knowledge of custom lists.mp4

01:13

20.1 Advanced knowledge of Hypertext links.xlsx

20.2 How to link an external document into your excel sheet.pdf

20.3 Word document.docx

20. Advanced knowledge of Hypertext links.mp4

01:38

21.1 create and edit a form.zip

21. Create and edit a form - Part 1.mp4

01:44

22.1 create and edit a form.zip

22. Create and edit a form - Part 2.mp4

01:30

23. Formatting Quiz.html

4. Core Functions

1.1 Equals and Targeting cells.xlsx

1. Equals and Targeting cells.mp4

01:56

2.1 Functions vs Formulas.xlsx

2. Functions vs Formulas.mp4

02:08

3.1 Adding, subtracting, Multiplication and Division.xlsx

3. Adding, subtracting, multiplication and division.mp4

01:49

4.1 Components of a Function.xlsx

4. Components of a Function.mp4

01:50

5.1 Sum and Average Function.xlsx

5. Sum and Average Function.mp4

02:00

6.1 More than one function in a cell.xlsx

6. More than one function in a cell.mp4

01:12

7.1 Absolute references.xlsx

7. Absolute References ($ signs).mp4

02:04

8.1 Look for and help with Functions.xlsx

8. Look for - Help with Functions.mp4

01:30

9.1 COUNT Function.xlsx

9. COUNT Function.mp4

01:30

10.1 ROUND, ROUNDUP and ROUNDDOWN Functions.xlsx

10. ROUND, ROUNDUP and ROUNDDOWN Functions.mp4

02:27

11.1 LEFT and RIGHT Functions.xlsx

11. LEFT and RIGHT functions.mp4

01:37

12.1 MID Function.xlsx

12. MID function.mp4

01:43

13.1 Errors in Functions.xlsx

13. Errors in Functions.mp4

02:01

14.1 Concatenate Function.xlsx

14. CONCATENATE Function.mp4

02:03

15.1 UPPER, LOWER and PROPER Functions.xlsx

15. UPPER, LOWER and PROPER Functions.mp4

01:12

16. Core Functions - Quiz.html

5. VLOOKUPS

1.1 What you can do with a VLOOKUP.xlsx

1. What you can do with a VLOOKUP.mp4

02:30

2.1 The correct dataset structure.xlsx

2. The correct dataset structure.mp4

01:50

3.1 Doing a VLOOKUP.xlsx

3. Doing a VLOOKUP.mp4

01:51

4.1 Common problems with a VLOOKUP.xlsx

4. Common problems with VLOOKUP.mp4

02:04

5.1 Exact or Approximate match.xlsx

5. Exact or Approximate match.mp4

02:46

6.1 Comparing two sheets with a VLOOKUP.xlsx

6. Comparing two sheets with a VLOOKUP.mp4

01:30

7.1 Matching on more than one criteria.xlsx

7. Matching on more than one criteria.mp4

02:28

8.1 HLOOKUP Function.xlsx

8. HLOOKUP function.mp4

01:29

9.1 Error handling - IFERROR function.xlsx

9. Error Handling - IFERROR function.mp4

02:01

10. VLOOKUP - Quiz.html

Description

Excel Mastery Made Simple: Unleashing Efficiency in Every Cell

What You'll Learn?

Learn basic fundamentals of Excel
Work with Tables and Graphs
Learn about VLOOKUPS, Pivot Tables and many more
Learn core functions

Who is this for?

Beginners to advanced wanting to touch up on their excel skills

What You Need to Know?

No experience needed. You will learn everything from Beginner to advanced. You will need Microsoft Excel for this course.

More details

Description
Introducing the Sweet and Short All-in-one Excel Course, a comprehensive learning experience designed to make you an Excel expert in no time. This course is perfect for anyone looking to master the essential features and functions of Microsoft Excel. Whether you are a beginner seeking to acquire foundational skills or a seasoned Excel user aiming to enhance your proficiency, this course is the perfect solution.

In just a short span of time, this course covers all the essential aspects of Microsoft Excel, providing you with a solid foundation and equipping you with advanced techniques. This curriculum is designed to be accessible and engaging, allowing you to grasp complex concepts effortlessly.

The course takes a hands-on approach to learning. Each lesson is thoughtfully structures, with step-by-step instructions and practical exercises that reinforce your understanding. You'll learn how to navigate spreadsheets efficiently format data professionally, and create powerful formulas and functions to automate calculations.

Additionally, our course stays up-to-date with the latest Excel advancements, ensuring that you are equipped with the most relevant skills and techniques. We understand that time is of the essence, so we have carefully curated the content to provide maximum value in the shortest amount of time possible.
You'll discover time-saving shortcuts, tips and tricks that will help you work faster in excel.
Buy now! This course is yours for a lifetime!
Who this course is for:
Beginners to advanced wanting to touch up on their excel skills

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Andre Louw

Instructor's Courses

I am a self-taught Microsoft Excel expert with over 17 years of experience. I started my career in 2005 building tools, trackers, and models in a corporate environment. In 2014, I founded my own freelance agency, where I provide Excel consulting and training services to clients in a variety of industries. I am also a web developer and have built custom tools for clients using a variety of technologies.I am passionate about empowering people through training and education. I love breaking down complex problems into manageable pieces and helping people see the solutions. I am also a strong advocate for lifelong learning and am always looking for new ways to improve my skills and knowledge.

Ane Taljaard

Instructor's Courses

I am Ané, a dedicated educator, graphic designer, and passionate advocate for the transformative power of Microsoft Excel. Beyond my commitment to teaching, I possess a deep expertise in harnessing the capabilities of Excel to empower individuals with invaluable data analysis and visualization skills. With an unwavering passion for both education and Excel, I strive to ignite curiosity and cultivate a love for learning in my students. Through engaging teaching methods, visually captivating designs, and a focus on the practical applications of Excel, I aim to leave a lasting impact on learners, equipping them with the tools to thrive in a rapidly evolving world driven by data-driven decision-making.

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.