Udemybeginneren

Excel Microsoft Office 365 Beginner course

Learn Excel basics! Master Microsoft Office 365: workbooks, formulas, templates & more. Perfect for beginners to boost productivity.

4.2(11)
45students
3h 23m
Certificate
Steve Paulick
Steve PaulickMicrosoft Certified Professional Instructor

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.
$ whoami — the devs behind tutorialsearch.io

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.

5.0(458)
43m
beginner
skillshare
5.0(234)
1h 36m
all
skillshare
skillshare
5.0(122)
3h 38m
all
skillshare
5.0(437)
3h 15m
all
skillshare