Excel Lessons – Zero to Hero for Teachers and Office Workers

Microsoft Excel Made Easy - VLOOKUP, Excel Formulas and Functions, Advanced Excel, Shortcuts, Tips & Tricks, Basic Excel

Created by: Onuzurike Chukwuagozie
Microsoft Excel Expert | Digital Marketer | IT Consultant

What Will I Learn?

• What to Expect - How to get the best from each class, what you will need, basic assumption.
• Introduction - Excel Workbook, Worksheet, Interface Explained (formula bar, rows, columns, name box ), Resizing rows and columns
• Cell Referencing made easy - Relative Cell Referencing and Absolute Cell Referencing
• Data Modelling Explained. Why is Excel Smart? Working with basic operators (+,*,/,-)
• Conditional Formatting of Cells in Worksheet
• Introduction to tables and charts - Design a budget template
• Charts in Excel - Bar chart, Pie chart, Line chart, Scattered (Bubble) charts
• Full chart customization, Chart elements explained, Chart styles, Format chart area
• Introduction to excel functions - SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, COUNTBLANK
• Working with Text functions I - "CONCATENATION" and "&" operator
• Working with Text functions II - LEFT, RIGHT, UPPER, LOWER, PROPER, LEN, MID
• Data Sorting, Data Filtering, Freeze Panes
• Carry out Searches and Query in Excel
• Smart Excel tips and skills to speed up workflow inthe work place
• Lookup functions in Excel - Vertical lookup (VLOOKUP) and Horizontal lookup (HLOOKUP)
• Logical Excel Functions - IF, OR, AND, Nested IF
• Data summary in Excel - SUMIF, COUNTIF, SUMIFS, COUNTIFS
• Using PIVOT tables as a tool to summarize data - Dicing and slicing
• Data Sharing and Data Tracking in Excel - Working with comments and changes made
• Budget Estimates, Financial modeling, Setting up payment schedule (loan amortization)

Requirements

• You will need a Laptop or a PC with any version of Excel installed in it
• No prior Excel knowledge is needed.
• A relaxed mind because Excel is about to be made EASY...hahaha

Target audience

• Anyone curious to master excel from scratch (beginner to Advanced level) in short span of time
• Anyone who uses Excel for work or personal needs such as Sales Manager, Individual, Accountants ,Auditor, Financial Analyst, Information Clerk, Secretaries
• Primary teachers
• Secondary teachers
• Subject teachers
• Students of all levels (Primary, Secondary, Tertiary)
• IGCSE and A' Levels Candidates