Intermediate Excel for Business Level II is the second of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level I or already have a basic working knowledge of excel and would like to improve efficiency and expand into Excel's more complex functions and data management features. By the end of this course, you will feel confident dynamically extracting data from large databases using advanced functions such as Vlookup, and quickly organizing and analyzing large amounts of raw data with Pivot Tables. The skills acquired in this course are what many employers have come to expect and look for in new applicants and existing employees.
Assign a name to a range of cells to reference that range in calculations
Create a dropdown menu to specify the inputs in certain cells
Use Remove Duplicates to eliminate duplicate data
NYIM is the premier computer software training company in NYC, with two decades of exceptional service provided to thousands of business professionals. NYIM's courses are taught by the leading industry professionals, with an engaging and interactive teaching approach. Our curriculums have been refined over years and focus on practical and hands-on applications for day-to-day business needs.