Microsoft Excel Intermediate Course 306 – Functions & Cell Referencing

Description

This Excel Intermediate to advanced course follows on from Beginners Excel Course 303 which introduced you to how to use the keyboard, mouse and dialogue boxes to create and edit basic formulas.

In this course we go deeper and more complex using multiple sheets and sample data from real business case studies and using real practise exercise files which you can download and keep.

Topics include:

• Number and percentage formatting: Understanding the various ways of formatting, including percentages to better use them in formulas and functions.
  • Understand that cells can be formatted (even without data in them) so that when you enter data, it can look completely different to what you expected to see.
  • Cells can be formatted in such a way that even though you enter numbers, a date may be shown. Learn about why in this section.
• Relative and Absolute Cell references: Understand how relative cell referencing works to help you copy formulas and functions quickly.
  • Understand where they don’t work and why.
  • Absolute cell referencing is a powerful way to reduce the amount of calculations you have to create and can save several columns or rows of typing.
  • Learn the different types of and how to use absolute cell references in this section.
• Learn and understand fundamental mathematical functions that will help you perform most formulas and functions.
  • These are fundamental skills that will help make more complicated functions easier to understand.
• Learn how to combine two formulas into one and as a result write much better formulas and get to know the order of mathematical calculations.
• Using Functions like Maximum, Minimum and average
• Getting to know the “Insert Functions dialog box”,
  • how to search for a particular function and
  • the concept of “arguments” (or syntax) in functions and function categories such as financial, Date and time, maths and trig, etc.
• Learn and construct an IF Statement.
• Learn the uses for comments.
  • Insert comments that help to explain the purpose of a cell,
  • choose the size and location of the comments and control the way they appear on the spreadsheet.
  • Edit comments and change the formatting within a comment,
  • change the name of the person who made the comment, and
  • make sure that the comment appears all the time or only when you move the mouse to it.
• Show/Hide Columns/Rows: Learn how to hide columns or rows that contain confidential information.
  • print the spreadsheet out without the confidential information, but
  • use the confidential information to perform the necessary calculations.

This Microsoft Excel Charting Micro Course is included in the Microsoft Excel Intermediate Training Course Bundle.

For the full range of skills in using Microsoft Excel explore the COMPLETE Excel Course Package