Microsoft Excel Fundamentals
Boost Your Excel Skills and Unlock Your Productivity Potential
Offer expires on August 31, 2024 at 23:00 CET
With our Excel Fundamentals online self-paced learning course, you'll become more productive, efficient, and confident with Excel in no time.
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
Download materials (Part 1)
1-2-01 Arithmetic operations & BODMAS principle
FREE PREVIEW1-2-02 Entering formulas in Excel
FREE PREVIEW1-2-03 Fixing cell reference
1-2-04 Formulas in multiplication table
1-2-05 Mixed and Fixed reference in one formula
1-2-06 How to trick those references with Dynamic Arrays
1-2-07 Relative and Absolute references explained
1-2-08 Addtional methods of copying formulas
>>> Getting started with Excel functions
1-3-01 Getting started with Excel functions
FREE PREVIEW1-3-02 Ways to construct SUM function
1-3-03 Rounding numbers, why & how
1-3-04 Basic statistics with MIN, MAX, AVERAGE & Status bar
1-3-05 Counting numeric and text values with COUNT and COUNTA
1-4-01 Calculation in practice (exercise)
FREE PREVIEW1-4-02 Calculating Market Share %
1-4-03 Variance value and %
1-4-04 Market share variance % and % point
1-4-05 Profit margin knowing purchase price and mark-up
1-4-06 Profit margin knowing profit and Purchase price
1-4-07 Calculating forecasted year result
1-4-08 Year on Year change
1-4-09 Market share % in range
1-5-01 Evaluating result with IF function
1-5-02 Hands on creating a condition with IF function
1-5-03 Using multiple conditions (Nested IF)
1-5-04 Changing evaluation result to cell references
Download materials (Part 2)
2-0-1 Excel productivity module introduction
FREE PREVIEW2-1-1 Fill in sequential data, copy series etc.
2-1-2 Move & Copy by Dragging
2-1-3 Merging cells vs. Centering across
FREE PREVIEW2-1-4 Splitting text with Flash Fill
2-1-5 Splitting text with Text to Columns
2-1-6 Fitting in long text in Excel
FREE PREVIEW2-1-7 Printing tips and options
2-2-1 Overview of Text functions
FREE PREVIEW2-2-2 Extract text with static reference (LEFT, MID, RIGHT)
2-2-3 Extracting text using dynamic reference (SEARCH)
2-2-4 Extracting text using dynamic reference (2x SEARCH & MID)
2-2-5 Extracting text using dynamic reference (LEN & RIGHT)
2-2-6 4 ways of Combining text
2-2-7 Changing text case (UPPER, LOWER, PROPPER)
2-2-8 Substitute text and remove extra spaces from text
2-2-9 Converting text numbers to numbers and numbers to text
2-3-1 Introduction to Filtering
2-3-2 Getting started with Filtering
2-3-3 Filtering and replacing Errors (#)
2-3-4 Multiple text filters
2-3-5 Excluding item from filter
2-3-6 Getting subtotal of filtered values
2-3-7 Filtering Top and Bottom values
2-3-8 Filtering by color
2-3-9 Sorting text, numbers, colors
2-3-10 Filter duplicate values (Conditional Formatting)
2-3-11 Remove duplicates in detail
2-3-12 Unique list of values with function
FREE PREVIEW2-4-1 What can be protected in Excel
FREE PREVIEW2-4-2 Setting Workbook password to open & modify
2-4-3 Protecting Workbook structure
FREE PREVIEW2-4-4 Protecting Worksheet and Cells
2-4-5 Password protecting range of cells for editing
2-4-6 Setting Data validation
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!" |
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!
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.
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.
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.
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.
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.
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.
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.
Offer expires on August 31, 2024 at 23:00 CET