Microsoft Excel & Accounting Training
Microsoft Excel & Accounting Training
Original price was: £425.£29Current price is: £29. ex Vat
Save 93.18 % - ENDS SOON
OR
Or
Take All courses for £49
1 Year Access 
Level 3 - Diploma
360 Students -
17 hours, 58 minutes
Get access to 5000+ courses including this for
Descripting of Microsoft Excel & Accounting Training
The Microsoft Excel & Accounting Training program is created for future accountants and aims to bring about transformation. This thorough course combines key accounting principles with the powerful capabilities of Excel, giving you the resources to improve financial processes and boost data organization. Upon completion of this course, you will be able to proficiently use Excel and understand the complexities of accounting.
Participants of the excel for accountants training will master key functionalities such as performing calculations, formatting worksheets, and creating informative charts. Essential concepts like the accounting equation, transaction analysis, and financial statement preparation will be thoroughly covered. Additionally, you will gain proficiency in advanced Excel features, including PivotTables and formula auditing, enabling you to present financial data with clarity and precision.
This excel for accountants course provides a solid foundation for both beginners and those seeking to refresh their skills. Each session builds upon your knowledge, ensuring you are well-prepared to tackle any accounting challenge. Engage with this accounting Excel training to turn your aspirations into achievements with our tailored excel for accounting course.
Who is This Course for?
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.
Why study this course
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.
How is the course assessed?
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.
Will I receive a certificate of 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.
Career Path
On successful completion, learners will have the confidence and practical knowledge to pursue the following roles:
– Business Accountant
– Bookkeeper
– Finance Assistant
– External Auditor
– Chartered Accountant
Course Curriculum
| **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 | ||
| Order your Accredited Certificate directly from CPDQS | |||
| Order your Accredited Certificate directly from CPDQS | 00:00:00 | ||
| Trustpilot Review | |||
| Trustpilot Review | 00:00:00 | ||
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
