Course details
Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX; will learn about data validation and database functions such as DSUM; will learn how to import and export data, and how to query external data bases.Course Outline
1 - Logical and statistical functions
Logical functions Math and statistical functions
2 - Financial and date functions
Financial functions Date and time functions Array formulas Displaying and printing formulas
3 - Lookups and data tables
Using lookup functions Using MATCH and INDEX Creating data tables
4 - Advanced data management
Validating cell entries Exploring database functions
5 - Exporting and importing
Exporting and importing text files Exporting and importing XML data Getting external data
6 - Analytical tools
Goal Seek and Solver The Analysis ToolPak Scenarios
7 - Macros and custom functions
Running and recording a macro Working with VBA code Creating functions Updated on 24 October, 2017
Course Location
About New Horizons Computer Learning Center
New Horizons is the world’s largest training provider with a global footprint of more than 300 locations in over 70 countries.They have more combined global training experience than any other training provider in the world as an industry leading training provider. The institute has been awarded more times
by major vendors than any other training organisation in the world.Their customers have a dedicated account manager who provides advice and guidance regarding training solutions and manages the relationship end-to-end.
Courses you can instantly connect with... Do an online course on Microsoft Excel starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Mastery (8-in-1) NextGen LearningAED 199Duration: Upto 20 Hours
- Free Excel 2019 Beginners eduCBAAED 77Duration: Upto 4 Hours
