Excel for Business Level II - Intermediate (EXPRESS)

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.

Worksheet Management 
Navigation - Keyboard shortcuts that facilitate quick and easy navigation around the worksheet
Paste Special - Use Paste Special to apply formats, as well as perform calculations on selected cells
Text 
Splitting Text - Use Text to Columns to split text into multiple cells
Joining Text - Join text from separate cells
Database Management 
Named Ranges - Assign a name to a range of cells to to reference in calculations
Data Validation - Create a dropdown menu to make data entry quicker and more efficient
Sort & Filter - Use Sort & Filter to find and organize data in large databases
Remove Duplicates - Use Remove Duplicates to eliminate duplicate data
Database Functions 
Vlookup - Find information in one column and return information from another column
Logical Functions 
And & Or functions - Use AND/OR functions to determine whether cell(s) meet either or both criteria
IF statement function - Use IF statements to return output based on the contents of another cell
Statistical Functions 
Countifs function - Use Countifs function to count cells based on one or more conditions
Sumifs function - Use Sumifs function to sum cells based on one or more conditions
Pivot Tables 
Pivot Tables - Create Pivot Tables to quickly summarize large databases