Microsoft Excel for Business Accounting
Course
Online
Description
-
Type
Course
-
Level
Beginner
-
Methodology
Online
-
Duration
1 Year
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
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.
Facilities
Location
Start date
Start date
About this course
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.
Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification 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.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 5 years
Subjects
- Excel
- Import and Export
- Business Accounting
- Microsoft Excel
- Import Export
- Financial
- Export
- Import
- Financial Training
- Microsoft excel training
- MS Excel
Course programme
Excel Basics
- Create a Basic Worksheet
- Use the Help System
- Create Formulas in a Worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
- Manipulate Data
- Insert, Manipulate, and Delete Cells, Columns, and Rows
- Search For and Replace Data
- Spell Check a Worksheet
- Apply Number Formats
- Align Cell Contents
- Apply Cell Styles
- Define the Basic Page Layout for a Workbook
- Refine the Page Layout and Apply Print Options
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
- Customize Formula Options
- Customize the Functionality of Excel by Enabling Add-Ins
- Apply Range Names
- Use Specialized Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Date Functions
- Use Financial Functions
- Create and Modify Tables
- Sort and Filter Data
- Use Subtotal and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data with PivotCharts
- Preparing a Workbook for Multiple Audiences
- Update Workbook Properties
- Create and Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Consolidate Data
- Link Cells in Different Workbooks
- Merge Workbooks
- Export Excel Data
- Import a Delimited Text File
- Create a Web Query
- Import and Export XML Data
Microsoft Excel for Business Accounting