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

Microsoft Excel 365 Essentials

Master Excel's essential functions and formatting tools, empowering you to organize, analyze, and present data.
Created bySimon Sez IT
Last updated 5/2024
English

What you'll learn

  • Navigate the Excel ribbon and cursor options.
  • Enter and format data effectively.
  • Apply number and style formatting to tables.
  • Use formulas with relative and absolute references.
  • Utilize AutoFill and create custom lists.
  • Implement conditional formatting based on cell content.
  • Sort and filter data for better analysis.
  • Create and format various types of charts.

Course content

9 sections • 44 lectures • 3h 26m total length

  • Course Welcome2:05
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Instructor Files0:23
  • DOWNLOAD ME: Course Exercise Files0:23
  • Ribbon Overview4:08
  • Cursor Options2:11
  • Data Entry Basics3:12
  • Layout Options5:17
  • Section Quiz

Requirements

  • An active Microsoft 365 account to access Excel is beneficial to follow along.
  • No prior experience needed, the course is for complete beginners.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


This Microsoft Excel 365 Essentials course will teach you the fundamental skills to use Excel efficiently and effectively. Starting with an overview of Excel, you will get comfortable with the ribbon, cursor options, and basic data entry techniques. This course is designed to help you master Excel's powerful formatting features, formulas, and data management.


You will discover how to format numbers, styles, and tables to make your data visually appealing and easy to read. The course will introduce you to essential formulas, including how to use relative and absolute references. You will also learn about AutoFill and creating custom lists to speed up your work.


Conditional formatting will teach you to highlight important data using icons and color scales. Sorting and filtering techniques will help you organize and analyze large datasets effectively. You will also learn to manage large workbooks with tools like freeze panes, splitting, and printing options.


Charts are a vital part of data presentation, and you will learn how to create and format different types of charts, including column and pie charts. Additionally, you will practice inserting charts into PowerPoint for professional presentations.


By the end of this course, you should have a solid foundation in Excel 365, enabling you to handle various data-related tasks confidently. Each section includes practical exercises to reinforce your learning and ensure you can apply what you've learned. This course is perfect for beginners and those looking to refresh their Excel skills.


In this course, you will learn how to:

  • Navigate the Excel ribbon and cursor options.

  • Enter and format data effectively.

  • Apply number and style formatting to tables.

  • Use formulas with relative and absolute references.

  • Utilize AutoFill and create custom lists.

  • Implement conditional formatting based on cell content.

  • Sort and filter data for better analysis.

  • Create and format various types of charts.


This course includes:

  1. 3+ hours of video tutorials

  2. 41 individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion

Who this course is for:

  • Microsoft Excel novice.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • Those who need an Excel refresher and want to improve their knowledge.
  • Users who have a foundation of Microsoft Excel and seeking to advance their Excel 365 knowledge.

Report abuse