Advanced Excel Workshop over McDonalds n Chaayos, Data Analytics Beginner

Advanced Excel Workshop over McDonalds n Chaayos, Data Analytics Beginner

 

Invite friends

Contact Us

Page Views : 31

About The Event

Why ? 

  • More than 20,000 openings for Advanced Excel in the market today!
  • Advanced Excel is critical for business streams – sales, marketing, administration, entrepreneurship, finance, research etc.
  • Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

Mentor
Abhay Mishra, Expert in Data Analysis, Mu Sigma

Outcome

  • Create flexible data aggregations using pivot tables
  • Represent data visually using pivot charts
  • Calculate margins and other common ratios using calculation on pivot table
  • Filter data using slicers in multiple pivot tables 
  • Create aggregate reports using formula based techniques
  • VLOOKUP, HLOOK, LOOKUP to get last item, INDEX and MATCH to make automated dynamic dashboarts/reports

Special?

  • Sessions by expert who has hands on expertise
  • Using best content shown on laptops
  • Inside an air conditioned company campus
  • Special interface with overseas experts on Video

Duration      2 days, 4-6 hours

Where           Sec 32, Gurgaon

When             15th April, 2017

Price              Rs. 2000 (pay Rs. 500 now – rest onsite)

For whom

Students in colleges, Adults, Working professionals & Business people


Value add

Rs.10,000 coupons from Amazon and other companies

Course Details

In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

Organizer

Nujam Technologies Pvt. Ltd. gets college students & adults into Professional Careers in Business & Technology by mentoring them with 100+ industry experts (practitioners, not teachers) using best of content online (coursera, google, stanford etc.) at our centralized learning system, with sessions inside companies, incubators (6 cities, 1000+ seats) during happy hours (post 530 pm weekdays, or weekends).

Nujam is steered by senior industry professionals. Nujam’s CEO has ~20 years of experience across Technology & Consumer businesses at Snapdeal, ITC, Future Group, PE fund etc. He’s co-created 4 tech startups, won many awards. With him are 15+ senior gurus from eBay, McKinsey, Deutsche Bank, Yahoo, Mu Sigma, Flipkart, Amazon, Times Internet etc. who guide Nujam.