Excel Level 2

Service Description

Microsoft Excel Level 2 (2016, 2019, Office365) Course Description Upon successful completion of this course, you will be able to leverage the power of data calculations and presentation to make informed, intelligent organizational decisions. You will work with functions and lists, create advanced formulas, protect your spreadsheets and work with custom view. Course Content Creating Advanced Formulas • Apply Range Names • Range Names • Adding Range Names Using the Name Box • Adding Range Names Using the New Name Dialog Box • Editing a Range Name and Deleting a Range Name • Using Range Names in Formulas Use Specialized Functions • Function Categories • The Excel Function Reference • Function Syntax • Function Entry Dialog Boxes • Using Nested Functions • Automatic Workbook Calculations • Showing and Hiding Formulas • Enabling Iterative Calculations Analyzing Data with Logical and Lookup Functions Use Text Functions Use Logical Functions • The AND Function • The OR Function • The IF Function Use Lookup Functions • The VLOOKUP Function • The HLOOKUP Function Use Date Functions Use Financial Functions • The PMT Function • The FV Function Create and Modify Tables • Tables • Table Components • The Create Table Dialog Box • The Table Tools – Design Contextual Tab • Styles and Quick Style Sets • Customizing Row Display • Table Modification Options Sort and Filter Data • The Difference Between Sorting and Filtering • Sorting Data • Advanced Filtering • Filter Operators • Removing Duplicate Values Use Subtotal and Database Functions to Calculate Data • SUBTOTAL Functions • The Subtotal Dialog Box • Summary Functions in Tables • Database Functions Visualizing Data with Charts • Create Charts • Charts • Chart Types • Chart Insertion Methods • Resizing and Moving the Chart • Adding Additional Data • Switching Between Rows and Columns