Microsoft Excel 2010® Fundamentals HNI Training & Coaching

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?

By the end of this course you will be able to:

  • 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.
 Course Content:

 1. Chapter 1 Setting Up a Workbook

  • Creating workbooks
  • Modifying workbooks
  • Modifying worksheets
  • Customising the Excel 2010 Programme Window
  • Key points
2. Chapter 2 Working with Data and Excel Tables

  • Entering and revising data
  • Moving data within a workbook
  • Finding and replacing data
  • Correcting and expanding upon worksheet data
  • Defining Excel tables
  • Key points
3. Chapter 3 Performing Calculations on Data

  • Naming groups of data
  • Creating formulas to calculate values
  • Summarising data that meets specific conditions
  • Finding and correcting errors in calculations
  • Key points
4. Chapter 4 Changing Workbook Appearance

  • Formatting cells
  • Defining styles
  • Applying workbook themes and Excel table styles
  • Making numbers easier to read
  • Changing the appearance of data based on its value
  • Adding images to worksheets
  • Key points
5. Chapter 5 Focusing on Specific Data by Using Filters

  • Limiting data that appears on your screen
  • Manipulating worksheet data
  • Defining valid sets of values for ranges of cells
  • Key points
6. Chapter 6 Reordering and Summarising Data

  • Sorting worksheet data
  • Organising data into levels
  • Looking up information in a worksheet
  • Key points
7. Chapter 7 Combining Data from Multiple Sources

  • Using workbooks as templates for other workbooks
  • Linking to data in other worksheets and workbooks
  • Consolidating multiple sets of data into a single workbook
  • Grouping multiple sets of data
  • Key points
8. Chapter 8 Analysing Alternative Data Sets

  • Defining an alternative data set
  • Defining multiple alternative data sets
  • Varying your data to get a desired result by using goal seek
  • Finding optimal solutions by using solver
  • Analysing data by using descriptive statistics
  • Key points
9. Chapter 9 Creating Dynamic Worksheets by Using Pivot Tables

  • Analysing data dynamically by using Pivot Tables
  • Filtering, showing and hiding Pivot Table data
  • Editing Pivot Tables
  • Formatting Pivot Tables
  • Creating Pivot Tables from external data
  • Key points
10. Chapter 10 Creating Charts and Graphics

  • Creating charts
  • Customising the appearance of charts
  • Finding trends in your data
  • Summarising your data by using Sparklines
  • Creating dynamic charts by using PivotCharts
  • Creating diagrammes by using SmartArt
  • Creating shapes and mathematical equations
  • Key points
11. Chapter 11 Printing

  • Adding headers and footers to printed pages
  • Preparing worksheets for printing
  • Printing worksheets
  • Printing parts of worksheets
  • Printing charts
  • Key points
12. Chapter 12 Automating Repetitive Tasks by Using Macros

  • Enabling and examining Macros
  • Creating and modifying Macros
  • Running Macros when a button is clicked
  • Running Macros when a workbook Is opened
  • Key points 
13. Chapter 13 Working with Other Microsoft Office Programmes

  • Including office documents in workbooks
  • Storing workbooks as parts of other office documents
  • Creating hyperlinks
  • Pasting charts into other documents
  • Key points
14. Chapter 14 Collaborating with Colleagues

  • Sharing workbooks
  • Managing comments
  • Tracking and managing colleagues' changes
  • Protecting workbooks and worksheets
  • Authenticating workbooks
  • Saving workbooks for the web
  • Key points.

Career Path

Master your Spreadsheet Applications using Microsoft Excel 2010®

HNI Training and Coaching as a Dubai training center, is an innovator and leader in human capital development, providing world-class experiential corporate training solutions and services in English and Arabic to organisations in the MENA region. HNI Training and Coaching is amongst the leading training institutes in Dubai that currently offers training courses in Abu Dhabi, Dubai and Doha in 16 different categories.

See all HNI Training & Coaching courses

Contact information not available.

Courses you can instantly connect with... Microsoft Excel Training New Horizons Doha

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or