Overview

Easily learn the skills and knowledge you desire in excel for business accounting with our Microsoft Excel & Accounting Training, you get an unparalleled learning experience with us and you get a digital certificate, transcript and a student ID card all included with the course price.

What makes us the go to choice for people who want to learn about excel for business accounting is our dedication and commitment to providing you with the best service possible. You will get unlimited access to the Microsoft Excel & Accounting Training, no matter where you are in the world you will be able to access your Microsoft Excel & Accounting Training any time you want.

Should you have any questions while studying this Microsoft Excel & Accounting Training, our experienced tutors and mentors will answer them via email and live chat.

With the original certificate you get after completing your Microsoft Excel & Accounting Training you will gain the CPD qualifications that will help you succeed out in the world and in your career.

With our Student ID card you will get discounts on things like music, food, travel and clothes etc.

Enrol in our Microsoft Excel & Accounting Training today and start learning.

Why buy this Microsoft Excel & Accounting Training?

  1. Digital Certificate, Transcript, student ID all included in the price
  2. Absolutely no hidden fees
  3. Directly receive CPD accredited qualifications after course completion
  4. Receive one to one assistance on every weekday from professionals
  5. Immediately receive the PDF certificate after passing
  6. Receive the original copies of your certificate and transcript on the next working day
  7. Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Microsoft Excel & Accounting Training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8.

Who is this course for?

This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.

Prerequisites

This Microsoft Excel & Accounting Training was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Excel & Accounting Training is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

**Microsoft Excel**
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interfact 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Formatting a Worksheet
Apply Text Formats 00:16:00
Apply Number Format 00:07:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:08:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:09:00
Configure Headers and Footers 00:07:00
Managing Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:06:00
Working with Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
Working with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
Welcome to my course! 00:01:00
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Sharing and Protecting Workbooks
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Automating Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Creating Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
**Accounting Training**
Professional Bookkeeper Introduction
Professional Bookkeeper 00:09:00
Introduction to Accounting and Business
Defining a Business 00:07:00
Ethics in Accounting 00:05:00
Generally Accepted Accounting Principles (GAAP) 00:10:00
The Accounting Equation
The Accounting Equation 00:07:00
Transactions 00:11:00
Financial Statements 00:13:00
Analyzing Transactions
The Accounting Equation and Transactions 00:16:00
Double-Entry System 00:11:00
Transactions – Journalizing 00:16:00
Journal entries 00:07:00
Entering Information - Posting Entries
Posting Entries 00:10:00
The Trial Balance 00:10:00
Finding Errors Using Horizontal Analysis 00:09:00
Horizontal Trend : Balance Sheet 00:21:00
Horizontal Trend: Income Statement 00:36:00
Adjusting Process
The Purpose of the Adjusting Process 00:15:00
Adjusting Entries
Adjusting Entries – Prepaid Expenses 00:13:00
Adjusting Entries – Accrued Revenues 00:10:00
Adjusting Entries – Depreciation Expense 00:09:00
Adjustment Summary
Adjustment Summary – Review 00:13:00
Vertical Analysis 00:33:00
Preparing a Worksheet
Preparing a Worksheet 00:06:00
Financial Statements
The Income Statement 00:11:00
Financial Statements – Definitions 00:12:00
Completing the Accounting Cycle
Temporary vs. Permanent Account 00:19:00
The Accounting Cycle Illustrated
Accounting Cycle Illustrated – Steps 1-5 00:11:00
Accounting Cycle Illustrated – Steps 6-10 00:12:00
Fiscal Year
Fiscal Year 00:09:00
Spreadsheet Exercise
Spreadsheet Exercise – Steps 1-4 00:11:00
Spreadsheet Exercise – Steps 5-7 00:37:00

Studyhub Course Certification

Add a new crest to your professional endeavour now with successful completion of this resourceful course developed diligently by Studyhub. Upskill yourself with quality education, and attain this accredited certificate to manifest a rock-solid foundation of your knowledge. Enhance your CV, showcase this added glory with pride and confidence.

image

Setup Menus in Admin Panel