Book Online Tickets for Excel 3-hour workshops on 22nd and  23rd, Mumbai.  on 22nd Feb
Things you can do in Google sheets that you cannot in Excel
Time: 3:00 pm - 6:00 pm
About: 
Google Sheets is a much-appreciated spreadsheet application, mainly for its capability of sharing and collaboration – multiple pe

Excel 3-hour workshops on 22nd and 23rd February,2018

 

Invite friends

Contact Us

Page Views : 63

About The Event

 on 22nd Feb

Things you can do in Google sheets that you cannot in Excel

Time: 3:00 pm - 6:00 pm

About: 

Google Sheets is a much-appreciated spreadsheet application, mainly for its capability of sharing and collaboration – multiple people can work on the same file, together.

 

There’s a lot in Google Sheets, beyond sharing & collaboration only.

 

Once you learn the Things you can do in Google Sheet that you cannot in Excel, your mind will open-up to multiple possibilities of how to use it.

 

What all will you learn (completely hands-on) in these 3 hours?! 

 

  • Filter Views
  • Split data dynamically
  • Import data from website
  • Functions that are not in Excel
  • Protection - Sharing with limited rights to edit for certain people
  • Google Forms
  • Create your own Live Stocks Portfolio
  • Advanced data validation options
  • Email notifications
  • Pivot Tables Refresh capability
  • Bookmarking
  • Inserting Columns and Rows differently
  • Extend Google Sheets with add-ons
  • Revision History
  • Google Data Studio

 

 Why should I invest 3 hours in learning it?

 

Whenever you come across a problem to solve, or want to build something from scratch, this course will help you decide whether to use Google Sheets for it or Excel. Making the choice will be simpler and more accurate.

 

 On 23rd Feb

Master Business Reporting using Pivot tables and charts in Excel

Time: 10:00 am - 1:00 pm

About: 

Whether you are a Freelancer, a StartUp, an Established Business, or even if still working on a new Business Idea, Pivot Tables can do brilliant magic for you! Decision making will become so much easier and faster!

3 hours hands-on workshop on how to use Pivot Tables & Charts Super Effectively and create meaningful, actionable Reports for your Business, in a flash!

Why should you invest 3 hours in learning pivot tables in-depth? 

Pivot Tables in Excel is one tool that will give you the power to analyze data in an unbelievable and quick manner! Before even your boss finishes telling you his requirement, your report will be ready! ;-)

What all will you learn (completely hands-on) in these 3 hours?! 

  • Introduction to Pivot Tables
  • Data structures (what works, what doesn’t)
  • Create single & multilayer pivot tables
  • Display options
  • Showing values differently
  • Summarizing values in various ways
  • Sorting & Filtering
  • Custom Sorting
  • Report filter & pages
  • Grouping
  • Drilldown
  • Connecting slicers & timelines
  • Pivot Charts
  • Build your 1st DASHBOARD! No programming required!
  • How Pivot Tables work in Google Sheet

 Advanced Data cleaning Techniques in Excel

Time: 2:30 pm - 5:30 pm

About: 

 

Data Cleaning is the process of detecting and correcting (or removing) inaccurate and incomplete data.

There’s no point of generating reports from your data when it’s not clean and usable; all your reports will be faulty, and you can’t take any decisions based on them.

Excel’s Advanced Data Cleaning techniques help you become the Sherlock Holmes in detecting this inaccurate and incomplete data!

 

Why is Data Cleaning important? Why should I invest 3 hours in learning it?

Let’s say you want to carry out some marketing activity to your current 35000 customers. The customer database that you are currently maintaining maybe full of mix data like: -

  • Mobile numbers may not be 10 digits (India nos.) – SMS marketing cannot happen if the numbers not in order
  • Email ID’s have spelling mistakes @gmale.com, @gmali.com, @yahooo.com, @hotmal.com – Emails will keep bouncing back even though you have the correct email id.
  • You want to carry out city-wise marketing activities, but the city names are messed up – you would not know how many city-wise customers do you really have?
  • You download data from a back-end system which is all merged into 1 cell. You want the data to be usable quickly.

 

What all will you learn (completely hands-on) in these 3 hours?! 

  • Data Structuring correctly
  • Standardizing data at input stage
  • Identifying missing data in a large set
  • Identifying Duplicate & Unique Records
  • Selecting cells based on various types of selections
  • Cleaning, Extracting, Combining Text
  • Find & Replace advance options
  • Working with and Cleaning Numbers & Dates
  • Paste Special
  • Advanced Vlookup technique to streamline data in required format

 

Venue Map