Microsoft Excel Pivot table and Vlook up Virtual Training
Get the most out of your sheet
Course description
Excel Pivot table, ranges and Vlook up Virtual Training
​
Microsoft Excel is a powerful tool you can use to create and format spreadsheets, analyze and share information to make more informed decisions. Demonstrating any level of skills in this program is quite beneficial because Excel proficiency is high demanding by employers.
Content Highlights
PivotTables
1. Creating a PivotTable
2. Rearranging a PivotTable
3. Filtering a PivotTable: report filters, inline filters, slicers and timeline
4. Grouping PivotTable data
5. Field Settings
6. Calculated fields
7. Setting PivotTable options
8. Formatting a pivot table
9. Pivot Table design and layout
10. Creating a Pivotchart
​
Ranges and VLOOKUP
1. Naming a range
2. Using a named range
3. Managing range names
4. Using the VLOOKUP function
​
Who is this for?
Those who wants a hands-on guide to turn excel into a strength and also wants to develop their statistical and analytical skills to succeed in their career
“The course was very helpful and exceeded my expectation!”
N. Emer — Quality AAA
“Mi a hanja e splikashon hopi duidelijk”
D. Angelista