This 2-in-1 CPD bundle course program is designed to give our learners a more in-depth understanding of business accounting by equipping them with the skills to manage everyday accounting tasks by mastering Microsoft Excel.
Are you training to become a bookkeeper or accountant, but lack the necessary admin skills required for this role? The Microsoft Excel 2016 course is designed to help learners master Microsoft Excel for small business accounting to manage financial data more efficiently. This instructor-led training program starts by familiarising you with the interface, essential Excel functions, formulas, and commands. You will learn how to modify worksheets, use the lookup functions, share workbooks, calculate forecasts and much more.
Develop the necessary skills and knowledge to kickstart your career in the accounting sector with The Business Accounting Training course. This course covers the fundamental principles and practices of business accounting, with an in-depth look at the accounting life cycle. You will learn how to analyse transactions, prepare a trial balance, and use the accounting equation to make smarter financial decisions. On completion, you will have a solid understanding of accounting theory and practice.
Highlights
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
This bundle course certification is recommended for aspiring business accountants and bookkeepers, including those who are new to the finance sector. This is an entry-level course ideal for beginners who wish to gain the core skills and industry knowledge to fast track their career.
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Excel & Accounting Training is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
On successful completion, learners will have the confidence and practical knowledge to pursue the following roles:
**Microsoft Excel** | |||
Getting Started with Microsoft Office Excel 2016 | |||
Navigate the Excel User Interface | 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 | |||
Create and Modify Tables | 00:16: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:17:00 | ||
Journal Entries | 00:38: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 Accounts | 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 |
Scholarship: Score 80% or more in your final exam to get this Fee refunded.
Membership renews after 12 months. You can cancel anytime from your account.