Excel specialists today, are considered a key component for the digital departments of every organization. The gig community is highly demanding these experts and having knowledge of Excel is undeniably necessary for everyone today. If you need efficient spreadsheets for work, or simply want to create them as useful tools in your daily life, this course is for you. The student learns how to create, edit and save a worksheet, how to create and edit charts, formulas, functions and many other advanced features. This course builds a deep understanding of advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
The course consists of one multiple choice quiz carrying a weight of 100% towards the final course grade. In order to successfully complete the course and obtain your certificate you need to achieve an overall grade of 50% or above at the quiz.
What will I learn?
Once you master this course you will be able to produce invoices and accounting statements, as well as set up pages, prepare outputs and also use complex formulas. You can even use spreadsheets to monitor your finances and keep track of your expenses. The organization of data and documents has never been so easy, or so efficient.
WEEK 1: Spreadsheet definition
This week covers how to work with spreadsheets, how to open, save and create a new spreadsheet.
WEEK 2: Operations on worksheets, formulas and functions
This week covers how to activate, insert, delete, rename, copy and move worksheets, how to use formulas and functions, the difference between the relevant and absolute cell referencing in formulas and functions.
WEEK 3: Charts and autoshape
This week covers how to create and edit charts, how to insert a picture or an AutoShape to a spreadsheet and how to prepare outputs.
WEEK 4: Final Quiz
This section is dedicated to your Course Evaluation.