LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

Mastering Excel 365 - Beginner (2025)

Learn how to use the world’s most popular tool for analyzing and reporting on data.

Created byBigger Brainsworkspace_premium
BeginnerUpdated Aug 11, 2026
Mastering Excel 365 - Beginner (2025)

What You'll Learn

check_circleNavigate the interface including accessing commands and selecting and entering data
check_circleCreate and save a new workbook
check_circlePerform calculations using formulas and functions
check_circleFormat text cells and apply Conditional Formatting
check_circlePrint workbooks
check_circleAdd charts and graphics to your workbook

About This Course

Excel 365 is the foundation for almost every kind of data work, from tracking a simple budget to building reports that summarize hundreds of records. This course introduces the Excel workspace and shows new users how to move through it with confidence, starting with the ribbon, the formula bar, the name box, and the worksheet tabs that organize a workbook. From there it builds the core habits of accurate data entry, including using Enter and Tab to commit data, referencing cells rather than typing fixed values so that related cells update on their own, and reading the order of operations that Excel follows when it calculates a formula. The goal is a working command of the interface and the everyday tools that every later skill depends on.

The program covers the difference between a workbook, a worksheet, and a cell, and explains functions, the AutoSum tool, fill series, and cell styles. It walks through writing formulas with the standard operators for addition, subtraction, multiplication, and division, all built on the equal sign that begins every formula, and it applies the order of operations known as PEMDAS to keep results correct. Participants learn efficient navigation and selection, the shortcut keys for formatting and editing, and practical fixes for common situations such as widening a column to clear the number sign display. The course closes with creating a basic chart, including the row and column headings so the chart carries proper labels.

Learning Objectives

  1. Identify the main elements of the Excel 365 interface, including the ribbon, formula bar, name box, and worksheet tabs.
  2. Enter and edit data accurately using Enter, Tab, and the formula bar.
  3. Define the relationship between a workbook, a worksheet, and a cell.
  4. Write formulas using cell references and the standard operators for addition, subtraction, multiplication, and division.
  5. Apply the order of operations known as PEMDAS to predict how Excel evaluates a formula.
  6. Navigate and select data efficiently using keyboard shortcuts and create a labeled chart from a selected range.

This course is designed for new Excel users and those returning after a break. It assumes no prior experience with the application and reflects the features available in the 2025 version of Excel 365.

Your Instructors

Bigger Brains
Bigger Brains

Powering Productivity, One Brain at a Time!

menu_book103 courses
star3,284 reviews

Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject matter experts have real-world experience and create the most realistic and comprehensive training courses possible. Bigger Brains courses are built in a unique “Teacher/Learner” style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This Uniquely Engaging™ video-based format is more enjoyable and more effective than traditional eLearning formats.

Kathy Jones
Kathy Jones

Certified Trainer

Kathy is a Microsoft Certified education/training professional with experience in all aspects of training. Her strengths include classroom presentations, organizational skills, problem-solving, program design and development, and interpersonal communication.

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.

Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.

What Students Are Saying

0.0
Student's Choice
0 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

Accounting & Tax: Financial Accounting

 Latest Accounting Update: ASPE and ASPO (2025)

star5.0(65)
2.5 CPD hrs
Audit & Assurance: Audit and Assurance Update

Assurance Update 2026

star5.0(86)
3 CPD hrs
Audit & Assurance: Anti Money Laundering

AML Compliance for Small CPA Firms

star5.0(45)
1 CPD hr