Nigeria's free digital learning hub. Videos, lecture notes, practice questions and leaderboards aligned with CCMAS, NBTE, NCCE, WAEC, NECO, IJMB and JAMB curricula.
Loading
Nigeria's free digital learning hub. Videos, lecture notes, practice questions and leaderboards aligned with CCMAS, NBTE, NCCE, WAEC, NECO, IJMB and JAMB curricula.
Accounting · 200 Level
This is the complete lecture note for ACC 206 Accounting Laboratory, prepared for Accounting students at 200 Level. You can read it online below, open it in the full viewer, or download the PDF for offline study. It pairs with the course's video lectures, so you can read and watch together.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS COURSE CODE: ACC206 COURSE CODE: Accounting Laboratory COURSE UNIT LOAD (3 Units C: LH 15; PH 45) SERIES LIST Series 1: Spreadsheet Applications for Accounting Functions and Data Analysis Series 2: Cloud-Based Accounting Software and ERP Systems Series 3: Cash Management Tools and Audit Software Applications Series 4: Presentation and Reporting Tools for Accountants Series 5: Productivity and Collaboration Tools for Modern Accounting Practice Series 1: Spreadsheet Applications for Accounting Functions and Data Analysis Part 1: Fundamentals of Spreadsheet Use in Accounting Sub-Part 1.1: Introduction to spreadsheet tools Sub-Part 1.2: Basic functions and formulas for accounting tasks Sub-Part 1.3: Data organisation and formatting for financial records Part 2: Spreadsheet Functions for Data Analysis Sub-Part 2.1: Use of advanced formulas (e.g., IF, VLOOKUP, SUMIF) Sub-Part 2.2: Pivot tables and charts for financial analysis Sub-Part 2.3: Scenario analysis and forecasting with spreadsheets Part 3: Application of Spreadsheets in Financial Reporting Sub-Part 3.1: Preparation of financial statements using spreadsheets Sub-Part 3.2: Error checking and audit trails in spreadsheet models Sub-Part 3.3: Case studies of spreadsheet use in accounting practice Part 4: Spreadsheet Integration and Automation Sub-Part 4.1: Linking spreadsheets with other accounting tools Sub-Part 4.2: Use of macros for repetitive accounting tasks Sub-Part 4.3: Data validation and protection for accounting spreadsheets Introduction Spreadsheets have become indispensable tools in modern accounting practice. In the past, accountants relied heavily on manual ledgers and calculators, which made data entry and analysis both time-consuming and prone to error. Today, spreadsheets provide a flexible platform for recording transactions, performing calculations, and analysing financial data with speed and accuracy. Their relevance in this course lies in equipping you with practical skills that are foundational for more advanced accounting software and systems. The aim of this Series is to enable you to apply spreadsheet tools effectively for accounting functions and data analysis, so that you can prepare, organise, and interpret financial information with confidence. We shall commence this Series by exploring the fundamentals of spreadsheet use in accounting, including basic functions and data organisation. Next, we will examine spreadsheet functions for data analysis, focusing on advanced formulas, pivot tables, and forecasting techniques. Following that, we will move on to the application of spreadsheets in financial reporting, where you will learn how to prepare statements and check for errors. Finally, we will conclude with
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS spreadsheet integration and automation, covering macros, data validation, and linking spreadsheets with other accounting tools. Series 1: Spreadsheet Applications for Accounting Functions and Data Analysis Series Learning Outcomes By the end of this Series, you should be able to: SLO 1.1: Define the fundamental features of spreadsheet tools and explain their role in basic accounting functions. SLO 1.2: Apply spreadsheet formulas and functions to organise, calculate, and analyse accounting data. SLO 1.3: Design and interpret pivot tables, charts, and forecasting models for financial analysis. SLO 1.4: Prepare financial statements using spreadsheets and evaluate the accuracy of spreadsheet models through error checking and audit trails. SLO 1.5: Integrate spreadsheets with other accounting tools, automate repetitive tasks using macros, and implement data validation and protection measures. 1.1 Fundamentals Of Spreadsheet Use In Accounting 1.1.1 Introduction to spreadsheet tools Spreadsheets are digital tools designed to organise data in rows and columns, allowing users to perform calculations and create models. A **spreadsheet tool** is a software application, such as Microsoft Excel or Google Sheets, that enables accountants to record transactions, analyse figures, and prepare reports. These tools are widely used because they combine flexibility with accuracy, reducing the risk of manual errors. Diagram showing a spreadsheet interface with rows, columns, and formula bar. Figure 1.1 Spreadsheet interface overview Fill in the blank: A spreadsheet is organised into __________ and columns, which intersect to form cells. ---
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS 1.1.2 Basic functions and formulas for accounting tasks Spreadsheets provide built-in **functions**, which are predefined formulas that perform calculations automatically. For example, the **SUM function** adds a range of numbers, while the **AVERAGE function** calculates their mean. Accountants use these functions to total expenses, compute revenues, and determine profit margins. A **formula** is a user-defined expression that performs calculations, often combining functions with cell references. Table 1.1 Common spreadsheet functions for accounting Description: Table listing SUM, AVERAGE, IF, and VLOOKUP with their uses in accounting. Fill in the blank: The __________ function is used to add a range of numbers in a spreadsheet. ---
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS 1.1.3 Data organisation and formatting for financial records Accountants must present data clearly to ensure accuracy and readability. **Data organisation** refers to arranging information logically, such as grouping expenses by category or sorting transactions by date. **Formatting** involves adjusting the appearance of data, including currency symbols, decimal places, and cell colours. Proper organisation and formatting make financial records easier to interpret and reduce the likelihood of mistakes. Box 1.1 Tips for organising accounting data in spreadsheets Description: Box listing tips such as using consistent headings, applying filters, and formatting numbers as currency. Fill in the blank: Formatting numbers with __________ symbols helps accountants present financial figures correctly. ---
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS Pilot questions 1.1 1. Which of the following best describes a spreadsheet tool? a) A manual ledger b) A software application for organising and calculating data c) A typewriter for financial records d) A calculator 2. The SUM function in spreadsheets is used to: a) Calculate averages b) Add a range of numbers c) Sort data d) Format currency 3. What is the purpose of formatting in spreadsheets? a) To perform calculations b) To adjust the appearance of data for clarity c) To create new formulas d) To delete unnecessary records 4. Which of the following is an example of data organisation? a) Applying bold text to headings b) Grouping expenses by category c) Changing font colour d) Inserting a formula 5. A formula in spreadsheets is: a) A predefined function b) A user-defined expression combining cell references and operators c) A formatting tool d) A type of chart 1.2 Spreadsheet Functions For Data Analysis 1.2.1 Use of advanced formulas (e.g., IF, VLOOKUP, SUMIF) Spreadsheets provide advanced **formulas**, which are expressions that combine functions and cell references to perform complex calculations. The **IF function** allows conditional logic, meaning it can return one value if a condition is true and another if it is false. The **VLOOKUP function** searches for a value in a table and returns related information, while the **SUMIF function** adds numbers that meet specific criteria. These formulas are particularly useful in accounting for tasks such as calculating discounts, retrieving customer balances, or summing expenses by category.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS Table 1.2 Examples of advanced spreadsheet formulas Description: Table showing IF, VLOOKUP, and SUMIF with examples of accounting applications. Fill in the blank: The __________ function is used to search for a value in a table and return related information. --- 1.2.2 Pivot tables and charts for financial analysis A **pivot table** is a tool that summarises large amounts of data by grouping and aggregating information. Accountants use pivot tables to analyse sales by region, expenses by category, or revenues by product line. Pivot tables can be combined with **charts**, which are graphical representations of data, to provide visual insights. Charts such as bar graphs, line graphs, and pie charts make it easier to identify trends and patterns in financial data.
LA-NET | ONLINE LEARNING VIDEO PLATFORM FOR POST-SECONDARY & HIGHER INSTITUTION STUDENTS Diagram showing a pivot table summarising expenses by category with a linked bar chart. Figure 1.2 Pivot table and chart for expense analysis Fill in the blank: A pivot table is used to __________ and aggregate large amounts of data for analysis. --- 1.2.3 Scenario analysis and forecasting with spreadsheets **Scenario analysis** involves creating different versions of a financial model to test how changes in assumptions affect outcomes. For example, an accountant might model the impact of increasing sales prices or reducing costs. **Forecasting** uses historical data and formulas to predict future financial performance, such as projecting cash flows or revenues. Spreadsheets support these techniques through tools like data tables and goal seek, which allow users to explore “what-if” scenarios.
This is the opening of the note. Read the full note or download the PDF to continue.
