Excel 2013 Intermediate
English | 2016 | mp4 | H264 1280x720 | AAC 2 ch | 5.5 hrs | 2.03 GB
eLearning, Office Productivity, Microsoft | Skill level: Intermediate Level
An accessible course for people who know Excel basics and wish to extend their skills and become more confident users.
This is a practical, hands-on course for Excel middleweights looking to gain more confidence in using the program. It provides step-by-step practice in building 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 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 worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.
What are the 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.)
What am I going to get from this course?
- Over 64 lectures and 5.5 hours of content!
- Use Microsoft Excel 2013 more confidently and effectively, gain a deeper insight into functions, formulas, charts and pivot tables.
What is the target audience?
- This course is suitable for those with a basic knowledge of Excel, who have perhaps had some basic training in using the program, or those who are self-taught.