Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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
    • Advanced Filters

      5:49
    • Data Validation and Remove Duplicate Values

      6:28
    • Pivot Tables

      5:39
    • Pivot Charts

      4:11

About This Class

44b4c571

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

0

Reviews (0)

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

Business Excel Productivity Microsoft Excel