Microsoft Excel Beginner To Professional

Course Line On Demand

• Disclaimer 01:00

  • 1: Disclaimer 01:00

• Introduction 00:44

  • 2: Lecture 1 - Introduction 00:44

• 5 Advanced excel formulas 19:34

  • 3: Lecture 2 - 5 Advanced excel formulas 19:34

• Excel Formulas for Job Interview 12:48

  • 4: Lecture 3 - Excel Formulas for Job Interview 12:48

• Date Function 09:31

  • 5: Lecture 4 - Date Function 09:31

• Creating Entry Bill 11:54

  • 6: Lecture 5 - Creating Entry Bill 11:54

• Excel Shortcut and Quick Navigation 09:33

  • 7: Lecture 6 - Excel Shortcut and Quick Navigation 09:33

• Excel Macro 17:39

  • 8: Lecture 7 - Excel Macro 17:39

• Excel VBA 10:13

  • 9: Lecture 8 - Excel VBA 10:13

• FV and PV 11:42

  • 10: Lecture 9 - FV and PV 11:42

• How to create Audit report 18:02

  • 11: Lecture 10 - How to create Audit report 18:02

• How to create monthly salary slip 20:20

  • 12: Lecture 11 - How to create monthly salary slip 20:20

• Index _ Match 11:56

  • 13: Lecture 12 - Index _ Match 11:56

• IRR 09:10

  • 14: Lecture 13 - IRR 09:10

• NPV 14:55

  • 15: Lecture 14 - NPV 14:55

• Offset and Match 14:49

  • 16: Lecture 15 - Offset and Match 14:49

• PMT _ building a complete Loan Schedule 11:32

  • 17: Lecture 16 - PMT _ building a complete Loan Schedule 11:32

• Vlook up and HLookup 11:23

  • 18: Lecture 17 - Vlook up and HLookup 11:23

• Vlookup and Choose 10:36

  • 19: Lecture 18 - Vlookup and Choose 10:36

• Vlookup and Coloums 11:58

  • 20: Lecture 19 - Vlookup and Coloums 11:58

• Vlookup and Indirect 11:37

  • 21: Lecture 20 - Vlookup and Indirect 11:37

• Vlookup and Match 12:33

  • 22: Lecture 21 - Vlookup and Match 12:33

• Assessment 16:00

  • 23: Final Exam 16:00

Microsoft Excel Beginner To Professional consists of a structured series of lectures followed by an assessment. Each lecture builds progressively, developing skills from basic spreadsheet use to advanced analysis and reporting techniques.

Lecture 1 introduces Microsoft Excel, covering the interface, basic navigation, and core spreadsheet concepts.

Lecture 2 focuses on advanced Excel formulas, introducing commonly used functions that improve efficiency and analytical capability.

Lecture 3 explores Excel formulas commonly used in job interviews, helping learners understand practical applications and problem-solving approaches.

Lecture 4 focuses on date functions, examining how dates are calculated, formatted, and used in analysis.

Lecture 5 examines creating entry bills, introducing structured data entry and calculation techniques.

Lecture 6 focuses on Excel shortcuts and quick navigation, supporting speed, accuracy, and efficient workflow.

Lecture 7 introduces Excel macros from an awareness perspective, explaining how repetitive tasks can be automated without providing programming authority.

Lecture 8 explores Excel VBA conceptually, introducing how automation and custom logic support advanced spreadsheet functionality.

Lecture 9 focuses on financial functions FV and PV, examining future value and present value calculations.

Lecture 10 examines how to create audit reports, focusing on data organisation, verification, and presentation awareness.

Lecture 11 explores creating monthly salary slips, introducing payroll-style calculations and structured reporting.

Lecture 12 focuses on INDEX and MATCH functions, examining advanced lookup techniques for flexible data retrieval.

Lecture 13 introduces IRR, focusing on internal rate of return calculations used in financial analysis.

Lecture 14 explores NPV, examining net present value calculations and investment evaluation awareness.

Lecture 15 focuses on OFFSET and MATCH functions, supporting dynamic data referencing techniques.

Lecture 16 examines PMT and building a complete loan schedule, introducing structured financial modelling concepts.

Lecture 17 focuses on VLOOKUP and HLOOKUP, introducing core lookup techniques used in data analysis.

Lecture 18 explores VLOOKUP with CHOOSE, examining alternative lookup strategies.

Lecture 19 focuses on VLOOKUP and columns, examining structured table-based data retrieval.

Lecture 20 explores VLOOKUP and INDIRECT, introducing flexible referencing techniques.

Lecture 21 examines VLOOKUP and MATCH, combining functions for advanced lookup solutions.

Certification

Upon successful completion of the Microsoft Excel Beginner To Professional course, learners receive a free digital certificate provided by Reed confirming course completion and knowledge achievement. A provider-issued course completion certificate is also available following verification of the Reed certificate. Learners may optionally order premium certificates and academic transcripts in hardcopy or softcopy formats for an additional cost. This course supports digital skill development, professional productivity, and analytical capability.

All certificates issued confirm participation and course completion only and do not represent a regulated qualification, professional licence, accounting certification, or authorisation to practise.

Microsoft Excel Beginner To Professional is suitable for learners with little or no prior experience in Microsoft Excel, as well as those seeking to advance existing spreadsheet skills. It is ideal for students, office staff, accountants, analysts, jobseekers, business professionals, and individuals working with data.

No formal qualifications or prior experience with Microsoft Excel are required to enrol on Microsoft Excel Beginner To Professional. Learners should have a basic to good standard of English, access to the internet, and a computer, tablet, or smartphone. Completion of the assessment is required to successfully finish the course.

Microsoft Excel Beginner To Professional can support progression into administrative roles, data support positions, finance and accounting support roles, business analysis functions, or further academic study where spreadsheet skills are required.