The Ultimate Microsoft Excel Essentials Training Course + Tips & Tricks to Boost Productivity - NEW | Lorenz De Smedt | Skillshare

The Ultimate Microsoft Excel Essentials Training Course + Tips & Tricks to Boost Productivity - NEW

Lorenz De Smedt, IT Professional (Certified)

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
25 Videos (2h 12m)
• Introduction

3:32
• Getting Started with Excel: Tabs and Sheets

7:00
• Getting Started with Excel: Navigation and shortcut keys

4:59
• Using Formulas in Excel: Formula Evaluation

3:47
• Math & Statistical Formulas: Count(if)(s)

2:51
• Math & Statistical Formulas: Sum(if)(s) and Average

4:34
• Cell Reference Formulas: Vlookup, Hlookup, Match and Index

6:44
• Date and Time Formulas: Today, Days, Networkdays

3:50
• Logical Formulas: If, And, Not and Iferror

6:50
• Text Formulas: Trim, Concatenate, Left, Mid, Right

5:18
• Fill Series, Absolute and Relative cell references

4:50
• Insert, Delete and Hide cells, rows or columns

6:26
• Number and Cell Formatting

6:00
• Conditional Formatting

7:40
• Format As Table

3:42
• Copy and Paste Options in Excel

3:57
• How To Create a Chart in Excel

9:32
• Choosing the right Chart Type

7:39
• Sparklines

3:06
• Sort

3:51
• Filter

3:55

5:49
• Data Validation and Remove Duplicate Values

6:28
• Pivot Tables

5:39
• Pivot Charts

4:11

Learn the Essentials of Microsoft Excel. A step-by-step guide for beginners with Shortcuts, Formulas, Tips & Tricks.

Learn the essentials of Microsoft Excel through this step-by-step course. The Ultimate Microsoft Excel Essentials Training course takes you through the basics of Excel, but also introduces some more advanced topics like advanced filters, pivot charts and pivot tables. The course also learns you some, shortcuts, tips and tricks for improving your productivity in working with Excel.

--

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Lorenz De Smedt

IT Professional (Certified)

Hi there!

Hi there. My name is Lorenz, I am an ITIL and PRINCE 2 certified IT professional with several years of experience working as a consultant and functional analyst, mainly in the domain of Business Intelligence.

Working experience:

I have worked for clients within the Energy and Insurance sector, and am currently involved in the analysis, implementation, testing and rol-out of Business Intelligence solutions.

As an instructor, I want to share my knowledge ...

See full profile