Modes of Delivery
Team/Corporate Training
Our Corporate training is carefully structured to help executives keep ahead of rapidly evolving business environments.3 Months FREE Access to all our E-learning courses when you buy any course with us
Description
MS Excel is an important tool used by anybody who does a bit of number crunching. So whether you are an accountant or an engineer, this course will familiarize you with Excel 2010 concepts, starting from the basics like simple calculations and progressing towards more advanced concepts of complex financial analyses.
The workshop starts off with an introduction to the new additions that have been added to MS Excel 2010 and then goes on to explain the concepts of data security, formatting, data reports, graphs for representation of data and other specialized advanced functions. You will also learn how MS Excel can be integrated with other Microsoft Office Programs.
This flexible, virtual course is perfect for busy individuals who are committed to the idea of advancing their knowledge of MS Excel. Our comprehensive theory supplemented with loads of hands-on exercises will make you an expert, allowing you to use its functionalities to analyse, collaborate and share results, in an impressive and concise manner.
On successful completion of the course, you will receive a Course Completion Certificate from KnowledgeHut with Credits (1 credit per hour of training).
What you will learn
- New features in MS Excel 2010
- Functionalities and abilities of MS Excel
- Using the Data security feature to protect and share worksheets, cells and functions
- Specialized functions such as DSUM,DMAX etc
- Using Pivot table to analyse large sets of data
- Using Sparklines to summarize data
- Creating, recording and playing a macro
- Using the VBA editor to edit a macro
- Representing data in an impressive format through graphics and charts
You will also get:
- Learning credits
- Course completion certificate
- Confidence to handle on-the-job challenges
Key Features
Our popular Courses
- Agile and Scrum
- Certified Scrum Developer® (CSD)
- Certified ScrumMaster®(CSM)
- Certified Scrum Product Owner®(CSPO) Certification
- Professional Scrum MasterTM (PSM)
- Leading SAFe® 4.5 Certification
- SAFe® 4.5 for Teams
- DevOps Foundation Certification Course
- SAFe® 4.5 Advanced Scrum Master
- ICAgile - Foundations of DevOps (ICP-FDO) training
Curriculum
- Excel Abilities and its Functions
- Data Security, Formatting and Analyzing
- Data Reports
- Graphical Representations of Data
- Specialized Functions
- Collaborating with other Microsoft Office Programs
Our Students See All
It was a very good training. The trainer is well presented and has immense knowledge and clarified all the questions.
Attended workshop in May 2018Great course. An interesting and interactive session to better understand how to succeed in formulating a business case and how to present it effectively.
Attended workshop in May 2018The workshop was very interesting and interactive. All the concepts was clearly covered in the session. All the doubts and queries was solved with good example. Overall it was a good experience.
Attended workshop in May 2018The trainer was well experienced in handling such session. There was never a time, where we lost interest. It was well on target. And thanks to the directness of training, we got our concept clear and cleared the exam.
Attended workshop in May 2018
Frequently Asked Questions
MS Excel has been around for a long time but is still among the most widely used spreadsheet applications used for simple calculations as well as calculating and representing complex mathematical functions. Whatever your choice of career, this tool will help you with basic reporting functions, data analysis and sharing of data. Pursue this course and use MS Excel to further your career.
Basic knowledge of Excel will help candidates who wish to pursue this course.
Knowledge of MS Excel will benefit everybody from students to professionals. If you are passionate about learning MS Excel, then this course is for you.
No, this course is only available in the classroom format led by our certified experts.
On successful completion of the course you will receive a course completion certificate issued by KnowledgeHut.
You will receive 1 credit per hour of learning.
The trainers are highly qualified and certified instructors with years of relevant industry and coaching experience who will hand hold you through the workshop and ensure your success.
It is easy to enrol for classroom training online. There are several options to pay either through your debit/credit card that includes Visa Card, MasterCard; American Express or- via PayPal. Payment receipt will be issued to the candidate automatically by email.
Any registration cancelled within 48 hours of the initial registration will be refunded in FULL (please note that all cancellations will incur a 5% deduction in the refunded amount due to transactional costs applicable while refunding). 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
Please send in an email to support@knowledgehut.com, and we will answer any queries you may have!