The folder contains eight excel tasks and solutions(task#-help file). The folder also contains two text files to be used in a task for importing data. The eight tasks cover the following features:

Task0 
1. Gridlines
2. Format cells
3. Summation 
4. Conditional operators
5. Boolean Functions
6. Auto fill

Task1
1. Formatting text 
2. Cell Referencing
3. Formulae in excel- Average, Standard Deviation
4. Charts

Task2
1. logical operators
2. Nested functions

Task3
1. Spliting windows
2. Formulae - NPV

Task4
1. Renaming and adding worksheets
2. Hyperlinking
3. HLOOKUP/VLOOKUP
4. Count function

Task5
1. Group and Outline
2. Freeze/Unfreeze panes

Task6
1. Pivot tables
2. Interactive buttons
3. Importing data 

Task7
1.Filters
2.Conditional formatting
3.Data Protection
4.Data Validation
5.Text to columns
6.Sorting

