Today's Topics
We'll review some basic functions like SUM, AVERAGE, COUNT and take a look at other functions like VLOOKUP and IF. Sorting and Filtering play a big part in data analysis so we'll take a look at Slicers to create a dashboard.
Functions
3D Formula, Linking
Absolute/Relative References
Charts
Conditional Formatting
Printing, Scaling, Header/Footer
Naming, moving, grouping sheets
Sorting and Filtering
Scenarios
Pivot Table and Dashboards
Files
ContosoEmployeeList
FinancialSample
FoodItems
ImportedFoods
ScenarioExample
Practice
Practice5
Exercise4
StudentListPractice
Food07Review
Additional_Practice_file
Pivot_Tutorial
PivotAct2
PivotAct2Instructions
PivotAct3
PivotAct3Instructions
OverallReview
Evaluation_Form
|
|
