Build Excel Spreadsheet for Work From Home Business Accounts

Udemy Certificate USD 29.99
Enroll now →
Build Excel Spreadsheet for Work From Home Business Accounts

About this course

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 you'll learn

  • create and format Excel tables
  • enter data and create drop-down lists
  • use formulas like IF and SUMIF
  • manage data across different tables and worksheets
  • apply absolute referencing and conditional formatting

Skills you'll gain

Related courses

Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.