Brief Introduction
A hands-on Microsoft Excel course for people who know Excel basics and wish to become more confident Excel users.Description
This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using Microsoft Excel. It provides step-by-step practice in building Excel formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS.
The course also covers Excel charts, sparklines, conditional formating, and graphics. It then moves on to look at all of Excel's key facilities for working with tabular data: customized sorting and filtering, subtotalling and the use of Excel tables and pivot tables.
All of the Excel worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.
Last course update: December 2016
In the most recent update to this course, you will construct a basic invoicing system and at the same time get a chance to practice using advanced formulas, data validation and worksheet protection.
Requirements
- Requirements
- To complete this course, students will need to have a copy of Microsoft Excel 2013 installed on their PC. If you do not own a copy, why not download the 30 day trial version of Excel 2016 from Microsoft's website. (The differences are not significant.)
Power Pivot Workshop Complete Bundle
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn to master Power Pivot for Excel and DAX. This bundle includes three courses: Beginner, Intermediate, and Advanced. The Advanced course enables you to master Power Pivot for Excel....
Excel Intermediate Workshop
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A hands-on Microsoft Excel course for people who know Excel basics and wish to become more confident Excel users. The course also covers Excel charts, sparklines, conditional formating, and graphics....
