The Microsoft Excel for Business Accounting course is designed to help you in performing accounting functions such as budgeting, preparing financial reports or statements, planning and creating balance sheets with Excel.
With the help of this course, you will learn the fundamental spreadsheet functionality and the functions for performing complicated numerical calculations. This comprehensive course explains multiple add-ons for activities for example modelling and financial forecasting and smooth blends with external data to import and export crucial banking information and financial data to and from other accounting software programs.
Keeping with an understanding of how Excel and Excel function work in the accounting sector from this course, you will be able to work more confidently as well as achieve much with less trouble.
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 course does not involve any assessment.
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.
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 for Business Accounting 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.
|Create a Basic Worksheet||01:00:00|
|Use the Help System||00:30:00|
|Create Formulas in a Worksheet||01:00:00|
|Insert Functions in a Worksheet||00:30:00|
|Insert, Manipulate, and Delete Cells, Columns, and Rows||00:30:00|
|Search For and Replace Data||00:30:00|
|Spell Check a Worksheet||00:30:00|
|Apply Number Formats||00:30:00|
|Align Cell Contents||00:30:00|
|Apply Cell Styles||00:30:00|
|Define the Basic Page Layout for a Workbook||01:00:00|
|Refine the Page Layout and Apply Print Options||00:30:00|
|Format Worksheet Tabs||00:30:00|
|Manage the View of Worksheets and Workbooks||00:30:00|
|Customize Formula Options||00:30:00|
|Customize the Functionality of Excel by Enabling Add-Ins||00:30:00|
|Apply Range Names||00:30:00|
|Use Specialized Functions||00:30:00|
|Use Text Functions||00:30:00|
|Use Logical Functions||00:30:00|
|Use Lookup Functions||00:30:00|
|Use Date Functions||00:30:00|
|Use Financial Functions||00:30:00|
|Create and Modify Tables||00:30:00|
|Sort and Filter Data||00:30:00|
|Use Subtotal and Database Functions to Calculate Data||00:30:00|
|Modify and Format Charts||00:30:00|
|Create a Trendline||00:30:00|
|Create Advanced Charts||00:30:00|
|Create a PivotTable||00:30:00|
|Filter Data by Using Slicers||00:30:00|
|Analyze Data with PivotCharts||00:30:00|
|Preparing a Workbook for Multiple Audiences||00:30:00|
|Update Workbook Properties||00:15:00|
|Create and Edit a Macro||00:15:00|
|Apply Conditional Formatting||00:15:00|
|Add Data Validation Criteria||00:15:00|
|Troubleshoot Invalid Data and Formula Errors||00:15:00|
|Watch and Evaluate Formulas||00:15:00|
|Create a Data List Outline||00:15:00|
|Perform a What-If Analysis||00:15:00|
|Perform a Statistical Analysis with the Analysis ToolPak||00:15:00|
|Create Interactive Data with Power View||00:15:00|
|Link Cells in Different Workbooks||00:15:00|
|Export Excel Data||00:15:00|
|Import a Delimited Text File||00:15:00|
|Create a Web Query||00:15:00|
|Import and Export XML Data||00:15:00|