- Duration / Course length: 33 Hours Start now
- Accredited by: CiQCPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Description:Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers.
Who is this course for?
This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application.
This course is for office professionals who want to nail all the meetings and projects at the workplace.
This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts.
Assessment:
At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
Certification:
After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.
COURSE CURRICULUM
Microsoft Excel for Beginners
- Module One - Getting Started
- Module Two - Opening Excel
- Module Three - Working with the Interface
- Module Four - Your First Worksheet
- Module Five - Viewing Excel Data
- Module Six - Building Formulas
- Module Seven - Using Excel Functions
- Module Eight - Using Quick Analysis
- Module Nine - Formatting Your Data
- Module Ten - Using Styles, Themes, and Effects
- Module Eleven - Printing and Sharing Your Workbook
- Module Twelve - Wrapping Up
- Activities- Microsoft Excel - Beginners Level
- Module One - Getting Started
- Module Two - Working with Permissions and Options
- Module Three - Sharing Workbooks
- Module Four - Performing Advanced Formula and Function Tasks
- Module Five - Working with Array Formulas
- Module Six - Working With Macros
- Module Seven - Working With Forms
- Module Eight - Applying Advanced Chart Features
- Module Nine - Working With Slicers and Timelines
- Module Ten - Working With Multiple Tables, Relationships and External Data
- Module Eleven - Working With PowerView
- Module Twelve - Wrapping Up
- Activities- Microsoft Excel - Intermediate Level
- Module One - Getting Started
- Module Two - SmartArt and Objects
- Module Three - Auditing
- Module Four - Creating Charts
- Module Five - Working with Charts
- Module Six - Creating Pivot Tables and Pivot Charts
- Module Seven - Macros
- Module Eight - Solving Formula Errors
- Module Nine - Using What If Analysis
- Module Ten - Managing Your Data
- Module Eleven - Grouping and Outlining Data
- Module Twelve - Wrapping Up
- Activities-Microsoft Excel - Advanced Level
Eligibility / Requirements
This course is available to all learners, of all academic ;However, an education and experience in accounting is an advantage.
Learners should be aged 16 or over to undertake the qualification.
Good understanding of English language, numeracy and ICT are required to attend this course.
About John Academy
John Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online course provider, we are aware of the fact that there are a lot of people out there who consider themselves to be very curious learners but the courses that they are interested in are not available at their convenient time and place. So, we have decided to give them a unique opportunity for them to learn and obtain necessary skills in a very convenient way at any time from anywhere.
Who We Are
We are an online course provider who wants to make sure that the students would be able to learn everything there is a need for them to learn regarding the course that they have enrolled in on our site. So, we see to it that they would be provided with the highest possible standard of online learning. That way, students would be able to use it in the real world – the employment world and at their desired field of interests.
Certification
After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days.
