Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Essentials
Rating: 4.0 out of 5(2 ratings)
6 students

Excel Essentials

Essential skills for those looking to start out with M365 Excel.
Created byChris Menard
Last updated 1/2025
English

What you'll learn

  • Learn to structure your documents into Workbooks & Worksheets and saving these.
  • Learn to move, copy and arrange data.
  • Get Started with Functions, Autofit/Autofill/Absolute Reference and Find & Replace.
  • Earn a Basic understanding of Charts, Sorting and Filtering.

Course content

12 sections • 27 lectures • 2h 11m total length

  • What is covered in the course0:43

    In this introduction, I list the topics covered in this Excel Essentials Course.

  • Check and Optimize performance1:14

    In this lesson, I delve into an update to Microsoft Excel that addresses a common issue many users face: excessively large Excel files due to unnecessary formatting. This feature, which was initially introduced in Excel for the web in September 2023, has now made its way to the desktop version, currently available for Windows users only. This new Excel tool provided by Microsoft enhances the performance of Excel files.

    I walk you through how to access this tool via the Review tab. Upon activating the "Check Performance" function, Excel opens a Task Pane on the right side of the interface, listing each worksheet alongside suggested optimizations. This feature intelligently identifies ranges within worksheets that, once optimized, could significantly improve the file's performance.

  • Essential Keyboard Shortcuts11:45

    Join me as I guide you through essential keyboard shortcuts to quickly select ranges in Excel. Discover the power of Ctrl, Shift, Home, End, and arrow keys to enhance your productivity. I'll share tips for navigating data efficiently, dealing with blanks, utilizing tables, and selecting large ranges with ease.

Requirements

  • You will need a M365 License through which you can download Excel for Windows or Mac.

Description

Excel Essentials: From Beginner to Confident User

Master the fundamentals of Microsoft Excel in this comprehensive 2-hour course designed specifically for absolute beginners. Whether you're looking to enhance your professional skills or organize personal data more effectively, this regularly updated course will give you a solid foundation in Excel's most essential features.

Starting with Excel's interface, you'll learn to navigate the Ribbon system confidently, understanding how tabs and groups organize Excel's powerful tools. You'll master basic workbook management, including creating, saving, and organizing your worksheets efficiently. The course covers essential operations like copying, moving, and hiding data, columns and rows, ensuring you can manipulate your information with ease.

Discover time-saving features such as Find and Replace for quick data updates and Flash Fill for automated data entry. You'll learn to transform your raw data into meaningful visual representations using Excel's charting tools, and organize information effectively with the basics of Excel's sorting and filtering capabilities.

Through hands-on exercises and real-world examples, you'll build practical skills that you can immediately apply to your work. By the end of this course, you'll have the confidence to tackle everyday Excel tasks and a strong foundation for advancing to more complex features.

No prior Excel experience required.

Who this course is for:

  • Beginner Excel users.

Report abuse