Build Excel Spreadsheet for Work From Home Business Accounts

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course Description

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.

Expected Outcomes

  1. Creating and Re-naming Worksheets
  2. Grouping Worksheets (Copying Formula Across)
  3. Inserting Tables
  4. Creating Drop-down Lists Populated With Data
  5. Creating 'If Statements' (Formula)
  6. Creating 'SumIf Statements' (Formula)
  7. Using AutoSum
  8. Using Absolute Referencing
  9. Formatting a Worksheets Using Colours/ Borders/ Fonts
  10. Assigning Cell Formats
  11. Using Conditional Formatting
  12. Filtering and Sorting Information
  13. Using Shortcut Keys