Call me back!
Microsoft Office
Microsoft Excel 2010® Fundamentals
Duration: 2 Days
Who Should Attend:
- IT Professionals who provide tech support
- Business Users with data manipulation requirements
Course Objectives
- An overview of the features and functions available in Microsoft Excel 2010®
- Learn how to analyse alternative data sets and create a variety of charts
- Learn how to create dynamic worksheets using PivotTables
- Learn how to automate repetitive tasks
- Learn how to integrate with other Microsoft programmes and collaborate on workbooks.
What will you gain?
- Create worksheets and work seamlessly with multiple workbooks
- Get the confidence and know-how to work with large amounts of data and generate tables to present findings
- Master the skill of working with complex formulas and functions to calculate values and analyse data
- Sort and use data filters to refine data
- Organise and summarise multiple sets of data with a few clicks
- Customise and format a pivot table to suit your needs
- Become proficient in analysing data by using descriptive statistics
- Create meaningful charts and customise them using the design, layout and formatting available in Excel
- Make relevant data stand out by using data and conditional formatting such as changing workbook themes and Excel table styles
- Know your way around the Print option, and print full worksheets or set specific areas of printing
- Save time by automating repetitive tasks using Macros
- Work with other Microsoft applications and incorporate data from Excel into other applications easily
- Share workbooks with colleagues and manage changes
- Use built-in Excel features to protect worksheet date and authenticate your workbook/s.
Other Programmes you may be interested in:
- ABC Success: Skills Development for Nationals - ILM Endorsed
- Achieving Business Success - ILM Endorsed
- Advanced Business Writing
- Career Planning and Talent Management
- Coaching and Mentoring Skills for Managers - ILM Endorsed
- Competency-Based Interviewing Skills - ILM Endorsed
- Core Skills of Emotional Intelligence - ILM Endorsed
- Creative Thinking, Problem Solving and Decision Making - ILM Endorsed
- Customer Service Excellence - ILM Endorsed
- Effective Business Writing
- Effective Report Writing
- Excellence in Presentations & Public Speaking - ILM Endorsed
- Finance for Non-Finance Professionals - ILM Endorsed
- Fundamentals of Project Management - ILM Endorsed
- High Impact Team Building - ILM Endorsed
- Leading High Performance Teams
- Mastering the Art of Effective Communication - ILM Endorsed
- Mastering the Art of Office Administration - ILM Endorsed
- Powerful Negotiations - ILM Endorsed
- Powerful Salesman - ILM Endorsed
- Strategic HRM & Talent Management - ILM Endorsed
- Strategic Thinking and Planning - ILM Endorsed
- Strategies for Successful Change Management - ILM Endorsed
- The New Star Management Supervisor - ILM Endorsed
- The Strategic People Manager - ILM Endorsed
- Train the Trainer - ILM Endorsed
EMAIL
+974 4031 6737