Excel 365 Beginner

Excel 365 Beginner

Learning Outcome

Overview

Learn how to master the latest version of the IT industry’s leading spreadsheet software programme simply by taking this Excel 365 Beginner course. This versatile platform is the lynchpin of the Microsoft Office 365 suite and can turn dull statistics into impactful content. With our training, you can quickly go from being flummoxed by formulas and functions to becoming a spreadsheet specialist.      

This comprehensive Excel tutorial will take you from the absolute basics of what it provides to much more complex utilities. You’ll be shown how to navigate interfaces, create workbooks, introduce formulas, and so much more. With these interactive and intuitive teaching modules, you’ll be able to translate data into powerful presentations and statements. Enrol now to become an Excel expert and make the most of this essential software.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Excel 365 Beginner is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Unit 01
Lesson 01: What is Excel 00:03:00
Lesson 02: Opening Excel 00:04:00
Lesson 03: Navigating the Excel User Interface-v2 00:06:00
Lesson 04: Navigating the Excel User Interface 00:04:00
Lesson 05: Using the Excel Ribbon 00:07:00
Lesson 06: Understanding Excel Worksheet Components 00:07:00
Lesson 07: Using the Backstage View 00:06:00
Unit 02
Lesson 01: Creating a New Workbook 00:06:00
Lesson 02: Saving an Excel Workbook 00:05:00
Lesson 03: Using the Accessibility Checker 00:04:00
Lesson 04: Using the Accessibility Checker-v3 00:04:00
Unit 03
Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00
Lesson 02: Understanding Excel Data Types 00:04:00
Lesson 03: Using the Inking Tools 00:05:00
Lesson 04: Using the Inking Tools-v3 00:03:00
Lesson 05: Working with Cell and Range Addressing 00:05:00
Lesson 06: Using Various Data Selection Techniques 00:05:00
Lesson 07: Working with Common Excel Commands 00:06:00
Lesson 08: Using Flash Fill and Autofill 00:06:00
Unit 04
Lesson 01: What are Formulas and Functions 00:05:00
Lesson 02: Understanding the Components of a Formula 00:05:00
Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00
Lesson 04: Creating Basic Formulas 00:05:00
Lesson 05: Working with Basic Functions and AutoSum 00:06:00
Lesson 06: Using Cell References 00:05:00
Lesson 07: Using the Quick Analysis Tool 00:03:00
Unit 05
Lesson 01: Modifying Columns and Rows 00:06:00
Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00
Unit 06
Lesson 01: Formatting and Aligning Data 00:07:00
Lesson 02: Merging Data 00:07:00
Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00
Lesson 04: Formatting Numbers 00:05:00
Lesson 05: Using the Format Painter 00:04:00
Unit 07
Lesson 01: Using Cell Styles 00:06:00
Lesson 02: Applying Themes 00:05:00
Unit 08
Lesson 01: Inserting and Formatting Images and Shapes 00:08:00
Lesson 02: Inserting and Formatting SmartArt 00:05:00
Lesson 03: Working with Icons 00:04:00
Lesson 04: Inserting Hyperlinks 00:06:00
Lesson 05: Inserting Symbols and Equations 00:05:00
Lesson 06: Inserting WordArt and Text Boxes 00:05:00
Lesson 07: Inserting 3-D Models 00:04:00
Lesson 08: Arranging Objects 00:06:00
Unit 09
Lesson 01: Using Find and Replace 00:05:00
Lesson 02: Using Go To and Go To Special 00:03:00
Lesson 03: Using the Spell Checker 00:05:00
Lesson 04: Using the Thesaurus and Translation Features 00:05:00
Lesson 05: Using the resolve Feature-v3 00:02:00
Unit 10
Lesson 01: Printing and Previewing Excel Files 00:06:00
Lesson 02: Creating Custom Margins and Scaling 00:05:00
Lesson 03: Adding Headers and Footers 00:04:00
Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00
Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00
Lesson 06: Exporting to PDF-v3 00:02:00
Lesson 07: Exporting to PDF and XPS 00:04:00
Unit 11
Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00
Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00
Lesson 03: Hiding and Unhiding Worksheets 00:03:00
Unit 12
Lesson 01: Viewing Workbooks 00:03:00
Lesson 02: Using Zoom Tools 00:03:00
Lesson 03: Configuring Sheet Options 00:05:00
Lesson 04: Using the Freeze Panes and Split Commands 00:04:00
Lesson 05: Adjusting Worksheet Properties 00:04:00
Lesson 06: Viewing Workbook Statistics-v3 00:02:00
Course Recap
Recap 00:02:00
Final Exam
Final Exam – Excel 365 Beginner 00:20:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon