This workshop focuses on some of the issues that novice users face when working with Excel with the objective of accelerating the progression to a proficient user. Specifically, this workshop introduces key concepts in formula building that are geared towards increasing speed and productivity in data analysis and in compiling and distributing reports. The workshop also introduces important areas of spreadsheet usage that are logical next steps in spreadsheet proficiency.
This workshop is designed to familiarize you with fundamental and core techniques in Microsoft Excel, designed to get a novice user up and running within a minimum period of time. The following chapters will be covered:
Effectiveness Booster – Using the New Interface – Installing or Locking Commands to the Ribbon Quick Access Toolbar
Important Concepts to Increase your Productivity – Adjacent and Non- Adjacent Selections, Date and Time Shortcuts, etc.
Understanding Data Types, Data Integrity and Errors in Data
Managing Data with Data Filters, Data Sort Methods – by Value and by Colour
Understanding Key Concepts in Formula Building – Data Referencing, Referencing Constants, Correctly Using Arithmetical Operators
Good Practice in Cell Referencing – Relative and Absolute References
Introduction to Functions and the Function Library Buttons
Introducing Key Functions – Min, Max, Average
Logical Functions – The Versatile and Widely Used IF Function
Key Charting Concepts – Important Chart Types and Variants
Key Concepts – Understanding Chart Components for Effective Charting
Building Professional Charts by Formatting Key Chart Components – Chart Area, Plot Area, Data Series, Data Labels and more