In a large worksheet, it is advantageous to be able to find specific data for display and/or use in calculations. LOOKUP, VLOOKUP, and HLOOKUP are functions in Excel that can help accomplish this. This half-day seminar will show you how to master these three functions – and produce amazing results.
See specific content information below in sections "Expected Outcomes" and "Attend and You Will Learn."
- Excel Level 1
- Excel Power BI Tools
- Excel Dashboards
- Excel Charts And Graphs
- Excel PivotTables
- Excel Power Pivot
- Excel Tips & Tricks
Who Should Attend
This course is designed for experienced Excel users who are seeking to advance their data analysis capabilities by using Excel's LOOKUP, VLOOKUP, and HLOOKUP functions.
Attend and You Will Receive
Upon successful completion of this course, you will receive a certificate of completion from NC State University.
To ensure your success in this course, you should have experience working with Excel. You should already understand spreadsheet concepts and be comfortable creating basic worksheets. You can obtain this level of skill and knowledge by taking Excel Level 1.
Attend and You Will Learn / Expected Outcome
Upon successful completion of this course, you will be able to use Excel's LOOKUP, VLOOKUP, and HLOOKUP functions to analyze your raw data.
Attend And You Will Learn
- Using VLOOKUP with other functions
- Shortcuts to use
- Case studies