Unit 1
Introduction to Spreadsheets
Introduction to spreadsheets, reading data, manipulating data. Basic spreadsheet operations and functions, Using Formulas, Formula Functions – Sum, Average, if, Count, max, min, Proper, Upper, Lower, Using AutoSum, Advance Formulas
Unit 2
Spreadsheet Functions to Organize Data
Moving between Spreadsheets, Selecting Multiple Spreadsheets, Inserting and Deleting Spread sheets Renaming Spreadsheets, Splitting the Screen, Freezing Panes, Copying and Pasting, Data between Spreadsheets, Hiding, Protecting worksheets, Introduction to functions such as the IF, nested IF, VLOOKUP and HLOOKUP, Concatenate, Match, Count if, Text, Trim functions in Excel
Unit 3
Introduction to Filtering, Pivot Tables, and Charts
Introduction to the Data filtering capabilities of Excel, the construction of Pivot Tables to organize data and introduction to charts in Excel. Creating PivotTables, Manipulating a PivotTable, Using the PivotTable Toolbar, Changing Data Field, Properties, Displaying a PivotChart, Setting Pivot Table Options, Adding Subtotals to PivotTables.
Unit 4
Advanced Graphing and Charting
Constructing various Line, Bar and Pie charts. Using the Pivot chart features of Excel. Understanding and constructing Histograms and Scatter plots. Creating Charts, Different types of charts, Formatting Chart Objects, Changing the Chart Type, Showing and Hiding the Legend, Showing and Hiding the Data Table,
Unit 5
Macros
Making Macros, Recording Macros, Running Macros, Deleting Macro