Excel Microsoft Office 365 Beginner course
Learn Excel basics! Master Microsoft Office 365: workbooks, formulas, templates & more. Perfect for beginners to boost productivity.
Course Content
Excel Microsoft Office 365 Beginner course is a beginner-level Udemy course taught by Steve Paulick. It runs 3h 23m, is taught in English, and includes a certificate of completion. Learners rate it 4.2 out of 5 from 11 reviews, with 45 students enrolled. It is a paid course, last updated December 2022.
Unlock the power of Excel 365 with this comprehensive beginner course! Part one of a three-part series, this class is designed to get you comfortable with the latest features of Microsoft Excel from Microsoft Office. Whether you're a complete novice or looking to refresh your skills, this course provides a solid foundation for success.
What you'll learn:
- Excel 365 New Features: Discover what's new in the latest version of Excel and how these features can boost your productivity.
- Getting Started: Learn how to start up Excel, navigate the interface, and understand the key components like workbooks, worksheets, and cells.
- Workbook & Worksheet Management: Master the art of creating new workbooks, organizing your worksheet, and efficiently managing your data.
- Essential Formulas: Demystify basic formulas and functions, including summing columns, using Autosum, and copying formulas.
- Templates & Themes: Explore the benefits of using templates and themes to streamline your work and create professional-looking spreadsheets.
- Data Organization: Learn techniques for organizing your worksheet with features like freezing panes, splitting panes, and formatting numbers and dates.
- Data Manipulation: Gain proficiency in copying, pasting, and moving data, including using Paste Special for precise results.
- Advanced Editing: Master editing data, using Find & Replace, Undo/Redo, and Autofill to save time and effort.
- Conditional Formatting: Apply conditional formatting to highlight important data and gain valuable insights.
Who is this course for?
This Excel 365 class is perfect for anyone who wants to:
- Improve their Microsoft Excel skills.
- Boost their productivity with spreadsheets.
- Gain a competitive edge in the workplace.
- Learn from an experienced professional.
Your Instructor:
Taught by a Microsoft Certified Professional and Comptia A+ Computer expert with 20 years of experience as the President and owner of a computer repair, networking, and software company. He holds three college degrees in computer science, programming, networking, and GIS, and has a proven track record of developing professional software and helping over 3,000 clients master Microsoft computer software, hardware, and peripherals.
Course Content Breakdown:
- Chapter 1: Excel 365 Overview
- Understanding the differences between Excel versions.
- Exploring new features in Excel 365.
- Navigating Excel with Office and in the Cloud.
- Understanding Excel workbooks and worksheets.
- Chapter 2: Starting Up Excel
- Opening workbooks and worksheets.
- Understanding the Excel screen (ribbon, quick access toolbar, name box).
- Customizing the Ribbon.
- Using Find & Replace, Undo/Redo, Copy/Paste.
- Scrolling, adjusting columns and rows.
- Using Autofill and Comments.
- File and View tab functionalities.
- Chapter 3: Creating New Workbooks
- Entering and editing text, numbers, and dates.
- Designing borders and backgrounds.
- Opening and saving workbooks.
- Understanding Excel file formats.
- Using conditional formatting.
- Chapter 4: Organizing Your Worksheet
- Freezing and splitting panes.
- Creating, renaming, hiding, and unhiding worksheets.
- Using Format Painter.
- Alignment and wrap text.
- Formatting numbers and dates.
- Copying and moving worksheets.
- Copying and pasting data (including Paste Special).
- Chapter 5: Basic Formulas
- Understanding formulas and functions.
- Creating basic formulas (sum, average, etc.).
- Copying formulas.
- Simple formula syntax.
- Inserting functions.
- AutoCalculate.
- Arithmetic operations (add, subtract, multiply, divide).
- Editing cell ranges.
- Chapter 6: Using a Template
- Creating and using templates.
- Applying styles and themes.
Included:
- Downloadable Test Quiz with answer key to assess your understanding.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.