Excel

EXCEL

What we should know before going to Industry?

1. Data Validation

2. Relative Data Validation

3. Conditional Formatting

4. Writing / Building complex formulas

5. Custom Data Validation

6. Working with Dates

7. Data Filters(Simple)

8. Advance Filters

9. Subtotals

10.Working with Ranges/ Modifying/Deleting Ranges

11.Sorting

12.Multilevel sorting

13.Sorting By Color/Icons

14.Horizontal Sort

15.Pivot Tables/ Charts

16.Drill down Pivot tables & reports, Charts

17.Normal Charts

18.Comparative charts

19.Chart Formatting/Pivot/Normal , Using Layouts, Changing Scales

20.Linking of sheets

21.Linking of workbooks

22.Working with multiple sheets/workbooks using windows

23.Synchronous Scrolling

24.Freezing Panes

25.Goal Seek

26.Data tables

27.Security

28.Lookup, V Lookup, H Lookup

29.Paste Special

30.Consolidate

31.Formatting Data as Tables

32.Using Table Styles

33.Creating Table Styles

34.Using Cell Styles

35.Creating Cell Styles

36.Macros Recording

37.Writing Macros Using Excel VBA

38.Using Solver for Forecasting

39.Linking Webpages to Excel

40.Linking Database to Excel

Additional Things to be done

1. Mail Merge

2. Google Docs For Sharing Files/Data

3. Creating Forms using Google docs