EXCEL ADVANCE FORMULA
Course Contents:
· Data filters: AutoFilter and advanced filters
· Sorting, Customize sorting
· Subtotals
· Cell level validations
· Specifying a valid range of values for a cell
· Specifying a list of valid values for a cell
· Specifying custom validations based on formula for a cell
· Using data tables for d
ata analysis
· Mastering PivotTables
· Multiple consolidation ranges
· Customizing PivotTable layout
· PivotTable advanced options
· Pivot Charts
· Importing text files in Excel
· Refreshing data
· Using data forms for managing tabular data
· Workbook sharing
· Merging workbooks
· Workbook and sheet protection
· Goal Seek
· Customizing toolbars and menus
· Settings
· Creating custom lists
· Conditional formatting of cells
· Creating, managing and merging styles for cell formatting
· Working with functions (based on your requirements)
· Financial functions
· Date and time functions
· Statistical functions
· Lookup and reference functions
· Database functions
· Text manipulation functions
· Logical functions
· Worksheet and cell information functions
· MS Excel - Macros topics
· Recording and running macros
· Types of references in macros
· Assigning a macro to a toolbar or menu
· User-defined functions
· Adding descriptions to user-defined functions
· Control-flow statements
· IF...ELSE
· SELECT...CASE
· FOR...NEXT
· Macro actions for cells and ranges
· Objects, properties and methods
· Processing individual cells in a range
· Macro actions for worksheets
· Macro actions for files
· Macro actions for charts
· Managing dialog boxes
· Manipulating menus in Excel macros
· Creating automatic procedures
