EXCEL AND DATA MANAGEMENT

 

Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, you learn easy-to-use commands, features, and functions for maintaining large lists of data in Excel. The training covers sorting, adding subtotals, filtering, eliminating duplicate data, and using Excel's Advanced Filter feature and specialized database functions to isolate and analyze data. With these techniques, you'll be able to extract the most important information from your data, in the shortest amount of time.

Duration - 2 days. Course fee: 50K

LESSON 1: OVERVIEW
LESSON 2: WORKING WITH MICROSOFT EXCEL 2016
LESSON 3: USING OFFICE BACKSTAGE
LESSON 4: USING BASIC FORMULAS
LESSON 5: USING FUNCTIONS
LESSON 6: FORMATTING CELLS AND RANGES
LESSON 7: FORMATTING WORKSHEETS
LESSON 8: MANAGING WORKSHEETS
LESSON 9: WORKING WITH DATA AND MACROS
LESSON 10: USING ADVANCED FORMULAS
LESSON 11: SECURING AND SHARING WORKBOOKS
LESSON 12: CREATING CHARTS
LESSON 13: ADDING PICTURES AND SHAPES TO A WORKSHEET