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
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 Top Courses
- Agile and Scrum
- Certified Scrum Developer® (CSD)
- Certified ScrumMaster®(CSM)
- Certified Scrum Product Owner®(CSPO) Certification
- Professional Scrum Master™(PSM)
- Leading SAFe® 4.6 Certification
- SAFe® 4.6 for Teams
- DevOps Foundation Certification Course
- SAFe® 4.6 Advanced Scrum Master
- ICAgile - Foundations of DevOps (ICP-FDO) training
reviews on our popular courses See All
The trainer was really helpful and completed the syllabus on time and also provided live examples which helped me to remember the concepts. Now, I am in the process of completing the certification. Overall good experience.
Attended PMP® Certification workshop in May 2018I am glad to have attended KnowledgeHut’s training program. Really I should thank my friend for referring me here. I was impressed with the trainer, explained advanced concepts deeply with better examples. Everything was well organized. I would like to refer some of their courses to my peers as well.
Attended PMP® Certification workshop in May 2018KnowledgeHut Course was designed with all the basic and advanced concepts. My trainer was very knowledgeable and liked the way of teaching. Various concepts and tasks during the workshops given by the trainer helped me to enhance my career. I also liked the way the customer support handled, they helped me throughout the process.
Attended PMP® Certification workshop in May 2018The instructor was very knowledgeable, the course was structured very well. I would like to sincerely thank the customer support team for extending their support at every step. They were always ready to help and supported throughout the process.
Attended Agile and Scrum workshop in May 2018I had enrolled for the course last week. I liked the way KnowledgeHut framed the course structure. The trainer was really helpful and completed the syllabus on time and also provided live examples which helped me to remember the concepts.
Attended Agile and Scrum workshop in May 2018The course material was designed very well. It was one of the best workshops I have ever seen in my career. Knowledgehut is a great place to learn and earn new skills. The certificate which I have received after my course helped me get a great job offer. Totally, the training session was worth investing.
Attended Agile and Scrum workshop in May 2018The workshop held at KnowledgeHut last week was very interesting. I have never come across such workshops in my career. The course materials were designed very well with all the instructions. Thanks to KnowledgeHut, looking forward to more such workshops.
Attended Certified ScrumMaster®(CSM) workshop in May 2018Trainer at KnowledgeHut made sure to address all my doubts clearly. I was really impressed with the training and I was able to learn a lot of new things. It was a great platform to learn.
Attended PMP® Certification workshop in May 2018
Vito Dapice
Data Quality Manager
Rubetta Pai
Front End Developer
Nathaniel Sherman
Hardware Engineer.
Astrid Corduas
Telecommunications Specialist
York Bollani
Computer Systems Analyst.
Hillie Takata
Senior Systems Software Enginee
Alexandr Waldroop
Data Architect.
Meg Gomes casseres
Database Administrator.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: https://www.knowledgehut.com/refund
Please send in an email to support@knowledgehut.com, and we will answer any queries you may have!