arrow-right cart chevron-down chevron-left chevron-right chevron-up close menu minus play plus search share user email pinterest facebook instagram snapchat tumblr twitter vimeo youtube subscribe dogecoin dwolla forbrugsforeningen litecoin amazon_payments american_express bitcoin cirrus discover fancy interac jcb master paypal stripe visa diners_club dankort maestro trash

Shopping Cart


Quick Start Excel: Creating An Accountancy Spreadsheet
Regular price Sale price
$49.00   $9.99

Quick Start Excel: Creating An Accountancy Spreadsheet


Unit price per

Microsoft's Excel 2016 for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a detailed Accountancy spreadsheet which is suitable for anyone who wants to take control of their finances. She covers how to create and format Excel tables, enter data, create drop-down lists, formulas (such as IF and SUMIF Statements), use data from different tables and worksheets, absolute referencing and conditional formatting - which will get you started quickly.

By the end of this intermediate course, Jennifer gets you feeling confident about creating your a detailed Excel spreadsheet.

What are the requirements?

  • Microsoft Excel (2010 or newer)

What am I going to get from this course?

  • Creating and Re-naming Worksheets
  • Grouping Worksheets (Copying Formula Across)
  • Inserting Tables
  • Creating Drop-down Lists Populated With Data
  • Creating 'If Statements' (Formula)
  • Creating 'SumIf Statements' (Formula)
  • Using AutoSum
  • Using Absolute Referencing
  • Formatting a Worksheets Using Colours/ Borders/ Fonts
  • Assigning Cell Formats
  • Using Conditional Formatting
  • Filtering and Sorting Information
  • Using Shortcut Keys

What is the target audience?

  • Beginner
  • Intermediate

Quick Start Excel: Creating An Accountancy Spreadsheet

Retail value $49.00