Take your career to the next level

with MS Excel 2013 Basic Training

Upcoming Batches

MS Excel 2013 Basic Training - Instructor Led

  • Reviews

Over 30000 students

50+ locations globally

Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to their fullest potential, rather than focusing on individual Excel functions and features.

This training would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.

This interactive training targets specific business situations, and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report.

This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.

Training Components

 

Instructor Led

Instructor Interaction

Yes

Training Duration

12 Hours Live Online

Instructor Helpline Post Training

30 Days

E-Learning Access

1 Year

12 PMI PDUs Certificate

Yes

100% Money Back Guarantee

Yes

Request Quote

We value your privacy. Privacy Policy

Course Objectives

At the end of the training the participants would learn/use/acquire the following techniques/knowledge:

  • Excel Advancements – some amazing features incorporated only in last 5 years
  • Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH
  • Advanced Data Sorting and Filtering techniques
  • Generating Pivot Tables and Charts from complex datasets, instantly
  • Implementing Slicers and Sparklines to build interactive dashboards
  • Exploring Data Validation techniques and creating dynamic lists
  • Using ‘What-If-Analysis’ and Data representation techniques

Scope of Learning

  • User able to manage data independently
  • User able to do reports (eg: Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc)
  • User will become data analyst
  • User will able to do MIS reports

Projects

Project 1: Create Sample Order Form Application for ‘Food Choice’ Outlet

Introduction : ‘Food Choice’ is a renowned retail outlet which sells fresh fruits, vegetables and non-veg items. Currently, it is a small store and manage its transactions through hand-written bills. The store however plans to scale up their business, and needs an Excel based POS program which would automate the data entry process. 


Project 2: Create Sample Dashboard for Sonata Logistics

Introduction : Sonata Logistics is a world renowned supply chain company which deals with customers across the globe. To compete with the market they implement new methods and technologies throughout the year. Analysis of customers and channel partners is always on top of their agenda. The company is currently looking for an automated dashboard which would visualize their performance and suggest growth markets.   

Registration Process

  • Step 1: Check for programs (check here)

  • Step 2: Click on 'Enroll' to register.

  • Step 3: Immediately on registration, you will receive an email from us with the payment details and access details for the on-demand e-learning component

  • Step 4: Receive an introduction and further communication from your GreyCampus training coordinator for the program you have registered for.

Why GreyCampus

  • High impact, proven training – Over 30000 professionals globally have participated in our training programs.

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years' of industry experience.

FAQ's

Q: What are the Pre-requisites for this course?

A: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.

Q: How do I get certified?

A: To register for a Microsoft Office Specialist exam please click here

Q. When will participants get their PDU Certificates?

A: All PDU E-Certificates will reach participants within 2 business days after the training.