Live Online Training

  • 16 Hours Live Online Training
  • Excel Templates with Advanced Functions
  • 6 hours of High-Quality e-learning Content
  • 18 End-of-Chapter Quizzes & Industry Based Examples
  • 3 MS Excel 2013 simulation exams
  • 24X7 eLearning Access & support over Email
  • Certified Trainer & Mentorship from industry experts
$399.00 USD

Classroom Course

  • Weekend Exam Prep Training Classes
  • 180 days of access to high-quality Self-paced learning content
  • Globally recognized industry experts Trainers
  • Mentorship from Industry Experts
 

Corporate Training

  • Customized learning delivery model (self-paced online and/or instructor-led options)
  • Course, category, and all-access pricing
  • Learning management system (LMS)
  • Enhanced reporting for individuals and teams
 

COURSE ADVISOR

PMP certification Guide
Ms. Parul Gangwar
SAS® Certified

DEMO

 

Parul Gangwar is a Business and Financial Analytics expert having 8 years of industry experience with organizations like iGate and Aon Hewitt. She is a certified trainer for SAS® Programming and Tableau and skilled in Financial Modelling, Decision trees, Data Mining, SQL, VB Script, UNIX and Credit Risks. She has already trained more than 500 professionals in various technologies.

key features

  • CERTIFIED TRAINERS & INDUSTRY EXPERTS
  • 200+ TRAININGS CONDUCTED
  • 1400+ LEARNERS
  • CHOOSE YOUR LEARNING STYLE
  • HIGH QUALITY E-LEARNING

 

Why learn
Advanced Microsoft Excel?

Excel is the most popular tool for analyzing and visualization of data. Mastery of Excel is an essential skill for anyone who is required to crunch data and do statistical analysis.

Over the years Excel has evolved from a generic spredsheet program to a sophisticated data analysis tool with advanced analytical capabilities. Regarded as an essential tool for any data scientist, Excel helps to gather and transform data from diverse sources and helps to do advanced statistical modeling to derive analytics and insights from vast amount of data.
Through Advanced Excel Training, you will learn how to get and manipulate data from different sources and be made ready for analysis. You will see how you can perfom complex calculations, create visualizations and generate insights. With a good grounding on advanced techniques, you can achieve more by significantly improving your productivity irrespective of the role that you play in any organization.

Who should join Advanced Microsoft Excel 2013 Certification Training?

This training will be useful for students and professionals who are involved with organizing, analyzing and reporting data. Microsoft® Excel is so powerful that it has a wide applicability that virtually anyone can benefit from attending this training.

Prerequisites for Microsoft® Excel Training

Basic knowledge of using computers is sufficient to start with this training. It is advisable to have good knowledge of statistics to perform advanced data analysis and generate insightful dashboards and reports.

Course Contents

MODULE 1: OVERVIEW OF THE BASICS OF EXCEL
  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells
MODULE 2: WORKING WITH FUNCTIONS
  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets
MODULE 3: DATA VALIDATIONS
  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell
MODULE 4: WORKING WITH TEMPLATES
  • Designing the structure of a template
  • Using templates for standardization of worksheets
MODULE 5: SORTING AND FILTERING DATA
  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options
MODULE 6: WORKING WITH REPORTS
  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • Creating Slicers ( Version 2010 & Above)
MODULE 7: MORE FUNCTIONS
  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)
MODULE 8: FORMATTING
  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells
MODULE 9: MACROS
  • Relative & Absolute Macros
  • Editing Macro's
MODULE 10: WHATIF ANALYSIS
  • Goal Seek
  • Data Tables
  • Scenario Manager
MODULE 11: CHARTS
  • Using Charts
  • Formatting Charts
  • Using 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)
MODULE 12: NEW FEATURES OF EXCEL
  • Sparklines, Inline Charts, data Charts
  • Overview of all the new features
MODULE 13: FINAL ASSIGNMENT
  • The Final Assignment would test contains questions to be solved at the end of the Course

FAQs

HOW WILL LEARNING ADVANCED EXCEL HELP IN MY CAREER?

Microsoft Excel is an essential skill required for most of the jobs. Irrespective of whether you area Student, Engineer or an Executive in an Organization – it is highly likely that you need to organize and analyze data in one form or another. Having advanced skills in this very popular tool to gather, transform, analyze and visualize data will help you to improve your productivity by leaps and bounds.

WHAT ARE THE PREREQUISITES FOR THIS TRAINING?

Though there is no formal prerequisite for this training, candidates with basic computer knowledge can undergo this training.  It is advisable to have working knowledge of statistical concepts to perform advanced data analysis and  generate insightful dashboards and reports.

WHAT ALL WILL I LEARN FROM THIS TRAINING?
Starting with the basic concepts of spreadsheet and spreadsheet manipulation, you will learn about using different Formatting Techniques, using Formulas and in-built Functions, Graphs, Charts, Macros programming, VB Programming, MS Access etc.
 
ARE THERE ANY CERTIFICATIONS FOR MICROSOFT EXCEL AVAILABLE?

Yes, Microsoft Office Specialist certifications are available for Expert and Master (MOS: Microsoft Office Excel 2016 Expert /Master) which is considered to be recognition of advanced skills in  Excel.

I AM FRESH OUT OF COLLEGE. WILL THIS TRAINING BE OF ANY HELP?

Absolutely! This is a valuable skill for fresh job applicants for numerous office support jobs. Any job where there is a need for organizing and analyzing data, Excel is a perfect fit. Having advanced knowledge and skills on this tool can give you an edge in the job market.

ARE THERE ANY OTHER RELATED TRAININGS THAT I CAN PURSUE AFTER THIS TRAINING?
There are multiple data analytics related trainings that you can pursue beyond this training. Financial Modeling, HR Analytics and Business Analytics with R are few of the analytics trainings that you could pursue.
Other Advanced Analytics Trainings that you could consider are Business Analytics with SAS and Big Data & Hadoop.
CAN YOU PLEASE PROVIDE SOME REAL WORLD EXAMPLES OF FINANCIAL MODELING?
Here are a few areas that could benefit, though the list is not exhaustive
  • Projecting a company’s financial performance
  • Historical financial analysis of organizations
  • Personal Finances
  • Equity Research
  • Corporate Investments
  • Project Finance
  • Business Valuation

Our members make ScholarsPro community


Santosh Nayak
Santosh Nayak Infrastructure Project Manager
HCL, Singapore

Excellent learning center for management and technical trainings. ScholarsPro’s training would be the first step for a career change. Materials and online training videos are great – you can upgrade your skills without attending face to face session. Good work from the company. I have been attending the training from 2014. Recently I have taken PMP training. I feel ScholarsPro is my place to upgrade my career.

Yusran Ariffin
Yusran Ariffin Project Lead
TRX City Sdn Bhd, Malaysia

It’s a good place to learn, mainly the learning guidance is great. The course material provided is good, one can understand the codes and technical aspects well.  It is one the best platform to learn and get ahead, I enrolled for PMP self-paced and I am able to understand the concepts, also the learning support  is very good, they are always available to help and are prompt in returning your call, the consultants have deep knowledge, they guide you in the best possible way, thanks ScholarsPro!

Rajat
Rajat Developer
HCL Technologies (India)

My Hadoop training with Scholarspro was what I was looking for. Wonderful experience and I will recommend to others too.

Anjana Sudaresan
Anjana Sudaresan Student
Shanmugha Arts, Science, Technology and Research Academy

Very good training to help improve our skills.  Good course material and structured modules for learning R. Wonderful experience!

Manisha Vatsayam
Manisha Vatsayam Business Development Manager
ICRI, India

It was wonderful getting trained in Digital Marketing from SchoalrsPro. The trainer had a lot of knowledge in which will be very helpful in my work and career.

Ritesh Garg
Ritesh Garg Vice President
ELI, India

I am very impressed with teaching skills and knowledge of the trainer for PRINCE2. Thanks to the trainer and Scholars Team for proving such a good environment to learn.

Sanjeev Sharma
Sanjeev Sharma Manager
Evalueserve, India

The course curriculum, study material and classes for Business Analytics course were very helpful in terms of knowledge and exposure about the Business Analytics profile. The faculty was also very helpful and very knowledgeable.

Satyajeet Sharma
Satyajeet Sharma Manager
AGS Transact Technologies Ltd., India

My experience was good as the trainer of PRINCE2 was very enthusiastic, answered all my queries in depth & also provided useful pointers for exams & real life scenarios. Thanks a lot to the trainer & ScholarsPro Team

DineshKumar Lal
DineshKumar Lal Senior Project Engineer
Rotary Engineering Limited, Singapore

Courses offered by ScholarsPro have been very helpful in keeping myself updated with the best practices in the industry. Video quality is good; simulation tests are very helpful to confirming the understanding. People in the customer services team have been very helpful and been able to handle requests without much escalation. Thanks for a short extension to help me complete my PMP session. Much appreciated!

Tapadhir
Tapadhir Manager
Janalaxmi Financials, India

Very much impressed by the teaching style and delivery of the course of PMP by ScholarsPro. Thank you for providing me a platform for my future growth.

Sanjay Sinha
Sanjay Sinha Secretary
ICAS, India

SchoalrsPro good place to learn R through online course. Great environment and very nice faculty. All the best!

Sanchita Dey
Sanchita Dey Senior Manager
Hewlett Packard, India
Satisfied with the content and pattern of teaching online. Thank you ScholarsPro for my certification in PMP with you. Knowledgeable professor with full understanding.
Nipun Raj
Nipun Raj Nipun Raj
Reliance Capital, India

My experience is very good with ScholarsPro. Trainer of Digital Marketing is very much supportive and knowledgeable.

Manish
Manish Assistant Manager
Barclays Bank, India

Incredible Trainer! I have been trying to learn SAS since 1 month on my own. Everything got jumbled up. Thanks to the trainer – just one session straightened my thoughts.

Amit Kumar Singh
Amit Kumar Singh Software Development Engineer
Allegis Services, India

I would like to thank you for your support. I enjoyed your Hadoop classes.

Kuldeep Walia
Kuldeep Walia Self-employed (IT Sector)

I am very impressed with teaching skills & knowledge of PRINCE2 trainer. Thanks to him & ScholarsPro

Ayush Sethi
Ayush Sethi
Evalueserve, India

First of all I would like to thank you for teaching some really good things in SAS. I found Macros the best part during the training (Proc Sql and Base SAS I had studied earlier as well). The content of the training was very good. I will try my best to take some time out of my working hours and practice on SAS.

Bhavna Singh
Bhavna Singh Market development SE Snapdeal

Great learning by the trainer ,satisfied with the delivery of content

Baljinder sachdeva
Baljinder sachdeva Marketing head
IVF fertility centre

Great learning by the trainer ,satisfied with the delivery of content.

Helly shah
Helly shah Content writer

Digital marketing course by scholars helps me to gain knowledge in the field of marketing,Trainer was very nice and adjustable ...

Diksha thakur
Diksha thakur Student NMIMS

Very supportive ands cooperative trainer ,Pranav sir always helps us to improvise the things .The course is very knowledgable which ...

Aayush bhardwaj
Aayush bhardwaj Student NMIMS

The DM course study material, classes was very helpful in terms of knowledge and exposure about the SMO,SEO,TRainer ...

Enterprises we helped to UPSKILL