Skip to content

Accountancy & Excel Online Course

Beginner, Intermediate & Advanced | Free 2 Courses | Free PDF Certificate | Support |Practice Resources


Blackboard Learning

Summary

Price
£12 inc VAT
Study method
Online
Course format What's this?
Video
Duration
9 hours · Self-paced
Access to content
365 days
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

4 students purchased this course

Add to basket or enquire

Overview

During the Accountancy & Excel course, you’ll engage with knowledge, and real-life case studies as you develop practical skills and techniques for immediate application to accounting & Excel projects, or within your organization. You will benefit from the unique pedagogy and multidisciplinary approach of Blackboard Learning – an institution at the forefront of research and online learning – as you develop accounting & excel skills to better understand the preparing the income statement, Master depreciation model(how to use), and Excel from A-Z Course Introduction and the factors that contribute to career success and failure.

Throughout this Accountancy & Excel course, developed by industry experts you’ll get the opportunity to learn from experts with diverse experience. Guided by experts, Accountancy & Excel prepare you to become a change-maker with the skills to drive your career or organization forward.

Accountancy & Excel course will demystify accounting & Excel and give you the toolkit to make better contributions and become an even greater asset to your organization. It will also allow you to communicate more effectively and confidently about accounting & excel issues, whether it is relevant to your own business or outside your workplace.

After completing the Accountancy & Excel course from Blackboard Learning, you will be more skillful with more knowledge along with practical tips and advice, which will help you to learn the essential aspects of accounting & Excel. Skills development in accounting & excel lead you to career development in the accounting & excel sector.

Courses included in this Accountancy & Excel bundle course:

Enroll in Accountancy & Excel course and get started with the Accountancy & Excel journey!

This Accountancy & Excel course is a course consisting of 3 courses with many Accountancy & Excel related topics.

You will get in this bundle course-

Course 1: LEARN ACCOUNTING IN 1 HOUR

Course 2: Learn Depreciation accounting with Advanced Excel Model

Course 3: Learn Microsoft Excel from A-Z: Beginner To Expert Course

Certificates

Certificate of completion

Digital certificate - Included

Description

Accountancy & Excel contains important modules that teach learners about their professional needs and succession. In the United Kingdom, Blackboard Learning is one of the most popular online Accountancy & Excel course providers. You will get a solid foundation of knowledge about accounting & excel in this Accountancy & Excel course. You will be able to think critically about Accountancy & Excel and comprehend basic accounting & Excel theories and methods. This Accountancy & Excel course was created to provide you with the tools and methods you'll need to make a measurable effect in your career, whether your objective is to land a job, improve your abilities, or make a good influence in some other way.

Curriculum for Accountancy & Excel bundle courses:

Course 1: LEARN ACCOUNTING IN 1 HOUR

  • Describe and recognize the accounting underlying any set of financial statements.
  • Analyse business transactions to determine which are reportable and of those which are on account of income and which are on account of capital.
  • Prepare journal entries for common business transactions.
  • Post entries to create a general ledger and a trial balance using a spreadsheet.
  • Prepare the income statement,
  • Prepare the statement of changes in equity, and
  • Prepare the balance sheet.

Course 2: Learn Depreciation accounting with Advanced Excel Model

  • Definition of depreciation.
  • What is amortization?
  • What is depreciation?
  • What are the related terms(other terms) to depreciation?
  • Various methods of depreciation and depreciation accounting.
  • A most common method of depreciation.
  • Accounting for depreciation.
  • Depreciation and section.
  • depreciation tax shield.
  • depreciation tax under various depreciation methods.

Course 3: Learn Microsoft Excel from A-Z: Beginner To Expert Course

  • Excel from A-Z Course Introduction
  • Excel from A-Z Course Section Overview
  • What is Microsoft Excel?
  • Who This Course is For
  • Microsoft Excel Marketplace
  • Customizing the Excel Ribbon
  • Excel Shortcut Keys
  • Values, Referencing, and Formulas
  • Creating Excel Labels
  • The MIN() & MAX() Function
  • The AVERAGE() Function
  • COUNT() Functions
  • Adjusting Excel Worksheets
  • Moving & Copying Data
  • Insert & Delete Rows/Columns
  • Protecting the Structure of a Workbook
  • Adding a Workbook Password to Open File
  • Visually Pleasing Cell Formatting
  • Formatting Fonts and Cell Background Colour
  • Adding Cell Borders
  • Formatting Data Appropriately
  • The Magic Behind Excel's Format Painter
  • Creating Styles for Formatting Efficiency
  • Merging Cells for a Cleaner Look
  • The Power of Conditional Formatting
  • How to Insert Images and Shapes
  • Grab User’s Attention using Illustrations
  • Customizing Icons
  • Create Compelling Graphics with SmartArt
  • Visualise Data with Charts
  • The Commonly used Column Chart
  • Changing the Chart Design
  • Formatting Elements of a Chart
  • Modifying the Data, Type & Location of a Chart
  • Little Slice of Pie Charts
  • Excel's Printing Options
  • Print Preview Options
  • Excel's Page Layout View
  • Printing a Specific Range of Cells
  • Converting Spreadsheets to PDF Files
  • Benefits of Using Excel Templates
  • Why Create an Excel Template
  • How to Create an Excel Template
  • Working with Excel Datasets
  • How to Prepare Data for Analysis
  • How to Sort Data in Excel
  • Multi-Level Sorting
  • Custom Sorting Datasets in Excel
  • Applying Filters to Datasets
  • Creating Subtotals within a Dataset
  • Converting Datasets into Tables
  • Finding & Removing Duplicate Values
  • Excel Database Functions
  • The SUMIF() Function
  • The DSUM() Function
  • DSUM() Function Cont.
  • The SUBTOTAL() Function
  • Excel Data Validation
  • What is Excel Data Validation?
  • Creating a Drop Down List with Data Validation
  • Different Types of Excel Data Validation
  • Adding Custom Alerts to Data Validation
  • Creating a Dynamic Drop Down List
  • Complex Validation: Dependent Drop-Down List!
  • Excel PivotTables
  • Creating an Excel Pivot Table
  • Modifying Excel PivotTables
  • Grouping & Filtering PivotTable Data
  • Drilling Down into PivotTable Data
  • Creating Pivot Charts & Utilizing Slicers
  • Excel's PowerPivot Add-In
  • What is PowerPivot?
  • Activating the Excel PowerPivot Add-In
  • Creating Relationships between Data Tables
  • Using Data Models to Create PivotTables
  • How to Create PowerPivot KPIs
  • Excel's Conditional Functions
  • Excel’s IF() Function
  • IF() Function with AND() Criteria
  • IF() Function with OR() Criteria
  • Nesting Multiple IF() Functions
  • The COUNTIF() Function
  • Key Benefits of Named Ranges
  • Excel's Lookup Functions
  • VLOOKUP() Function
  • The Beauty of Excel’s IFERROR() Function
  • HLOOKUP() Function
  • INDEX() Function
  • MATCH() Function
  • INDEX() and MATCH() Combined
  • Two-Way Lookup with INDEX() and MATCH()
  • Text-Based Functions in Excel
  • LEFT(), RIGHT() and MID() Function
  • Extracting Specific Text using LEN() & SEARCH()
  • Combining Text with CONCATENATE()
  • Quick Tips & Other Text-Based Functions
  • Auditing Formulas & Custom Views in Excel
  • Tracing Precedents & Dependents in Formulas
  • Showing Formulas
  • Grouping Data
  • 3D Referencing in Formulas
  • Utilizing the Watch Window in Excel
  • How to Freeze Panes in Excel
  • Excel’s “What If?” Tools
  • Excel’s Scenario Manager Tool
  • Goal Seek in Excel
  • Compare Results with Excel Data Tables
  • Solver Tool
  • Welcome to Excel VBA!
  • The Power Behind Excel VBA
  • A Look Inside the Visual Basic Editor (VBE)
  • Recording a Macro
  • Saving & Opening a Macro-Enabled Workbook
  • The VBA Language
  • Modules and Procedures
  • Objects, Methods, and Properties
  • Excel VBA Variables
  • Writing VBA Code
  • Referencing a Range
  • Input Box & Msg Box
  • Using Variables in VBA Code
  • If Then Else Statement
  • Worksheet Functions inside VBA
  • Creating User-Defined Functions
  • User-Defined Functions within VBA Scripts
  • Important VBA Tools and Logic
  • Find the Last Row of the Data
  • Find the Last Column of the Data
  • With Statement
  • Debugging & Error Handling
  • Debugging & Error Handling Cont.
  • Excel VBA Loops
  • For Next Loop
  • Do Until Loop
  • For Each Loop
  • Triggering Macros
  • Assigning Macros to Shapes
  • Form Controls vs. ActiveX Controls
  • Worksheet Events
  • Workbook Events
  • Fun with VBA Events!
  • Excel User Forms
  • Creating an Excel User Form
  • Adding Controls to User Forms
  • How to Show a User Form
  • Passing Text Box Values to Desired Cells
  • Passing Option Buttons to Desired Cells
  • User Form Combo Boxes
  • Clearing Values from User Form Controls
  • How to Close a User Form
  • User Forms and Protected Sheets
  • Starting a Career in Excel
  • Creating an Excel Resume
  • Getting Started with Freelancing
  • How to Become an Excel Freelancer
  • Top Freelance Websites
  • How to Get Your First Client
  • Personal Branding
  • Networking Do's and Don'ts
  • Importance of Having a Website

Why Blackboard Learning:

Blackboard Learning is an online learning platform by which students from any corner of the world can learn his/her desired course. Using online learning, we assist students in realizing their full potential and advancing their careers. Today, our goal is to be the world's leading provider of online learning experiences with a global impact. By leveraging online learning, we assist students in preparing for bright futures in world-changing jobs. We provide a wide range of categories including Accounting & IT, Programming, Creative, and more. Our courses are designed to stretch students intellectually through state-of-the-art online learning.

Who is this course for?

This Accountancy & Excel course is for anyone looking to develop their skills and knowledge in accounting & excel related fields, as well as for those-

  • Want to enhance Accountancy & Excel-related skills and knowledge?
  • Use Accountancy & Excel-related knowledge in his career or profession.
  • Needs Accountancy & Excel-related skills for new job applications and opportunities.
  • Who wants to learn Accountancy & Excel and apply it in real life?
  • Anyone who wants to demonstrate Accountancy & Excel to prospective employers or jobs.
  • Anyone who wants to apply Accountancy & Excel related skills and dive into relevant career paths.

Requirements

Accountancy & Excel course does not require prior knowledge or experience, anyone with a PC, tablet, or mobile phone can do the Accountancy & Excel course. It would be ideal if the learner has:

  • An open mind, a spirit of self-inspection, and a willingness to improve himself/herself.
  • A desire to improve business (and personal) knowledge and skills.
  • The desire to elevate your skills in accountancy & Excel

Career path

Accountancy & Excel career path is exciting as it opens the doors to many professions related to accounting & Excel. Prospective Accountancy & Excel related careers paths include but are not limited to-

  • Accountant
  • Personal Development
  • Finance Executive

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.