Easily Microsoft Excel

More Excel, Less Con(f)u$!on

This comprehensive course is designed for go-getters, problem-solvers, and data-driven enthusiasts who want to harness the true power of Microsoft Excel.

Whether you're crunching numbers, analyzing trends, or creating stunning visualizations, this course will give you the tools and confidence to excel in any industry and tackle any spreadsheet challenge head-on!

Do you ever feel like…

You waste way too much time trying to figure things out in your spreadsheets?

You’d be eligible for a dream job or promotion if you were more efficient in Excel?

You are by doing so many tasks manually but can’t figure out a way to automate them?

You’d be way more confident at work or school if you were an Excel expert?

You want to learn skills that will actually…

  • Land you a big promotion!

  • Secure your dream job!

  • Automate tasks to eliminate frustration!

  • Save hours in your work week to focus on other things!

I’M HERE TO INTRODUCE THE ANSWER YOU’VE BEEN LOOKING FOR:

The Easily Microsoft Excel course is designed for beginner to intermediate level Excel users! Part 1 covers the basic fundamentals of Excel and Part 2 familiarizes users with Excel’s advanced features and functions.

We will cover how to create and use formulas, analyze data, organize worksheet data with tables, visualize data with charts, master lookup functions, enhance workbooks, automate hundreds of task and so much more. By the end of the course you will be confidently be coasting in the spreadsheets by utilizing powerful pivot tables, advanced functions, and keyboard shortcuts (just to name a few)!

Easily Microsoft Excel

Course Curriculum

  • 1.0 - Excel Fundamentals

    1.1 - Excel Versions

    1.2 - Launching Excel

    1.3 - Getting Started with the Ribbon

    1.4 - Introduction to the Interface

    1.5 - Structure of a Workbook

    1.6 - Saving & Opening Documents

    1.7 - Excel Keyboard Shortcuts

  • 2.0 - Entering Data

    2.1 - Text Values

    2.2 - Numeric Values

    2.3 - Date Values

    2.4 - Creating Basic Formulas

    2.5 - Cell References: Relative Versus Absolute

  • 3.0 - Basic Excel Functions

    3.1 - Structure of a Function

    3.2 - SUM()

    3.3 - MIN() & MAX()

    3.4 - AVERAGE()

    3.5 - COUNT()

    3.6 - Correcting Errors

    3.7 - AutoSum

    3.8 - AutoFill

  • 4.0 - Modifying Worksheets

    4.1 - Copy & Pasting Data

    4.2 - Inserting & Deleting Rows / Columns

    4.3 - Changing the Width & Height of Cells

    4.4 - Hiding & Unhiding Rows / Columns

    4.5 - Renaming, Moving & Copying Worksheets

  • 5.0 - Formatting Worksheets

    5.1 - Font Formatting Basics

    5.2 - Backgrounds & Borders

    5.3 - Numeric Formats

    5.4 - Format Painter

    5.5 - Creating Styles

    5.6 - Merging & Centering Cells

    5.7 - Introduction to Conditional Formatting

    5.8 - Inserting Images & Shapes

  • 6.0 - Creating Charts

    6.1 - Creating a Column Chart

    6.2 - Adding & Modifying Chart Data

    6.3 - Formatting Charts

    6.4 - Moving Charts

    6.5 - Creating a Pie Chart

  • 7.0 - Printing Worksheets

    7.1 - Print Preview

    7.2 - Changing Margins, Scaling & Orientation

    7.3 - Printing Specific Range of Cells

  • 8.0 - Working with Lists

    8.1 - List Structure

    8.2 - Sorting

    8.3 - Filtering

    8.4 - Tables

    8.5 - Duplicate / Unique Values

    8.6 - Freeze Panes

    8.7 - Subtotals

  • 9.0 - Cleaning Data

    9.1 - Flash Fill

    9.2 - Data Validation

    9.3 - Text to Columns

    9.4 - Find & Replace

    9.5 - Remove Duplicates

    9.6 - Fill Blank Cells

    9.7 - Remove Blank Rows / Columns

    9.8 - IFERROR

    9.9 - Filter Function

  • 10.0 - Intermediate Excel Functions

    10.1 - Case Functions

    10.2 - Extraction Functions

    10.3 - Transpose Functions

    10.4 - Rearranging Functions

    10.5 - Date & Time Functions

    10.6 - Statistical Functions

    10.7 - Combinations & Split Functions

  • 11.0 - Conditional Formatting

    11.1 - Highlight Cells

    11.2 - Top & Bottom

    11.3 - Icon Sets & Data Bars

    11.4 - Heat Maps & Color Scales

    11.5 - Quick Analysis Tool

  • 12.0 - Pivot Tables

    12.1 - Understanding Pivot Tables

    12.2 - Creating Pivot Tables

    12.3 - Pivot Table Fields

    12.4 - Grouping Data

    12.5 - Formatting Data

    12.6 - Modifying Calculations

    12.7 - Creating Pivot Charts

    12.8 - Filtering Data

  • 13.0 - Lookup Functions

    13.1 - VLOOKUP

    13.2 - HLOOKUP

    13.3 - INDEX / MATCH

    13.4 - XLOOKUP

  • 14.0 - Analysis Tools

    14.1 - Analyze Data Tool

    14.2 - Goal Seek Tool

    14.3 - Scenario Manager

    14.4 - Geography Data Types

    14.5 - Stock Data Types

  • 15.0 - Workbook Overview

    15.1 - Reviewing Workbooks

    15.2 - Formula Auditing

    15.3 - Protecting Worksheets

    15.4 - Embedding Links

    15.5 - Importing & Exporting Data

    15.6 - Add-Ins

Including…

Practice Templates

Shortcuts Guide

100+ Course Videos

Function Library

If you’re ready to Easily (excel in) Microsoft Excel so you can level up in your career - let’s get started today!

Meet your instructor!

Senna Brennan!

Senna is a two time Microsoft MVP and the founder of Easily Excel, where she teaches Microsoft Excel to over 1 million users around the world!

In 2022, Senna took to social media and began sharing simple, comprehendible and impactful Excel tips and tricks. In just less than a year, she has created a community of over 1 million people across Instagram, TikTok and YouTube (@easilyexcel). Today, Senna teaches Microsoft Excel to individuals, businesses and organizations across the globe!

What students are saying…

  • "Your Excel course is a game-changer! The way you break down complex concepts into easily digestible chunks is remarkable. Your passion for the subject shines through, making the learning experience both enjoyable and effective. I feel empowered to tackle any Excel challenge now!"

    Ben Peyton

  • "I gotta hand it to you – your Excel course is straight-up awesome! You've got a serious gift for making even the most mind-numbing topics feel like a breeze. I mean, who knew learning about vlookups and pivot tables could actually be fun? You've totally revolutionized the way I approach Excel. Props to you!"

    Kathy Greenwich

  • "I'm blown away by the depth and breadth of your Excel expertise. You have a knack for anticipating the questions and challenges learners face, addressing them with clarity and precision. Your course has not only enhanced my Excel skills but also boosted my confidence in using the software. Highly recommended!"

    Lindsey Bauer

  • I must commend you on your exceptional Excel course. As someone who has always found the program quite daunting, I was pleasantly surprised by how easily I could grasp the concepts you presented. Your methodical approach and clear explanations have given me a newfound appreciation for the power of Excel. This course is an indispensable resource for anyone looking to master the software."

    Keith Gingrich

  • "I can't thank you enough for creating such a comprehensive and user-friendly Excel course. Your ability to demystify even the most complex features is remarkable. The practical projects you include reinforce the learning and make it easy to apply the skills in real-life situations. Your course has been a game-changer for my professional growth. Keep up the fantastic work!"

    Cait Hauk

FAQs

  • This course is for the beginner to intermediate level user. This course does not require any prior knowledge of Excel, as Part 1 starts from complete scratch. After a solid foundation is built in Part 1, Part 2 will take intermediate level users to the next level and provide you with tips and tricks to increase your efficiency in Excel.

  • The course consists of 15 modules, and each module is 30-60 minutes. You are welcome to complete the course at your own pace!

  • Yes, you will have lifetime access to all the courses along with all course materials.

  • All of the courses come with several templates and worksheets for each lesson! This makes the courses extremely interactive and thought provoking! All slides and worksheets are available for download.

  • Since all of these courses aim to enhance your business knowledge, the courses should all qualify for a tax write off. However, please confirm with your personal tax professional as I am not an accountant.

  • Yes! This course is compatible for PC and Mac devices and also contains keyboard shortcut guides for both PC and Mac. However, this course was created on a PC and uses PC shortcuts.

  • I have the utmost confidence in your ability to master Excel through this course. This program is designed for you to succeed, if you are willing to put in the work. For this reason, I do not offer refunds.

    I am happy to answer any questions you have at contact@easily-excel.com

If you’re ready to Easily (excel in) Microsoft Excel so you can level up in your career - let’s get started today!