Microsoft Excel Essentials (Bookkeeping & Accounting)

Microsoft Excel Essentials (Bookkeeping & Accounting), available at $64.99, has an average rating of 4.54, with 46 lectures, 4 quizzes, based on 518 reviews, and has 11546 subscribers.

You will learn about Microsoft Excel basics Subtitles/captions available in English, French, Hindi, Simplified Chinese, and Spanish Adding numbers, subtracting, multiplying, and dividing Using formulas to work with numbers Inserting columns and rows Using cell format (bold, font size, highlight, etc.) Using Format Painter to quickly copy cell formatting Using Wrap text in a cell Formatting numbers using dollar sign, percentage, decimals Conditional formatting to add colors to make sense of cell data Using charts (i.e. pie chart) to present your data Sorting and filtering numbers Using "Freeze Panes" to see columns and row headings VLookup, HLookup, Sumif Pivot Tables This course is ideal for individuals who are Beginner bookkeeping & accounting students or People who need to use Excel in their work or life It is particularly useful for Beginner bookkeeping & accounting students or People who need to use Excel in their work or life.

Enroll now: Microsoft Excel Essentials (Bookkeeping & Accounting)

Summary

Title: Microsoft Excel Essentials (Bookkeeping & Accounting)

Price: $64.99

Average Rating: 4.54

Number of Lectures: 46

Number of Quizzes: 4

Number of Published Lectures: 46

Number of Published Quizzes: 4

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Microsoft Excel basics
Subtitles/captions available in English, French, Hindi, Simplified Chinese, and Spanish
Adding numbers, subtracting, multiplying, and dividing
Using formulas to work with numbers
Inserting columns and rows
Using cell format (bold, font size, highlight, etc.)
Using Format Painter to quickly copy cell formatting
Using Wrap text in a cell
Formatting numbers using dollar sign, percentage, decimals
Conditional formatting to add colors to make sense of cell data
Using charts (i.e. pie chart) to present your data
Sorting and filtering numbers
Using "Freeze Panes" to see columns and row headings
VLookup, HLookup, Sumif
Pivot Tables

Who Should Attend

Beginner bookkeeping & accounting students
People who need to use Excel in their work or life

Target Audiences

Beginner bookkeeping & accounting students
People who need to use Excel in their work or life

In this course you will learn the basics of Microsoft Excel as quickly as possible. By the end of this course, you will have a solid understanding of how to use basic functions of Microsoft Excel that you can apply to your professional or personal life.

You can use any version of Microsoft Excel to take this course, including Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.

Each lesson is around 3-5 minutes, and you can learn at your own pace.

WHAT STUDENTS SAY ABOUT THIS COURSE:

– “This is such a great course for beginners. It taught me so many new tricks to use Excel more easily.” – Nora A.

– “I enjoyed all the lessons. I felt like each one had at least one thing that I could take away from. I really enjoyed learning how to add charts and pivot tables to my spreadsheets for an easy summary of information. The sound quality was good. The instructor was clear and precise. The information was presented in a way that was easy to understand and also covered a vast amount of information. Definitely glad that I took this course. Would take another course provided by him, hands down.” – Brittany A.

– “Sum function, formatting numbers, mean, median, mode, and count, Sumif, VLookup and HLookup were the most helpful lessons for me. They taught me new lessons that will help me in the future. The lessons were very easy to follow. I would have Excel open and ready to input the same criteria when the video started, and could pause where I needed to do the exercises on my own.” – B. Alvarez

YOU WILL LEARN:

Navigating around Microsoft Excel
Entering text and numbers
Adding numbers (SUM function), subtracting, multiplying, and dividing
Correcting cells and moving around cells
Inserting columns and rows
Adding and deleting cell format (bold, font, etc.)
Using Copy, Cut, Paste, and Format Painter to quickly copy cell formatting
Paste Value using Paste Special
Wrap text in a cell
Formatting numbers using dollar sign, percentage, decimals
Conditional formatting to add colors to make sense of cell data
Using charts (pie charts, column charts, etc.)
Sorting numbers
Filtering numbers
Using Freeze Panes to see columns and row headings
Print Preview options to nicely print your Excel sheet
Using Sumif function to add cells based on criteria
Using VLookup function to quickly find data in a table vertically
Using HLookup function to quickly find data in a table horizontally
Using “If” function to test criteria
Using “Left” and “Right” functions to extract data from a cell
Removing duplicates in a range of data
Shortcut keys to quickly select a range of cells
Finding absolute value of positive and negative numbers
Pivot Tables to summarize your data
And much more!

WHY THIS COURSE?

Taught by a CPA, CA, MBA– Calvin K. Lee
Calvin is a top-rated instructor at Schulich School of Business at York University
Over 52,000+ students from 172 countries enrolled in his courses
Lifetime access to this course, and you receive new lessons and updates for FREE.
He has 15 years of experience in bookkeeping & accounting
He has worked in a Big 4 accounting firm (Ernst & Young)
Subtitles (captions) available in English, French, Hindi, Simplified Chinese, and Spanish
Certificate of Completion available
I guarantee you will learn Excel. If you aren’t absolutely satisfied, I’ll refund your money with a 30-day money-back guarantee

REGISTER FOR THIS COURSE NOW!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Microsoft Excel Basics

Lecture 1: How to make the most of this course (subtitles, speed up videos)

Lecture 2: Navigating around Microsoft Excel

Lecture 3: Entering text and numbers into Excel

Lecture 4: Adding numbers using the SUM function

Lecture 5: Subtract, multiply, and divide in Excel

Lecture 6: Correcting cells and moving around cells

Lecture 7: Inserting columns and rows in Excel

Lecture 8: Conditional Formatting to add colors to data

Lecture 9: Clear Formats and Clear Content in cells

Chapter 3: Formatting cells, Format Painter, Wrap Text

Lecture 1: Formatting cells in Microsoft Excel (Bold, borders, highlight, merge & center)

Lecture 2: Using Copy, Cut, Paste, and Format Painter to copy cell format

Lecture 3: Paste Values using Paste Special

Lecture 4: Using Wrap Text to wrap spill over text in a cell

Lecture 5: Formatting numbers using dollar sign, percentage, decimal points

Chapter 4: Excel Shortcuts, Mean/Median/Mode, Split Screen, Grouping Data

Lecture 1: Excel shortcuts – open/close/save spreadsheet, bold/italics, copy, paste, undo

Lecture 2: Excel shortcuts – Home tab, delete column, insert row, zoom

Lecture 3: Excel shortcuts – Tab, move to last cell, move to next worksheet, move down

Lecture 4: Mean, median, mode, count cells

Lecture 5: Split screen to work on different parts of the same Excel sheet simultaneously

Lecture 6: Grouping data (expand and collapse data)

Chapter 5: Charts, Sort & Filter, Freeze Panes View, Print Preview Options

Lecture 1: Using Charts (pie charts, column charts)

Lecture 2: Sort and Filters in Excel

Lecture 3: Using Freeze Panes in Excel to see column headings and row headings

Lecture 4: Absolute Reference to prevent cell reference from moving

Lecture 5: Print Preview options

Chapter 6: Useful functions: Sumif, VLookup, HLookup, If, Remove Duplicates

Lecture 1: Using "Sumif" function to add cells based on criteria you set

Lecture 2: Using VLookup function to find data quickly

Lecture 3: Using HLookup function to find data quickly

Lecture 4: Using "If" function to test criteria and give results

Lecture 5: Using "Left" and "Right" functions to extract data in a cell

Lecture 6: Remove duplicates in a range of data

Lecture 7: Shortcut keys to quickly select a range of cells

Lecture 8: Absolute value of numbers

Chapter 7: Pivot Tables: Summarizing Data and Finding Data quickly

Lecture 1: Pivot Tables overview: How to summarize data

Lecture 2: Pivot Tables: report filters and column labels

Chapter 8: More Useful Functions & Options

Lecture 1: Find & Replace options

Lecture 2: Sum, count, average, time, date functions

Lecture 3: Displaying cell formula (auditing cell formula)

Lecture 4: Sparklines to display trends inside a cell

Lecture 5: Text to columns (split first and last name into 2 cells)

Lecture 6: Concatenate function (merging 2 columns into 1 column)

Lecture 7: Flash fill (getting Excel to fill in information automatically for you)

Lecture 8: Countif function

Lecture 9: Protect sheet (prevent unauthorized or unwanted changes to an Excel sheet)

Chapter 9: More Resources

Lecture 1: Bonus lecture: additional resources to learn bookkeeping

Instructors

Calvin Lee, CPA, CA, MBA
Accountant, Bookkeeper, Business Consultant, Author

Rating Distribution

1 stars: 6 votes
2 stars: 5 votes
3 stars: 37 votes
4 stars: 159 votes
5 stars: 311 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu