Why This Course?
With this course you will gain essential skills quickly, with hands-on learning, supporting material, quizzes, and flexible schedule. Explanations are in plain simple language and no previous knowledge is needed.
If you wish to preview some of the lectures before joining, scroll down to Course Curriculum.
⇊
And - One more thing...
How to enroll and what happens next?
First, our school and courses are hosted on Teachable platform. They are dealing with payment processing and courses hosting, so that we can have more time to make better content for you. So, don't be surprised if you see name "Teachable".
-After you enter your email and payment details, you will get conformation email from Teachable.
-In that email you will find a link to your student area. You will be prompted to create a password and you are ready to go.
-Next time you want to login, just follow this link or go to "Login" on XLLearner web site.
What is included:
✔ Over 3 hours of video material.
✔ Detailed instructions on how to approach this course, for best learning experience.
✔ Supporting Work files, so that you can follow the lectures and practice as you progress.
✔ Also included are Practice files with different task to resolve on your own.
✔ Quiz after each section, so that you can test your knowledge.
✔ Certificate for successful completion of the course.
Excel Essentials Curriculum
- 3.1. Data Entry Editing and AutoFill (4:43)
- 3.2. Flash Fill (1:57)
- 3.3. Dates and Times (5:16)
- 3.4. Undo Redo Save and Save As (4:41)
- 3.5. Rows and Columns Insert Delete Hide and Unhide (7:54)
- 3.6. Moving Copying and Deleting Data (4:12)
- 3.7. Finding and Replacing Data (3:31)
- Section 3 Practice Files
- Section 3 Quiz
- 5.1. Introductions to Formulas and Functions (5:45)
- 5.2. Relative Absolute and Mixed References (4:36)
- 5.3. SUM and AVERAGE (2:05)
- 5.4. Statistical Functions MIN MAX (4:00)
- 5.5. IF and Nested IF (4:41)
- 5.6. COUNT COUNTA (4:27)
- 5.7. SUMIF AVERAGEIF (4:41)
- 5.8. ROUND (2:45)
- 5.9. VLOOKUP (6:08)
- 5.10. Problems with VLOOKUP (3:56)
- 5.11. XLOOKUP (3:11)
- 5.12. RAND (3:13)
- 5.13. CONCAT (2:15)
- 5.14. Text Functions 1 (4:47)
- 5.15. Text Functions 2 (4:16)
- 5.16. New Text Functions (2:49)
- 5.17. Date and Time Functions (2:10)
- 5.18. What Next With Formulas (1:20)
- Section 5 Practice Files
- Section 5 Quiz
Helena G,
Small Business Owner
"This course exceeded my expectations – it provided clear, concise, and practical insights that I could immediately apply to my work."
Will S.
Sales Analyst
"I thought Excel was intimidating, but this course made it easy to understand and use for my daily tasks!"
Brenton F.
Small Business Owner
"Taking this course I improved my Excel skills to a new level"
Featured
Currently featured and "coming soon" courses. We are working hard on transitioning to online teaching. Keep checking for new courses and subscribe below if you want to be updated with latest news.