Special 60% discount valid for a limited time

Offer expires on November 30, 2024 at 23:00 CET

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Are you ready to take your Excel skills to the next level?

With our Excel Fundamentals online self-paced learning course, you'll become more productive, efficient, and confident with Excel in no time.

In about 7.5 hours of short video lectures and practical exercises, we cover everything starting from basic operations and formulas to text functions, filtering data, protection in Excel, dates and date functions, and Data Lookup and Merging Tables. The course approach ensures that you quickly gain the skills you need to work with Excel like a pro.

Students tell us that explanations are clear and easy to understand, making it simple for anyone to learn and apply Excel skills. This course is designed to be accessible to anyone, even those without prior knowledge of Excel, with short video lectures and practical examples that allow you to learn at your own pace.

Enroll today and unlock your Excel potential with Excel Fundamentals course.
Start learning

Become confident with Excel

Work Smarter Not Harder

  • Become confident using Excel

  • Easy To Use Excel Work Files

  • 7.5 hours of video content

  • 36 Months Access - 24 x 7 anytime & anywhere

  • Reach out to us via email for support

  • Excel Know How Certificate Upon Completion

  • 14 day Money-Back Guarantee

Become an Expert

by learning those essential Excel skills

  • Functions and Formulas

    Most popular functions, best practices, copying formulas, and mastering calculations of Market Share, Profit Margins, Variance

  • Time-Saving Techniques

    Best functionalities handling Excel spreadsheets and cells.

  • Master Text Functions

    Excel functions to extract, combine, convert and manipulate with texts.

  • Protect Data

    From Workbook to Cell protection and Data Validation.

  • Dates and Time Travel

    All you need to know about Date and Time in Excel.

  • Data Lookup

    Highly essential skills of Data Lookup & Merging Tables using VLOOKUP, XLOOKUP, MATCH functions

Course Contents

    1. Welcome to the course

      FREE PREVIEW

    1. Download materials (Part 1)

    2. 1-2-01 Arithmetic operations & BODMAS principle

      FREE PREVIEW

    3. 1-2-02 Entering formulas in Excel

      FREE PREVIEW

    4. 1-2-03 Fixing cell reference

    5. 1-2-04 Formulas in multiplication table

    6. 1-2-05 Mixed and Fixed reference in one formula

    7. 1-2-06 How to trick those references with Dynamic Arrays

    8. 1-2-07 Relative and Absolute references explained

    9. 1-2-08 Addtional methods of copying formulas

    10. >>> Getting started with Excel functions

    11. 1-3-01 Getting started with Excel functions

      FREE PREVIEW

    12. 1-3-02 Ways to construct SUM function

    13. 1-3-03 Rounding numbers, why & how

    14. 1-3-04 Basic statistics with MIN, MAX, AVERAGE & Status bar

    15. 1-3-05 Counting numeric and text values with COUNT and COUNTA

    1. 1-4-01 Calculation in practice (exercise)

      FREE PREVIEW

    2. 1-4-02 Calculating Market Share %

    3. 1-4-03 Variance value and %

    4. 1-4-04 Market share variance % and % point

    5. 1-4-05 Profit margin knowing purchase price and mark-up

    6. 1-4-06 Profit margin knowing profit and Purchase price

    7. 1-4-07 Calculating forecasted year result

    8. 1-4-08 Year on Year change

    9. 1-4-09 Market share % in range

    1. 1-5-01 Evaluating result with IF function

    2. 1-5-02 Hands on creating a condition with IF function

    3. 1-5-03 Using multiple conditions (Nested IF)

    4. 1-5-04 Changing evaluation result to cell references

    1. Download materials (Part 2)

    2. 2-0-1 Excel productivity module introduction

      FREE PREVIEW

    3. 2-1-1 Fill in sequential data, copy series etc.

    4. 2-1-2 Move & Copy by Dragging

    5. 2-1-3 Merging cells vs. Centering across

      FREE PREVIEW

    6. 2-1-4 Splitting text with Flash Fill

    7. 2-1-5 Splitting text with Text to Columns

    8. 2-1-6 Fitting in long text in Excel

      FREE PREVIEW

    9. 2-1-7 Printing tips and options

    10. 2-2-1 Overview of Text functions

      FREE PREVIEW

    11. 2-2-2 Extract text with static reference (LEFT, MID, RIGHT)

    12. 2-2-3 Extracting text using dynamic reference (SEARCH)

    13. 2-2-4 Extracting text using dynamic reference (2x SEARCH & MID)

    14. 2-2-5 Extracting text using dynamic reference (LEN & RIGHT)

    15. 2-2-6 4 ways of Combining text

    16. 2-2-7 Changing text case (UPPER, LOWER, PROPPER)

    17. 2-2-8 Substitute text and remove extra spaces from text

    18. 2-2-9 Converting text numbers to numbers and numbers to text

    19. 2-3-1 Introduction to Filtering

    20. 2-3-2 Getting started with Filtering

    21. 2-3-3 Filtering and replacing Errors (#)

    22. 2-3-4 Multiple text filters

    23. 2-3-5 Excluding item from filter

    24. 2-3-6 Getting subtotal of filtered values

    25. 2-3-7 Filtering Top and Bottom values

    26. 2-3-8 Filtering by color

    27. 2-3-9 Sorting text, numbers, colors

    28. 2-3-10 Filter duplicate values (Conditional Formatting)

    29. 2-3-11 Remove duplicates in detail

    30. 2-3-12 Unique list of values with function

      FREE PREVIEW

    1. 2-4-1 What can be protected in Excel

      FREE PREVIEW

    2. 2-4-2 Setting Workbook password to open & modify

    3. 2-4-3 Protecting Workbook structure

      FREE PREVIEW

    4. 2-4-4 Protecting Worksheet and Cells

    5. 2-4-5 Password protecting range of cells for editing

    6. 2-4-6 Setting Data validation
  • 103 lessons
  • 7.5 hours of video content
  • Easy To Use Excel Work Files
  • Certificate Upon Completion
  • 36 Months Access 24x7

Get to know the Course Author

Ivars Krampis-Vanags

Hi, I'm Ivars Krampis-Vanags, a business data analysis expert with over 20 years of experience using MS Excel in my daily work, and 7 years using Power BI.

As a passionate learner and problem solver, I developed my courses to help people like you learn new skills, increase your professional competences, and achieve your goals faster in both Excel and Power BI environments.

I have extensive experience in financial management, analysis, and planning, and use Excel and Power BI to develop data analysis solutions for companies and individuals. I'm confident in dealing with complex situations and providing professional consultations and services, including data automation and visualization.

Let's unlock your Excel potential together!

  • 3000+ students

    Trained over 3000 students in Excel and Power BI.

  • 600+ hours

    Delivered over 600 hours of instructor-led, in-person and online training.

  • 10+ courses

    Developed more than 10 different training courses and a great number of workshop trainings for Excel and Power BI.

What People Say

Reviews based on local language version of the course

Roberts
⭐⭐⭐⭐⭐

"This Excel course is excellent for people who want to gain a general and in-depth understanding of Excel functions and capabilities. The videos that explain the topics are easy to understand and comprehend. I am definitely interested in other types of courses in the future."
 Ieva
⭐⭐⭐⭐⭐

"The information presented in this course is presented in an easy-to-understand language for everyone. I particularly like the lecturer's tone of voice :) The course is useful, and I appreciate that everything is taught through practical examples. Thank you!"
 Ilona
⭐⭐⭐⭐⭐

"Complicated Made Simple - Thank you for this very good course; I learned a lot. It was helpful that I could revisit sections that I forgot during the course. Overall, the course is super - complicated things are explained simply and understandably! Ivars is the best specialist in his field! I am very satisfied and happy!"

Frequently Asked Questions

  • How do I enroll in the course?

    Enrolling is easy! Simply click on the "Enroll" button and proceed with the card payment process right here on our platform. Once you complete the payment, you will receive an order confirmation and be redirected to the course page. You'll also receive login information for future reference. It's that simple!

  • What level of Excel knowledge do I need to take this course?

    This course is designed for any level of knowledge while also suits beginners with little experience with Excel. If you have used Excel before, this course will be a helpful as it will cover areas that you may have missed or forgot.

  • What software do I need to take this course?

    It is recommended to have Microsoft Excel 365 as it is the most updated version, and the course is designed for the Windows version. However, the concepts covered in the course will also work on Mac versions of Excel. In general, most of the functionality covered in the course will be applicable to other spreadsheet software as well, although some of the functionality covered is specific to Excel.

  • Can I access the course on my mobile device or tablet?

    Absolutely! Our learning platform is designed to be mobile-friendly, so you can easily access the course on your smartphone or tablet through a web browser. While you can watch video lectures on the go, we recommend using a desktop or laptop computer to practice with the Excel files provided in the course.

  • Can I share this course with others?

    No, the course is intended for individual use only. Sharing access with others is not permitted, as it is a violation of our terms of service. However, we do offer group discounts and special offers for corporate groups. Please contact our team for more information at [email protected]. Additionally, please note that only the registered individual will receive a certificate and have access to support.

  • How do I get certificate upon completion?

    After successfully completing the Excel Fundamentals course, you will receive an Excel Know How Certificate. The certificate will be available for download in your account on the course platform or my team will email it to you.

  • Will there be other courses like this?

    Definitely! We're currently developing a comprehensive PivotTables and Dashboards course, as well as an Excel Power course covering Power Query and Power Pivot. We also have an in-depth Power BI course in the works, so stay tuned for more exciting courses to help you become an Excel and data analysis expert.

  • Do you offer group discounts or special offers?

    Yes, we do offer group discounts and special offers for companies or groups of individuals. We will work with you to find the best learning option for your team, which may include a larger number of participants, live or on-site group training, or workshops. Contact us at [email protected] for more information on our group pricing and options.

Special 60% discount valid for a limited time

Offer expires on November 30, 2024 at 23:00 CET

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds
Start Learning Now