Microsoft Excel for Business: Formulas, PivotTables and Dashboards
Description
Excel is the most widely used business tool after email. Almost every office job, from administration to finance, sales and operations, expects you to use it with confidence.
This course is practical from the first lesson. You will work with one realistic dataset: the monthly sales of a small online shop. Step by step you will tidy the data, calculate totals and commissions, look up product information, summarise results with PivotTables and present them in a one-page dashboard that a manager can understand in seconds.
You will also learn the habits that separate a professional spreadsheet from a fragile one: clean structure, clear formulas and simple checks that catch mistakes.
Features
- 12 practical lessons built on one sales dataset
- Formula explanations with real business examples
- Step-by-step PivotTable and dashboard build
- Keyboard shortcuts that save hours
- 4 section quizzes
Target Audiences
- Office and administrative staff
- Small business owners tracking sales and expenses
- Job seekers who need Excel for interviews and daily work
Requirements
- Microsoft Excel (Microsoft 365 or Excel 2021 recommended)
- Basic computer skills
- No previous Excel experience needed
Curriculum
- 3 Sections
- 9 Lessons
- 3 Weeks
Expand all sectionsCollapse all sections
- Working Smart in Excel4 ItemsStructure, navigation and clean data
- Formulas Employers Expect4 ItemsCalculations, logic and lookups
- PivotTables and Charts4 ItemsSummarising and visualising data
FAQs
Yes. Excel for Mac supports everything in the course. A few keyboard shortcuts differ, and the course notes them where it matters.
Most lessons work in any recent version. XLOOKUP and dynamic array functions such as FILTER and UNIQUE need Excel 2021 or Microsoft 365; alternatives are shown.
No. Excel does the calculations. You learn how to ask the right questions and structure the data.
Instructor
5 Students22 Courses
Reviews
Students List
You might be interested in
-
Intermediate
HK$1,890.00
-
0 Students
-
12 Lessons
Run a Windows business network with confidence: install and manage Windows Server, design Active Directory, control users and computers with...
-
Intermediate
HK$2,990.00
-
0 Students
-
15 Lessons
-
Intermediate
HK$2,990.00
-
0 Students
-
15 Lessons
A complete bootcamp for your first security role: threats and attack techniques, logs and SIEM, alert triage, phishing and malware...
-
Intermediate
HK$1,690.00
-
0 Students
-
12 Lessons
-
Intermediate
HK$1,690.00
-
0 Students
-
12 Lessons
Understand how networks really work: the OSI and TCP/IP models, IP addressing and subnetting, switching, routing, Wi-Fi, DNS and DHCP,...
-
Beginner
HK$990.00
-
0 Students
-
12 Lessons
Learn how real help desks work: ticket handling, troubleshooting Windows and network problems, user accounts, and the communication skills that...
HK$790.00
Sign up to receive our latest updates
Beginner