Scholar & Researcher Anton Du Plessis

Excel Skills Boost Scholar & Researcher Anton Du Plessis

Take your Microsoft Excel skills to the next level in one day! If you can spare one day, you will be able to lift your Excel skills and knowledge to the next level. If your time is limited, you can also gain the skills in a modular process by studying a chapter when you have time and completing the accompanying exercises. The skills taught in this book are generic Excel skills and you would be able to apply them to any version of Excel (2007,2010, 2013 or 2016). Some of the topics covered are: - Worksheet manipulations - Using the IF, AND and OR functions - VLOOKUP - Named Ranges - Conditional Formatting - Formula auditing - Pivot Tables - Text Functions - Data sorting - Sub-totalling - Auto filters - Charts - Data validation - Goal Seek - Keyboard Shortcuts