Course details
Take Your Microsoft Excel Skills To The Next Level
In this Excel 2013 tutorial course for Microsoft Excel 2013, an expert author takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic Excel operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. The author proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. The course also covers some basic Macro operations within Excel for optimizing your workflow.
By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. Working files are included, allowing you to follow along with the author throughout the lessons.
</p> Updated on 22 March, 2018- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Mastering Microsoft Office Academy for Health & FitnessUSD 13
USD 650Duration: Upto 8 Hours - Anatomy, Physiology of Human Body Diploma Alpha AcademyUSD 30
USD 750Duration: Upto 25 Hours
