Users will learn to filter data based on key characteristics (Filtering)
The users will learn to format different cells when a criterion is fulfilled, e.g. customer balance has exceeded his credit limit (Conditional Formatting & Data Validation)
User will learn to use Pivot tables to manage and reporting of data based on different layouts.
Users will learn to design worksheets and protect them for data entry purpose.
Users will learn how to create different type of Charts to communicate Effectively (Charts)
Users will learn how to work on a common file ( Sharing , Online Collaboration)
User will learn to record macros to perform day to day operations such as how to create monthly sales report in an easy way (working with Macros).
Users will learn to use the auditing toolbar to track any mistakes (Auditing Workbook).
Users will learn to use What if analysis and scenarios to anticipate future .
Users will learn to use Solver and data table to solve complex Problems .
Users will learn how to import data from third party programs into excel whereas they can use Excel tools and functions to manage their department in more effective and efficient way.
User will learn advanced functions like Lookup, Countif, Sumif, FV, PMT, Offset,etc.