-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Microsoft Excel for Business Accounting
Microsoft Excel for Business Accounting
Original price was: £425.£29Current price is: £29. ex Vat
Take This Course OR
1 Year Access 
Beginner
19 Students -
1 day, 1 hour
Introduction
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.
Course description
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.
Course design
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
- Video lessons
- Online study materials
How is the course assessed?
This course does not involve any assessment.
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.
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 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.
Course Curriculum
| Excel Basics | |||
| 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 | ||
| Reuse Formulas | 00:30:00 | ||
| Manipulate Data | 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 Worksheets | 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 | ||
| Intermediate Functions | |||
| 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 | ||
| Create Charts | 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 | ||
| Advanced Features | |||
| 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 | ||
| Trace Cells | 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 | ||
| Create Sparklines | 00:15:00 | ||
| Create Scenarios | 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 | ||
| Consolidate Data | 00:15:00 | ||
| Link Cells in Different Workbooks | 00:15:00 | ||
| Merge 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 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
Related Courses
Important Links
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.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add