Microsoft Excel for Business Accounting


get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon