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. 

Dates:  20 & 21 October, 2020

Time:   6:00 - 8:00 PM

 
 

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

 

Registration

If you would like to sharpen your skills, register now and save your seat. For registration or more course information click the below button. 

 
ABOUT US

PURE IT ACADEMY, your destination for IT Courses and everything related to career development for IT professionals. PURE IT academy is committed to elevate Caribbean's IT professionals by providing in-depth knowledge and understanding of technology, relevant experience and flexibility to stay ahead of the ever evolving technologies in the IT landscape.

SUBSCRIBE FOR EMAILS
ADDRESS

+5999 841-7873

 

Penstraat 23
Willemstad, Curaçao

info@pure-it-academy.com

www.pure-it-academy.com

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Instagram
  • Grey YouTube Icon

Stay connected