Microsoft Excel is a professional spreadsheet programme that is used to collate, organize and analyse data. It is the most widely used spreadsheet software in the world today, such that a proficient understanding of how to use Excel is no doubt an added advantage to anyone in this computer age. If you are looking to improve your Excel skills, then this course is for you.
Many consider excel to be cumbersome and its wide range of formulas, cell structure and analysis functionalities can easily discourage or overwhelm a new user. This course breakdown the seemingly cumbersome functionalities and features of Excel in such a way that makes it easy for anyone to understanding. So irrespective of your background in data analysis or whether you’re a newbie to the programme, this course will take you from a novice to a proficient user of Microsoft Excel.
What You’ll Learn in this course
- The basic interface of Excel
- Tabs, Ribbons, Groups and Launch buttons
- How to reference a cell
- The various methods for modifying and adjusting cells
- The basic tabs in Microsoft Excel, their functionalities and usage
- How to create and edit tables, charts and shapes in your spreadsheet
- How to apply and modify formulas
- The various fill options and how to use them effectively
- How to easily conduct quick analysis in Excel
- How to save and export your workbook in various formats
- Handy tips to boost your efficiency
- Keyboard shortcuts in Excel
- You will also be engaged in an exercise section that will involve using some of the data analysis tools that you’ve learnt to create a financial report.
This course includes:
- 6 HD videos (covering the 5 episodes of the course and an introductory section)
- An Excel 101 workbook containing various data sets that will be used during the course
- A pdf file with more than 30 Excel keyboard shortcuts
- An Excel exercise file workbook that will be used during the exercise section of the course
- A completed financial report for reference during the course
Additional information
- This course was created using Microsoft Excel 2019, however, if you are using a 2016, 2013 or 2010 version, you will still be able to easily follow along. If you’re using Excel 2007, there might be a few disparities, but the basic functionalities will still be the same.
- The course is completely downloadable and is about 418MB.
- Free consultation is provided during and after the course
For any questions on this course, feel free to send an email to hello@empricon.com
