Advanced Excel Course launching on Mar. 1, 2025

Microsoft Excel - Beginner Course

Overview
Curriculum
Reviews
FAQs

This is where your Excel journey begins.

 

Our Beginner course focuses on the absolute basics - from navigating the interface to working with basic functions and creating your very first spreadsheet. The course is designed to build strong foundations that set the pathway to confidently progress to an intermediate level.

 

At ExcelCamp, we believe that learning should be engaging, supportive, and interactive. Here’s what makes this course stand out:

 

 

  • Progressive Learning: Our curriculum is structured to build your skills incrementally, ensuring that you develop a solid understanding of each concept before moving on to the next. This step-by-step approach helps you gain confidence and proficiency as you progress through the course. 

 

  • Dedicated Support: Questions along the way? Our teaching assistants are always ready to help. Plus, you might find answers and new perspectives from fellow students – learning is a team effort here! 

 

  • Interactive Learning: Learning is more engaging and effective when it's interactive. Our courses feature active discussions and comment sections where you can engage with instructors and peers. This collaborative environment enhances your understanding and retention of the material.

 

  • Community: ExcelCamp is more than just a course; it's a vibrant community. Join us on our social media platforms and become part of a supportive community where you can share tips, ask questions, and grow together with peers.

 

 

This course is mainly designed for complete beginners who are starting from scratch. However, it is also perfect for anyone looking to refresh their basics, boost their productivity, or simply learn a valuable new skill. 

 

Curriculum

  • 10 Sections
  • 68 Lessons
  • 8 Quizzes
  • 4h 15m Duration
Expand All
Section 1: Course Introduction
2 Lessons
  1. 1. Welcome
  2. 2. Certificate of Completion
Section 2: The Basics
8 Lessons1 Quiz
  1. 3. Start-Up Microsoft Excel
  2. 4. Excel Interface - Workbook and Worksheet
  3. 5. Worksheet Area - Cells in Excel
  4. 6. Quick Access Toolbar
  5. 7. The Ribbon
  6. 8. The Formula Bar
  7. 9. The Status Bar
  8. 10. Saving an Excel Workbook
  9. Quiz: The Basics
Section 3: Inserting and Modifying Data
7 Lessons1 Quiz
  1. 11. Cell Structure and Data Entry
  2. 12. Entering Text in Cells
  3. 13. Entering Numbers in Cells
  4. 14. Working with Date Values in Excel
  5. 15. Using Excel's Auto Fill Feature
  6. 16. Using Excel's Flash Fill Feature
  7. 17. Inserting Comments and Notes
  8. Quiz: Inserting and Modifying Data
Section 4: Building Basic Excel Formulas
11 Lessons1 Quiz
  1. 18. Cell References in Excel
  2. 19. Relative & Absolute Cell References
  3. 20. Essential Excel Rule - Order of Operations
  4. 21. Getting started with Formulas and Functions
  5. 22. The SUM Function
  6. 23. AutoSum in Excel
  7. 24. The AVERAGE Function
  8. 25. The MIN & MAX Function
  9. 26. The COUNT Function
  10. 27. Referencing Cells from other Worksheets and Workbooks
  11. 28. Understanding Basic Errors
  12. Quiz: Building Basic Excel Formulas
Section 5: Editing an Excel Worksheet
7 Lessons1 Quiz
  1. 29. Copying and Moving Worksheet Data
  2. 30. Copying and Pasting Data with "Paste Special"
  3. 31. Inserting and Deleting Rows and Columns
  4. 32. Changing the Size of Cells
  5. 33. Hiding, Unhiding and Grouping Rows and Columns
  6. 34. Finding and Replacing Worksheet Data
  7. 35. Selecting Data with "Go To Special"
  8. Quiz: Editing an Excel Worksheet
Section 6: Formatting an Excel Worksheet
11 Lessons1 Quiz
  1. 36. Excel Font Formatting - Font Options & Colors
  2. 37. Cell Formatting - Fills, Gradients and Patterns
  3. 38. Working with Cell Borders
  4. 39. Excel Number Format and Percentage Style
  5. 40. Quick Number Formatting Tips
  6. 41. Excel Alignment Options
  7. 42. Wrap Text & Merge and Centre
  8. 43. Introduction - Conditional Formatting
  9. 44. More on Conditional Formatting
  10. 45. Using Excels Format Painter
  11. 46. Easier Formatting with Cell Styles
  12. Quiz: Formatting an Excel Worksheet
Section 7: Managing an Excel Worksheet
7 Lessons1 Quiz
  1. 47. Renaming and Coloring Worksheets
  2. 48. Moving and Copying a Worksheet
  3. 49. Deleting and Hiding Worksheets
  4. 50. Worksheet Navigation Techniques & Shortcuts
  5. 51. Splitting the Worksheet into Panes
  6. 52. Using More Windows for the Same Workbook
  7. 53. Working with Multiple Workbooks
  8. Quiz: Managing an Excel Worksheet
Section 8: Working with Charts, Images and Shapes
9 Lessons1 Quiz
  1. 54. Creating Basic Charts in Excel
  2. 55. Customizing an Excel Chart
  3. 56. Modifying the Data Source of an Excel Chart
  4. 57. Changing the Formatting of an Excel Chart
  5. 58. Moving a Chart to a New Location
  6. 59. Inserting Images in Excel
  7. 60. Working with Shapes
  8. 61. Using Excel Sparklines
  9. 62. Working with Smart Arts
  10. Quiz: Working with Charts, Images and Shapes
Section 9: Printing an Excel Worksheet
5 Lessons1 Quiz
  1. 63. Using Excel’s Print Preview Feature
  2. 64. Adjusting the Margins and Scaling
  3. 65. Printing Multiple Sheets and Parts of Sheets
  4. 66. Adding Header and Footer
  5. 67. Working with Excel’s Page Layout and Page Break View
  6. Quiz: Printing an Excel Worksheet
Section 10: Conclusion and Next Steps
1 Lesson
  1. 68. Where to Go from Here (Continue Learning)
0 out of 5

0 user ratings

FAQs

Expand All
1.  Will I have lifetime access to this course?

Yes, once you enroll in the course, you will have lifetime access.

2.  What kind of support can I expect if I need help during the course?

Our dedicated support team is here to help with any course-related questions or technical issues you might encounter. You can reach out via our Q&A section or email us at any time for assistance.

3.  Will I receive a certificate upon completion?

Yes, upon completing any of our courses, you will receive a certificate that you can add to your LinkedIn profile and resume. Note: We are currently developing digital badges, we will notify you once they are available.

4.  How often is the courses updated?

We regularly update our courses to ensure they reflect the latest in Excel functionality and best practices. Typically, courses are reviewed and updated annually, or sooner if significant changes in Excel occur.

5.  I am evaluating this for our team. Who can I speak with to learn more?

Please contact us directly at info@excel-camp.com to learn more about bulk discounts.

×

Free Lesson Videos:

Thumbnail
6. Quick Access Toolbar
00:03:36
Thumbnail
13. Entering Numbers in Cells
00:10:00
Thumbnail
26. The COUNT Function
08:20:31
Thumbnail
33. Hiding, Unhiding and Grouping Rows and Columns
10:00:39

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: