Enter your keyword

Course

MICROSOFT EXCEL

MICROSOFT EXCEL TRAINING TIMETABLE

DAYSDURATIONTIMELOCATION 
APRIL 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
MAY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
AUGUST 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
SEPTEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
OCTOBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
NOVEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
DECEMBER 2017
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London

Microsoft Excel is a software program included in the Microsoft Office suite. It is used to create spreadsheets, which are documents in which data is laid out in rows and columns — like a big table.

Course Outline

BEGINNER SKILLS IN MICROSOFT EXCEL

  1. Setting Excel Options
  2. Creating a New Workbook
  3. Adding and Moving Data in Worksheet
  4. Creating a Worksheet Adding Data
  5. Modifying a Worksheet
  6. Adding Formulas
  7. Manipulating Worksheets
  8. Print a Worksheet

  1. Modifying the Formatting of Cells
  2. Using Borders and Margins
  3. Sorting and Filtering a Data List
  4. Using Proofing Tools

  1. Creating and Editing Charts
  2. Formatting Charts
  3. Creating and Formatting Charts
  4. Working with Shapes
  5. Inserting Graphics
  6. Inserting Objects in a Worksheet
  7. Adding Graphics to a Worksheet

INTERMEDIATE SKILLS IN MICROSOFT EXCEL

  1. Modifying Worksheets
  2. Adding Headers and Footers
  3. Editing Worksheets
  4. Working with Office Themes
  5. Formatting and Editing Cells
  6. Conditional Formatting
  7. Inserting Hyperlinks
  8. Formatting Cell Data

  1. Extending a Data Series
  2. Analyzing Data by Using Data Lists
  3. Cleaning Up and Outlining Data List
  4. Using What – If Analysis
  5. Performing Calculations
  6. Working with Data List

  1. Creating and Editing Pivot Tables
  2. Formatting Pivot Table Data
  3. Analyzing Pivot Table Data
  4. Working with a Pivot Table
  5. Working with Pivot Charts
  6. Editing Charts
  7. Using Table Styles
  8. Using Pivot Tables

  1. Setting Excel Options
  2. Setting Workbook Properties
  3. Customizing the Ribbon
  4. The track Changes Feature
  5. Linking and Embedding Objects
  6. Sharing a Workbook
  7. Working with the Advanced Features

ADVANCED SKILLS IN MICROSOFT EXCEL

  1. Setting Excel Options
  2. Defining Workbook Protection Levels
  3. Customizing Worksheet Views

  1. Manipulating Worksheet Data
  2. Creating Named Ranges
  3. Managing Named Ranges
  4. Inserting Equations
  5. Analyzing Data
  6. Working with a PowerPivot Workbook
  7. Working with Worksheet Data

  1. Defining and Editing External Data Connection
  2. Working with XML Data
  3. Creating and Editing Web Queries
  4. Working with External Data

  1. Working with Charts
  2. Creating a Sparkline Charts
  3. Creating Different Types of Charts
  4. Adding Trendline to a Chart
  5. Analyzing Pivot Table Data
  6. Working with Table and Charts

  1. Creating a Macro
  2. Editing a Macro
  3. Running and Deleting a Macro
  4. Working with Macro

Start On 2017-02-24
Duration 1DAY
Price £400.00

Share our course