Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 44 Minute(s)
Language
English
Taught by
Stanley Ka
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
2 views
Course Overview
Microsoft Excel (2007, 2010, 2013, 2016)
• Learn from an experienced consultant with over 10 Years of MS Excel and MS Access experience
• Hands-on practical exercises that you can use in real life and on the job.
• Beginner and Intermediate concepts covered
• Useful for Excel Beginners, College and University Students, and New Job seekers who would like to improve their skills
Course Content
- 12 section(s)
- 36 lecture(s)
- Section 1 Introduction
- Section 2 Formatting Data
- Section 3 Conditional Formatting
- Section 4 Working with Cells
- Section 5 Excel Functions and Series
- Section 6 Sort and Filter
- Section 7 Pivot Tables: Summarizing Data
- Section 8 Working with Text
- Section 9 Intro to Charts
- Section 10 IF Function: Evaluating Numbers, Text, and Logical Statements
- Section 11 Intermediate Concepts
- Section 12 Excel Shortcuts
What You’ll Learn
- Formulas and Functions
- Sorting Data Quickly
- Filtering Data
- Conditional Formatting (Highlighting information if a certain condition is met)
- Working and Manipulating Text (Working with Names, Addresses, and Other Customer Data)
- Summarizing Data through Pivot Tables (Summarize a client base quickly and draw conclusions)
- Pulling Data from a different database (HLookup and VLookup Functions - Merging Customer Data)
- How to evaluate logical statements quickly and efficiently (IF Functions and variations)
Skills covered in this course
Reviews
-
SSJ Almand
THE LESSONS ARE GOOD BUT SOME OF THE RESOURCES COME READY POPULATED AND THEREFORE ARE NOT INTERACTIVE. RATHER DISAPPOINTING.
-
JJob Yuya Ndombasi
Well I do have experience with it, but the basics are fully covered and carefully explained on a way that any levels of experience may enrol this course. And it does indeed offer some really cool and helpful problem solving methods that you can rely on.
-
DDarshana Kashyap
The experience with the tutorials was really nice, the method chosen to explain every details was much appreciated.
-
VVishwanath Biswal
Wonderful..!! Earlier, I was a not aware of Excel, and this tutorial taught me a lot. I like the way of teaching, because Stanley ka taught each and every concepts from the very basics. Thank you.
