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
It’s my time to thank one of my colleagues for referring Knowledgehut for the training. Really it was worth investing in the course. The customer support was very interactive. The trainer took a practical session which is supporting me in my daily work. I learned many things in that session, to be honest, the overall experience was incredible!
Attended PMP® Certification workshop in May 2018Overall, the training session at KnowledgeHut was a great experience. I learnt many things, it is the best training institution which I have attended. My trainer covered all the topics with live examples. Really, the training session was worth the spend.
Attended PMP® Certification workshop in May 2018The 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 who 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 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 2018KnowledgeHut has excellent instructors. The training session gave me a lot of exposure and various opportunities and helped me in growing my career. Trainer really was helpful and completed the syllabus covering each and every concept with examples on time.
Attended PMP® Certification workshop in May 2018Trainer really was helpful and completed the syllabus covering each and every concept with examples on time. Knowledgehut also got good customer support to handle people like me.
Attended Certified ScrumMaster®(CSM) workshop in May 2018I liked the way KnowledgeHut course got structured. My trainer took really interesting sessions which helped me to understand the concepts clearly. I would like to thank my trainer for his guidance.
Attended PMP® Certification workshop in May 2018
Astrid Corduas
Senior Web Administrator
Lauritz Behan
Computer Network Architect.
Vito Dapice
Data Quality Manager
Rubetta Pai
Front End Developer
Astrid Corduas
Telecommunications Specialist
Felicio Kettenring
Computer Systems Analyst.
Sherm Rimbach
Senior Network Architect
Barton Fonseka
Information Security Analyst.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-policy
Please send in an email to support@knowledgehut.com, and we will answer any queries you may have!