Study Learn Grow
Microsoft Excel Micro Modules

Microsoft Excel Micro Modules

For each of the lectures there is a short video and an accompanying spreadsheet so that you can practice what you have learnt right away.

Overview

Description
This micro series will help you master Excel, the world's most popular and powerful spreadsheet software. The short videos contained within this module have been designed to provide you with short bursts of knowledge so that you can quickly put what you have learnt into practice.

For each of the lectures there is a short video and an accompanying spreadsheet so that you can practice what you have learnt right away.

Basic knowledge
This course begins at a very basic level and slowly moves to quite an advanced level so ultimately no prior knowledge of Excel is required
The only prerequisite for this course is to have access to Excel so that you can not only open some of the resources available but also so that you can practice what you will learn

Course Information

This course begins at a very basic level and slowly moves to quite an advanced level so ultimately no prior knowledge of Excel is required
The only prerequisite for this course is to have access to Excel so that you can not only open some of the resources available but also so that you can practice what you will learn

What will you learn
Starting with learning about the basic shortcuts within Excel and ending with advanced VBA, everything you will ever need to know about Microsoft Excel is covered in this course.

Through the course you will learn about below topics:

Use of graphs, different types of formatting, use of functions like if, nested if, text and numbers
Formatting themes, Vlookup functions
Managing data using excel functions like Pivot, filters, sub-totals, tables and slicers and validation
Advanced functions like Goal seek and solvers
Various VBA functions - if statement, loops, ranges, recording macros, running codes, variables
Tips and tricks of using excel efficiently saving time and doing your daily task with ease

The course has been developed for anyone who wants to learn MS Excel and VBA. And for even those who want to understand how Excel is used in Data Analytics

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs