Accelerated Beginner Essentials

Overview:

This on-demand course is designed to give the viewer a grounding in some important fundamentals that will lead to robust spreadsheet work as they increase their proficiency. It assumes that the viewer has some basic exposure to Excel already but has not yet explored all the nuances of formula building, functions, productivity techniques etc. It should take around 3.5 hours of straight viewing or more time if the viewer chooses to practice along with the supplied data.

Course Content:

In this course, you will gain knowledge about the following topics:  

• Exploring important fundamentals about the interface and how to work quickly with mouse actions
• Taking a look at the importance of numbers and number formats
• Introduction to formulas and functions – discrete sums, continuous ranges, relative and absolute referencing in formulas
• Working with useful everyday functions like the COUNT, COUNTA, AVERAGE and more, and introducing the logical IF
• Building formulas across sheets, using Autoseries, Paste Special, and important output considerations

Learning Objectives:

Upon completing this course, you will be able to:

• Learn new chart types introduced in later versions of Excel and some of their uses in a Finance Management context
• Learn how to create these new chart types
• Learn the enhancements introduced to existing charting capabilities in later versions of Excel

Who Will Benefit: 

Those who have used Excel in small ways but yet to explore the power of its formula building capabilities or who may be self-taught in spreadsheets but want to get some fundamentals clear. Also useful to managers who want to bring staff up to a certain acceptable level of spreadsheet proficiency.