- Introduction (Who am I?)
- Welcome to Excel
- Sums & Fills
- Split & Transpose
- Sort & Filter
- Tables
- Drop-downs
- Analyze & Charts
- Pivot Tables
- PLEASE LEAVE A REVIEW :)
What you'll learn
- Learn Microsoft Excel Basics
- Learn Microsoft Excel the fun way, in an engaging way
- Learn Microsoft Excel Formulas
- Learn Microsoft Excel Shortcuts
- Learn Microsoft Excel Hacks to Increase your productivity
Description
This course is a very basic level entry Microsoft Excel Tutorial. If you are intermediate, you might still learn a few shortcuts or productivity tips.
I am going to go through the Microsoft Excel Built-in Template "Welcome to Excel". That you can open on your computer at the same time as I do it (which I highly recommend that you do in order to solidify the learnings)
I could summarize this video with the followings : Microsoft Excel basics, charts, formulas, your go to place to learn excel from zero. Mainly beginner and intermediate level.
The Welcome to Excel template go through these subjects :
Sums & Fill
Show you how to do sum, sumifs, tips with CTRL C CTRL V
Show you how to drag formulas and the flash fill funciton
Split & Transpose
Splitting text and copying values from horizontal to vertical is taught here.
Sort & Filter
Going through different type of filters that will help you (Filter by Color , Filter top performers, bottom performers)
Tables
Very introductive level on tables and why you should / should not use it.
Drop-Downs
Drop downs list to help your data entry faster.
Analyze & Charts
Quick words on analyze and charts
Pivot Tables
The most excel useful tool ever invented :)
Other Courses
Chess Opening Principles - Master the Fundamentals with a GM
The #1 Course Every Beginner Should Start With
Technical Analysis: Candlestick Trading For Beginners 2024
Technical Analysis For Beginners - Candlestick Trading Foundation For Day Trading, Swing Trading, and Financial Trading
How to Transcribe and Excel In General Transcription
An Online General Transcription Course for Both Beginners and Experts.
Big Data and Hadoop Essentials
Essential Knowledge for everyone associated with Big Data & Hadoop
About the instructors
- 4.39 Calificación
- 5159 Estudiantes
- 4 Cursos
David Fortin
Learn Excel the Fun Way
I am a CPA / Je suis CPA
I teach you Excel the fun way / Je vous enseigne Excel de façon moderne
I sold a company for $200M with Microsoft Excel & Powerpoint
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
English
I worked for a Big Four (Accounting Firm) for a few years, then in Financial Planning & Analysis for Ubisoft and was an FP&A manager for a tech company for a few years. Now I teach Excel & Productivity tools full time. Feel free to ask anything and reach out directly on social medias.
Youtube is where I'm the most active (under the handle Piggy Bank Accountant)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
French
J'ai une expérience importante en matière de comptabilité en entreprise. J'ai plus de 10 ans d'experience avec Microsoft Excel et j'ai géré des dossiers importants tel que le financement d'une entreprise pour plus de 30M$ et la vente de cette dernière pour plusieurs centaines de millions. Je fais beaucoup de video tutoriel/astuce Excel sur Youtube (sous le nom de "Piggy Bank Accountant En Français")
Il est possible pour nous de travailler ensemble! N'hésitez pas à me rejoindre
Student feedback
Course Rating
Reviews
Esta en inglés
very informative, clear explanation. thanks