10 Best Excel Training For Accountants

Updated on: May 2021

Best Excel Training For Accountants in 2021


Excel University: Microsoft Excel Training for CPAs and Accounting Professionals: Volume 1: Featuring Excel 2016 for Windows

Excel University: Microsoft Excel Training for CPAs and Accounting Professionals: Volume 1: Featuring Excel 2016 for Windows
BESTSELLER NO. 1 in 2021

Excel University Volume 1 - Featuring Excel 2013 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals (Excel University - Featuring Excel 2013 for Windows)

Excel University Volume 1 - Featuring Excel 2013 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals (Excel University - Featuring Excel 2013 for Windows)
BESTSELLER NO. 2 in 2021
  • Array

I Will Teach You Excel: Master Excel, surpass your co-workers, and impress your boss!

I Will Teach You Excel: Master Excel, surpass your co-workers, and impress your boss!
BESTSELLER NO. 3 in 2021

Excel: The Ultimate Beginners Guide: Learn Excel Today

Excel: The Ultimate Beginners Guide: Learn Excel Today
BESTSELLER NO. 4 in 2021

Excel VBA: for Non-Programmers (Programming in Everyday Language)

Excel VBA: for Non-Programmers (Programming in Everyday Language)
BESTSELLER NO. 5 in 2021

Accountant In Training: 2020 Planner For Accountant, 1-Year Daily, Weekly And Monthly Organizer With Calendar, Great Gift Idea For Christmas Or Birthday (8" x 10")

Accountant In Training: 2020 Planner For Accountant, 1-Year Daily, Weekly And Monthly Organizer With Calendar, Great Gift Idea For Christmas Or Birthday (8
BESTSELLER NO. 6 in 2021

Mastering Excel Made Easy - CPE Edition (Continuing Professional Education) Training Tutorial - versions 2010 through 97 for EAs/CPAs/Accountants v. 2.0

Mastering Excel Made Easy - CPE Edition (Continuing Professional Education) Training Tutorial - versions 2010 through 97 for EAs/CPAs/Accountants v. 2.0
BESTSELLER NO. 7 in 2021
  • 14 CPE hours for EAs & CPAs. Includes Deluxe Excel
  • tutorial, pracitce exams, final exam submission and
  • certificate of completion. 230 video lessons and three
  • classroom manuals walk you step-by-step through
  • software. Pass with 70% and receive your certificate for CPE!

Workout Log Book & Fitness Journal - 25-Week Designed by Experts, w/Illustrations : Track Gym, Bodybuilding & Crossfit Progress - Sturdy Binding, Thick Pages & Laminated, Protected Cover 1-Pack

Workout Log Book & Fitness Journal - 25-Week Designed by Experts, w/Illustrations : Track Gym, Bodybuilding & Crossfit Progress - Sturdy Binding, Thick Pages & Laminated, Protected Cover 1-Pack
BESTSELLER NO. 8 in 2021
  • GET FITTER FASTER (1-pack, 126 daily workout pages per book): Studies show tracking your progress with a fitness log can help you achieve your goals sooner and stay on course for the long term.
  • CREATED BY PROS: Your exercise log book was developed by people who know the science of working out. It's endorsed by personal trainers & military fitness experts.
  • DETAILED TRACKING: Record goals & starting / ending stats and track progress & workout frequency. Includes graphics that show which exercises target which muscles & a guide for measuring body fat.
  • QUALITY CONSTRUCTION: Not a flimsy notebook. Your activity diary is made with a sturdy wire binding, durable thick pages that won't tear & a thick cover with laminated protective coating..
  • WHETHER YOU'RE TRAINING, trying to lose weight or just want to be aware of your workouts, harness the power of journaling with this premium logbook from NewMe Fitness.

Advanced Excel

Advanced Excel
BESTSELLER NO. 9 in 2021

Mastering Excel Made Easy - CPE (Continuing Professional Education) Edition versions 2007 through 97 for EAs/CPAs/Accountants v. 1.0

Mastering Excel Made Easy - CPE (Continuing Professional Education) Edition versions 2007 through 97 for EAs/CPAs/Accountants v. 1.0
BESTSELLER NO. 10 in 2021
  • 14 CPE hours for EAs & CPAs. Includes Deluxe Excel
  • tutorial, pracitce exams, final exam submission and
  • certificate of completion. 230 video lessons and three
  • classroom manuals walk you step-by-step through
  • software. Pass with 70% and receive your certificate for CPE!

Step-by-Step Microsoft Excel Tutorial for Beginners

This tutorial is the quick and painless way to learning Microsoft Excel basics. You'll create a useful worksheet in just six short tasks.

EXCEL TASK #1

Your goal is to save a workbook in Microsoft Excel.

What is a workbook? It's an Excel file that consists of one or more worksheets.

What is a worksheet? It is a grid composed of cells. Cells are used to type in data, such as numbers or text.

Directions:

• Open Microsoft Excel.
• The Title Bar should read Microsoft Excel - Book 1. Book 1 is the name used when a workbook has not yet been saved. This reminds you save your file.
• Create a new folder named Excel in your main folder, if you need to do so. (Hint: either use an Exploring Window or the Save As Dialog Box.)
• Now it's time to save your new workbook as First Workbook into your Excel folder.
• Look at the Title Bar. Notice that it now shows your saved filename.

EXCEL TASK #2

Your goal is to enter data into cells and resize columns.

What are columns? Vertical (up and down) divisions named using letters. For example: cell A3 is column A, row 3.

What are rows? Horizontal (left and right) divisions identified by numbers.

Directions:

• Open the workbook previously saved in Task #1.
• Find the Worksheet Tabs (lower left area of the screen). Double-click the Sheet1 tab. Rename it Pay. Press the Enter key to set this name.
• Click on cell A2. Type: My Weekly Earnings
• Click on cell A4. Type: Paycheck Date
• Use the Tab key to move to cell B4. Type: Gross Pay
• Tab to cell C4. Type: Net Pay. Press the Enter key.
• Cell A4 isn't wide enough to fit all of its data. Also, cells B4 and C4 have extra space. Let's fix this.
• Select row 4 by clicking its Row Heading. This is the gray box to the left of the worksheet containing the number 4.
• Click on the Format menu (located on the Menu bar).
• Click on Column from its drop down list.
• Click on AutoFit Selection from second drop down list.
• Save your work.

EXCEL TASK #3

Your goal is to use a formula to calculate your net pay.

What is a formula? It's data that performs a calculation. The formula to compute net pay is gross pay minus gross pay times whatever percentage of taxes are taken out. An example looks like this: $400.00 - ($400.00 * .25).

Directions:

• Open your First Workbook file, if necessary.
• Click on cell A6. Type: 6/1/2020
• Press the Tab key to move to cell B6. Type: $400.00
• Press the Enter key.
• You should now be in cell A7. Type: 6/8/2020
• Press the Tab key to move to cell B7. Type: $300.00
• Press the Enter key.
• Click on cell C6. Type: =b6-b6*.25
• You've typed your first formula. This formula calculates $400.00 - $400.00 * 25%. Press Enter.
• Oops! The cell shows ##### because the cell is not wide enough to fit in the data. To fix this, make sure the cell is selected. Now you can AutoFit this column. (Review Task #2 if you've forgotten what to do.)
• You should see $300.00 in cell C6. This is the net pay.
• Save your work.

EXCEL TASK #4

Your goal is to copy a formula by using the fill handle.

What is a fill handle? It's a plus-sign shaped symbol in the lower right corner of an active cell. Clicking-and-dragging the fill handle can copy cell contents.

Directions:

• Open your First Workbook file, if necessary.
• You will copy the formula from cell C6 to C7.
• Click on cell C6 to make it active.
• Position the mouse pointer over the lower right corner of the cell.
• When you see the plus-sign shaped symbol click and drag to the lower right corner of cell C7.
• You should see the amount $225.00 in cell C7. This is the net pay for the paycheck dated 6/8/2020.
• Save your work.

EXCEL TASK #5

Your goal is to use the AutoSum button to quickly add up data in cells. In this task, you'll add the total amounts for gross pay and for net pay.

How does the AutoSum button work? Excel basically "guesses" which cells should be added. The cells all must be in the same row or column for this feature to work.

Where is the AutoSum button? Located on the Standard toolbar, this button looks like a fancy letter E.

Directions:

• Open your First Workbook file, if necessary.
• Click on cell A9. Type: Totals
• Tab to cell B9. Click the AutoSum button. Press the Enter key. The gross pay amounts are added together to equal 700.00.
• Click on cell C9. Click the AutoSum button. Press Enter. The net pay amounts are added together to equal 525.00.
• Save your work.

EXCEL TASK #6

Your goal is to merge and format cells. In this task, you'll make the title My Weekly Earnings centered with the rest of the worksheet and will change its text style.

What does it mean to merge cells? Merging cells allows two or more cells to become one big cell.

What's a text style? This is how text looks. Is it bold? Is it blue? Is it Arial font? Is it font size 12?

Directions:

• Open your First Workbook file, if necessary.
• Highlight cells A2, B2, and C2.
• Click on the Format menu and choose Cells from the drop down list.
• The Format Cells dialog box opens. Click on the Alignment tab.
• Click in the Merge cells check box. Click on OK.
• With the newly merged cell still selected, you'll use the Formatting toolbar to change the title's text style.
• Click on the Bold and Center buttons. Click on the Font Color button; choose a readable color. Change the font to Tempus Sans ITC. Make the font size 14.
• Save your work and admire the new look of your title (go ahead, stroke your ego; you deserve it).

Congratulations, you've just completed six basic tasks in Excel. Gook luck on your future endeavors in Microsoft Excel.