We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. Read more…
Thursday
19
APR

Advance Excel Workshop - Vasudev Vashisht

15:00
17:00
91springboard
Event organized by 91springboard

Get Directions

Category
#var:page_name# cover

What will you learn?
Formatting basics - formatting an excel sheet along with Conditional Formatting

Simple and Intermediate understanding of charts, trendline and sparkline.

Lookups and beyond

Pivot charts and table

Macros basics

What-If Analysis, Scenario Manager

Sorting and Filtering Data

Data Import and Export.

Automation of Tasks (VBA basics)

Workbook/Worksheet Security basics

Data Import/Export and Saving/ Exchanging


What you need to get to the workshop?


Must carry your laptop.

Windows users - Excel 2010 or higher version (2016 or Office 365 version preferred)

Mac users – Excel for Mac 2011 (2016 or Office 365 version preferred?

Mac users, must ensure you have Excel. Numbers (from Apple) won’t help for this workshop