Microsoft Excel A-Z

4.5( 4 REVIEWS )
179 STUDENTS
Overview This beginner to expert course is designed to give students, not just the basic understanding of excel but also …

Overview

This beginner to expert course is designed to give students, not just the basic understanding of excel but also to teach them the various functions of excel, which will immensely benefit them at work. These include pivot tables, formulas, macros and VBA data analysis. Our objective is to make you an excel expert.

This course will fully prepare you for any Excel related career path, plus those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

It doesn’t matter if you are new to excel or are just looking to improve your excel skills- this course caters to both and after the completion of this course you will have full knowledge of the functionality of excel.

Why You Should Consider Taking this Course at Study365?

Study365 is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this accredited iAP course.  At Study365, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the training.  

Learners who register will be given excellent learning support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants. 

  • About the Tutor
  • Learning Outcome
  • Who is this qualification for?
  • Prerequisites to take the course
  • Method of assessment
  • Certification
  • Awarding Body
  • Prospective careers

Juan Galvan is a visionary, marketer and digital entrepreneur. He has been effective in enabling digital businesses to reach the next level of success. He believes in continued education and wants to share his extensive knowledge and experience as a coach, consultant and strategist with others. He aims to enable learners to expand their skill set in digital marketing, web development, programming and e-commerce. Juan Galvan will guide you to make critical business decisions, develop unique ways to deliver products in the marketplace and have clarity and confidence in your business.

  • Learn to master Excel from A-Z
  • How to save hours of time and boost your productivity in Excel
  • How to use math, statistical, logic and text functions
  • How to create basic and advanced formulas
  • Students who want to learn and master Microsoft excel
  • Professionals who require Microsoft excel for work.
  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy
  • basic computer skills

This is a knowledge-based course, and thus, will contain no method of assessment. 

Upon the successful completion of the course, learners will be awarded an accredited Certificate of 'Completion for Microsoft Excel A-Z' by iAP.

The International Awards for Professionals (iAP) is an awarding body established in 1999 that aims to promote a high educational standard. They hope to create online education that is trustworthy and credible. They are focused on raising the standards of online education, and ensuring it is accessible to all. The iAP provides accreditation for a range of educational establishments, and monitors and continually develops the educational standards of such institutions. Their globally recognised certifications allow learners to acquire the skills and knowledge needed to gain employment in the chosen fields. 

On successful completion of this course, learners will be able enter the relevant job market, with the confidence to explore a wide range of industry-related professions. You can study related courses that will open the door to new and exciting opportunities and enhance your expertise in this subject, and add this as a skillset on your resume. Your skills will be recognised by top employers and organisations that will enable you to land a generous-paying job, gain plenty of benefits, and a wide array of opportunities. Given below are job titles you can compete for.

  • Excel Programmer
  • Accountant
  • Financial Analyst

Course Curriculum

1. Excel From A-Z Course Introduction
1.1. Excel from a-z course section overview FREE 00:03:00
1.2. What is microsoft excel? FREE 00:04:00
1.3. Who is this course for FREE 00:04:00
1.4. Microsoft excel marketplace FREE 00:04:00
1.5. Excel job opportunities FREE 00:03:00
1.6. Excel job types FREE 00:04:00
2. Getting Started With Excel
2.1. Finding & opening excel 00:01:00
2.2. Excel’s start screen 00:03:00
2.3. Explaining the excel interface 00:03:00
2.4. Excel interface continued 00:01:00
2.5. Excel workbook vs excel worksheet 00:02:00
2.6. Saving & opening excel documents 00:04:00
2.7. Customizing the quick access toolbar 00:02:00
2.8. Customizing the excel ribbon 00:03:00
2.9. Excel shortcut keys 00:02:00
3. Values Referencing And Formulas
3.1. Creating excel labels 00:03:00
3.2. Entering numeric date in excel 00:03:00
3.3. Formatting date values in excel 00:05:00
3.4. Building basic formulas in excel 00:05:00
3.5. Order of operation 00:06:00
3.6. Relative vs absolute cell references 00:07:00
4. Introduction To Excel Functions
4.1. Excel functions explained 00:03:00
4.2. The sum() function 00:08:00
4.3. The min() and max() function 00:04:00
4.4. The average() function 00:02:00
4.5. Count() functions 00:05:00
5. Adjusting Excel Worksheets
5.1. Moving & copying data 00:07:00
5.2. Insert & delete rows/columns 00:05:00
5.3. Adjusting the width & height of cells 00:05:00
5.4. Hiding and unhiding excel rows and columns 00:04:00
5.5. Renaming, moving & deleting excel worksheets 00:05:00
5.6. Adding protection to specific cells 00:04:00
5.7. Protecting the structure of a workbook 00:02:00
5.8. Adding a workbook password to open file 00:02:00
6. Visually Pleasing Cell Formatting
6.1. Formatting fonts and cell background color 00:05:00
6.2. Adding cell borders 00:05:00
6.3. Formatting data appropriately 00:05:00
6.4. The magic behind excel’s format painter 00:04:00
6.5. Creating styles for formatting efficiency 00:06:00
6.6. Merging cells for a cleaner look 00:03:00
6.7. The power of conditional formatting 00:06:00
7. How To Insert Images And Shapes!
7.1. Grab user’s attention using illustrations 00:09:00
7.2. Customizing icons 00:05:00
7.3. Create compelling graphics with smartarts 00:06:00
8. Visualize Data With Charts
8.1. The commonly used column chart 00:03:00
8.2. Changing the chart design 00:02:00
8.3. Formatting elements of a chart 00:06:00
8.4. Modifying the data, type and location of a chart 00:06:00
8.5. Little slice of pie charts 00:05:00
9. Excel’s Printing Options
9.1. Print preview options 00:04:00
9.2. Excel page layout view 00:07:00
9.3. Printing a specific range of cells 00:03:00
9.4. Converting spreadsheets to pdf files 00:02:00
10. Benefits Of Using Excel Templates
10.1. Why create an excel template 00:01:00
10.2. How to create an excel template 00:05:00
11. Working With Excel Datasets
11.1. How to prepare data for analysis 00:04:00
11.2. How to sort data in excel 00:03:00
11.3. Multi-level sorting 00:03:00
11.4. Custom sorting datasets in excel 00:02:00
11.5. Applying filters to datasets 00:05:00
11.6. Creating subtotals within a dataset 00:06:00
11.7. Converting datasets into tables 00:06:00
11.8. Finding & removing duplicate values 00:07:00
12. Excel Database Functions
12.1. The sumif() function 00:09:00
12.2. The dsum() function 00:08:00
12.3. The dsum() function cont. 00:07:00
12.4. The subtotal() function 00:06:00
13. Excel Data Validation
13.1. What is excel data validation? 00:02:00
13.2. Creating a drop down list with data validation 00:07:00
13.3. Different types of data validation 00:06:00
13.4. Adding custom alerts to data validation 00:07:00
13.5. Creating a dynamic drop down list 00:03:00
13.6. Complex validation: dependent dropdown list! 00:07:00
14. Excel Pivot Tables
14.1. Creating an excel pivot table 00:06:00
14.2. Modifying excel pivot tables 00:06:00
14.3. Grouping & filtering pivot table data 00:07:00
14.4. Drilling down in to pivot table data 00:02:00
14.5. Creating pivot charts & utilizing slicers 00:08:00
15. Excel’s powerpivot add-in
15.1. What is power pivot? 00:04:00
15.2. Activating the excel power pivot add-in 00:02:00
15.3. Creating relationships between data tables 00:06:00
15.4. Using data models to create pivot tables 00:05:00
15.5. How to create power pivot KPI’s 00:08:00
16. Excel Conditional Functions
16.1. Excel’s if() function 00:05:00
16.2. If() function with and() criteria 00:05:00
16.3. If() function with or() criteria 00:05:00
16.4. Nesting multiple if() functions 00:07:00
16.5. The countif() function 00:04:00
16.6. Key benefits of using named ranges 00:04:00
17. Excel’s Lookup Functions
17.1. The vlookup() function 00:09:00
17.2. The beauty of excel’s iferror() function 00:04:00
17.3. The hlookup() function 00:06:00
17.4. The index() function 00:05:00
17.5. The match() function 00:05:00
17.6. Index() and match() combined 00:05:00
17.7. Two-way lookup with index() and match() 00:04:00
18. Text Based Functions In Excel
18.1. Left(), right and mid() function 00:07:00
18.2. Extracting specific text using len() and search() 00:13:00
18.3. Combining text with concatenate() 00:06:00
18.4. Quick tips & other text based functions 00:06:00
19. Auditing Formulas & Custom Views In Excel
19.1. Tracing precedents and dependents in formulas 00:04:00
19.2. Showing formulas 00:02:00
19.3. Grouping data 00:03:00
19.4. 3D referencing in formulas 00:05:00
19.5. Utilizing the watch window in excel 00:03:00
19.6. How to freeze panes in excel 00:03:00
20. Excel’s “What If?” Tools
20.1. Excels scenarios manager tool 00:06:00
20.2. Goal seek in excel 00:06:00
20.3. Compare results with excel data tables 00:04:00
20.4. Solver tool 00:11:00
21. Welcome To Excel VBA!
21.1. The power behind excel VBA 00:03:00
21.2. A look inside the visual basic editor(VBE) 00:04:00
21.3. Recording a macro 00:09:00
21.4. Saving & opening a macro-enabled workbook 00:02:00
22. The VBA Language
22.1. Modules and procedures 00:07:00
22.2. Object methods and properties 00:06:00
22.3. Excel VBA variables 00:05:00
23. Writing VBA Code
23.1. Referencing a range 00:14:00
23.2. Inputbox & msgbox 00:06:00
23.3. Using variables in vba code 00:05:00
23.4. If then else statement 00:10:00
23.5. Worksheet functions inside vba 00:08:00
23.6. Creating user defined functions 00:09:00
23.7. User defined functions within vba scripts 00:06:00
24. Important VBA Tools And Logic
24.1. Find last row data 00:06:00
24.2. Find last column of data 00:03:00
24.3. With statement 00:05:00
24.4. Debugging and error handling 00:07:00
24.5. Debugging and error handling cont. 00:07:00
25. Excel VBA Loops
25.1. For next loop 00:09:00
25.2. Do until loop 00:06:00
25.3. For each loop 00:04:00
26. Triggering Macros
26.1. Assign macros to shapes 00:04:00
26.2. From controls vs activex controls 00:08:00
26.3. Worksheet events 00:04:00
26.4. Workbook events 00:03:00
26.5. Fun with VBA events 00:07:00
27. Excel User Forms
27.1. Creating an excel userform 00:03:00
27.2. Adding controls to userforms 00:10:00
27.3. How to show an userform 00:03:00
27.4. Passing textbox values to desired cells 00:07:00
27.5. Passing option buttons values to desired cells 00:07:00
27.6. Userform combo boxes 00:08:00
27.7. Clearing values from userform controls 00:03:00
27.8. How to close an userform 00:02:00
28. Starting A Career In Excel
28.1. Creating an excel resume 00:05:00
28.2. Getting started with freelancing 00:06:00
28.3. How to become an excel freelancer 00:05:00
28.4. Top freelance sites 00:05:00
28.5. Getting your first client 00:08:00
28.6. Personal branding 00:07:00
28.7. Networking do’s and don’ts 00:04:00
28.8. Importance of having a website 00:04:00
27.9. Userforms and protected sheets 00:05:00
Additional Materials
Additional Materials
Completion Certificate Request
Completion Certificate Request

Students feedback

4.5

Average rating (4)
4.5
5 Star
4 Star
3 Star
2 Star
1 Star
    J H

    Jo Houghton

    September 03, 2021
    New Business

    Advancing my Excel knowledge allowed me to start my new business with confidence.

    A O

    Ash Owen

    August 24, 2021
    Highly Appreciable

    I am not giving it 5 stars but reviewing this course as an easy-to-understand learning for everyone.

    B S

    Brook Shaw

    July 23, 2021
    Helped me a Lot

    Taking this course from your platform helped me streamline my automated processes in Excel.

    J C

    Jaden Carter

    June 14, 2021
    Very nice

    A useful course to learn Excel basics to advanced tricks. Full credit to you guys.

WhatsApp chat