Brief Introduction
A keyboard-oriented course from beginner to professional level. Pivot tables, lookup functions, formatting and more.Description
If you're a beginner level (or intermediate level) Excel user, this course is for you. This course will introduce you to a range of skills and functions that are vital for any office job. Not only will this course make you more knowledgeable, it will make you a much faster Excel user too through a heavy focus on using the keyboard (instead of the mouse) wherever possible.
By the end of this course, the key skills that you will have learned are as follows:
Quickly format your Excel workbooks using a range of easy-to-remember keyboard shortcuts to improve the presentation of datasets.
Use advanced conditional formatting to quickly highlight entries in your dataset which match a range of criteria.
Use If functions and nested If functions to help you categorise your data.
Use a range of lookup functions (and combine them with the Match function) in order to quickly pull up relevant data in your Excel worksheet.
Use Pivot Tables to quickly extract insights from your dataset.
Learn mathematical functions and also learn how to conduct linear regression in your Excel workbook to measure and quantify relationships between variables.
Learn about financial functions in Excel which will then be applied to bond valuation problems.
The many uses of the Sumproduct formula.
You will be introduced to all these key skills and more through watching videos and you will have an opportunity to consolidate and apply these skills through a number of assignments (there are 7 main assignments) that are included in the course.
Requirements
- Requirements
- Have a Windows computer
- Have an edition of MS Excel that is, at least, as recent as MS Excel 2010 (this video series will use Excel 2016)
- No prior experience using Excel is required
Lean Management for Lean Six Sigma Training & Certification
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Accredited academic Lean Six Sigma White, Yellow, Green & Six Sigma Black Belt training and Lean Six Sigma certification Lean Management for Lean Six Sigma Training & Certification...
Call Center, The Essential guide
- 3.5
-
![]()
![]()
![]()
![]()
![]()
Learn how to thrive in a call center and run a call center with the help of the experience King. Course Description...
Microsoft Excel, Outlook and Word 2016 for Beginners
- 0.0
-
![]()
![]()
![]()
![]()
![]()
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes. Master the Ins and Outs of Microsoft Office 2016...
The Complete Train the Trainer Bootcamp (Part 1): All Levels
- 4.5
-
![]()
![]()
![]()
![]()
![]()
The Complete Classroom Training Mastery Certification Program That Doubles Learning Retention In Half The Time. This program dives deeply into the strategies and techniques you need to be an effective trainer....
