Microsoft Excel - Core Skills
We get started with the basic features, enter values and learn to manipulate basic data, plus a few tips and tricks to assist productivity.
We work with some simple formulas, using addition, AutoSum & AutoFill. We learn about referencing, error management and simple formatting.
We then work with sheets management, use AutoFilters, lists and do some sorting. Customize the Toolbar, practice More Formatting with AutoFormat, Styles and AutoFit. Do more work with basic formulas, Format Painter & AutoFit. We then work with the managing page and print functions.
After this, we work with more formulas; referencing and adding values from other sheets, using 3D references and IF Statements. We create hyperlinks charts and graphs (Pie and Column and 2D graphs) and learn to make them look great!
