If you want to move beyond Excel basics and master the core statistical tasks that will help you as a student or business professional, then this course on Advanced MS Excel 2013 is just right for you.
Our experienced faculty will hand-hold you through the various aspects of MS Excel, starting from the basics and then moving on to advanced concepts such as correlation and regression, binomial, IF Functionality, sparklines, PivotTables, advanced mathematical functions and formulas and much more.
The potential of Excel in the world of Big Data analysis is now being realized and organizations are on the lookout for professionals who have mastered this tool. Our virtual class, with its comprehensive course structure, real-world examples and plenty of hands on examples will help you master Excel and use it to achieve professional and academic success.
Microsoft Excel 2013 basics
Mathematical Functions
IF Functionality
Performing Data Lookups
Sparklines
Advanced Mathematical Functions
Working with Outlines
Scenarios
Custom Views
Functions for manipulating text
Arrays
Important Data Functions
About PivotTables
From the course:
This course will help you to:
Learn advanced mathematical formulas and use them for statistical analysis
Analyse and manipulate huge amounts of data
Uncover trends and other important information by analysing data
Learnt to use Filters
Learn to summarize and visualize large amounts of data with Pivot Tables
Use Pivot Charts for professional representation of data
On successful completion of the course, you will receive a Course Completion Certificate from KnowledgeHut with Credits (1 credit per hour of training).
Eligibility:
Basic knowledge of Excel will help candidates who wish to pursue this course.
Advanced knowledge of MS Excel 2013 can benefit both students and professionals who are into data analysis or projecting statistics.
Why Knowledgehut?
1
We have trained thousands of professionals across the globe, and have received an average of 4.75 out of 5.0 feedback rating from our participants.
2
100+ Courses We provide cutting edge solutions through a variety of training formats (classroom, on-site, and online). Our customized coaching and consulting are spanned across multiple business units including Project Management, Quality Management, Agile Management, IT and IT Security, Big Data, Finance, Soft Skills and a lot more.
3
70+ Countries Our proven training methodology is available all around the globe. Our courses have met the satisfaction of individuals as well as corporates across frontiers that include US, APAC, Middle East, India and Europe. We take pride in our consistency in providing excellent services and facilities to our workshop participants in over 200 locations worldwide.
4
30000+ Trainees One of our major milestones is the fact that we have successfully trained more than 30,000 individuals worldwide till date, and have received a high rate of satisfaction with an average of 4.5 out of 5.0 feedback rating from our participants.
5
500+ certified world- class instructors Our large faculty of experienced trainers are outstanding performers who bring about a positive difference in our customers' career graphs.
6
9+ Accreditations Accredited by globally renowned names like Project Management Institute of USA, Scrum Alliance, APMG, EC Council, GARP, CompTIA, IIBA, AXELOS, (ISC)² and others
7
1500+ Organizations We have satisfactorily met the requirements of over 1500 organizations, and they include some of the popular names such as HP, Wipro, Accenture, IBM, Coca- Cola, Boeing, TESCO, Dell, HSBC, and many others.
KNOWLEDGEHUT REVIEWS
Ronak Shah UltraTech Cements
"KnowledgeHut; A good destination to learn FM using Excel"
Ben Ellins Global Business Analyst at British American Tobacco
"A confident first step towards becoming a PMP."
Georgia Van Der Linde Team Leader Instructional Design at Absa
"KnowledgeHut! Knowing what's required!"
Dhiraj Suri Project Manager at Religare
"Valuable information regarding processes to gather requirements and documents, and also handling stakeholders as well as coordinating with them."
Nikhil Hundia Business Analyst at Religare Securities Limited
MS Excel has been around for a long time but its use in analysing large amounts of data is only now being exploited. Big Data is the next big thing and more and more organizations are on the lookout for professionals who can analyse and expose trends that will help aid business. This course is a must not just for professional analysts but also for students who wish to pursue a career in Big data analytics.
You will need:
• Windows 7 / 8, XP or Vista – 32 / 64-Bit, Microsoft Office 2013
• 500 MHz processor, 256 MB Ram, 3 GB HDD
• 1.0 Mbps Broadband Connection
Any registration cancelled within 48 hours of the initial registration will be refunded in FULL. Please note that refunds will be processed within 30 days of receipt of written request for refund. Kindly go through our Refund Policy for more details: http://www.knowledgehut.com/refund
It is easy to enrol for the training online. There are several options to pay either through your debit/credit card that includes Visa Card, MasterCard; American Express or via PayPal. The payment receipt will be issued to the candidate automatically by email.
Learn through live online interaction with experienced trainers, not from video
tutorials.
Anyplace learning
We understand your busy schedules and recognise that undertaking a course while
working is not easy. Pick a convenient time slot and log in from anywhere.
100% money back guarantee
Not happy with the class? Get a full refund after your first session. Of course,
we do our best to ensure this does not happen!
training recordings
Revisit your doubts and get your concepts crystal clear by accessing your class
recordings post training.
comprehensive online course material
Our course material is comprehensive and easy to follow, available in
downloadable e-book format.
basic requirements
All you need is a Windows computer, an Internet connection with a minimum of 500
KBPS speed, and a pair of headphones with a microphone.
flexible schedule
Our classes are held on weekends and at convenient timings on weekdays, making it
easy for you to fit the sessions into your workday.
your satisfaction, assured!
Chance to get your concepts crystal clear by attending another batch of the same
course for free.
We guarantee you will pass the certification exam or we will reimburse you for the class
cost. If you do not pass the exam in three attempts (details described below), we
will pay you back for the class cost.
Here is how our Guarantee to Pass Policy Works:
1st Exam must be taken within 45 days of the PMP® 35 PDUs training class.
If unsuccessful on 1st exam, you may retake our KnowledgeHut class (for free) as many times as you like.
If unsuccessful on 2nd exam, you MUST retake our KnowledgeHut class (for free) before taking exam for the 3rd time.
3rd Exam must be taken within 30 days of the retaken class.
Our goal is to have you pass the exam the first time.
Our commitment to you is that KnowledgeHut will be available for guidance along the way.
Waiting List Query
Sorry! The seats for this program have just Sold Out!
But please share your details below and in case of any cancellations, we shall assign the opened up seat to you.
Thank you.
