This good course will update you on excel basics such as worksheets; entering values and formulas; data formats; saving and printing basics. You will have a broad knowledge of essential Excel formulas such as mathematical functions; textual functions; logical functions; and lookup functions - V Lookup; Hlookup; and Index match. This online course will equip you with knowledge of data tools; pivot tables; Excel charts; pivot charts; and named ranges. You will be adept at performing macros and advanced excel analytics after taking this course. By the end of the course; you will have a good understanding of excel shortcuts; macros; pivot charts; pivot tables; and excel charts.
At Knowledge Door, we provide a wide range of internationally recognised qualifications to industry standards, developed and supported by teaching and professional experts.
We’re partnered with some of the largest accreditors in the world, so wherever our students go and whatever they want to do, the certificates we provide are fully accepted by the industry.
Our professional qualifications address skills gaps and teach skills and knowledge that bring real value to businesses. But, we aren’t just focused on direct career advancement. We know that learning, no matter what it is, creates a foundation for personal development, so we offer a wide-ranging choice of subjects.