0

  • An empty cart

    You have no item in your shopping cart

Smartthink Training Ltd - The Information Technology, Business & E-testing Hub

Enter your keyword

Course

MICROSOFT EXCEL

MICROSOFT EXCEL TRAINING TIMETABLE

DAYSDURATIONTIMELOCATION
APRIL 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
MAY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
JULY 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
AUGUST 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
SEPTEMBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
OCTOBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
NOVEMBER 2020
WEEKDAYS (MON-FRI)1 DAY 10:00 - 16:00London
WEEKENDS (SAT.)1 DAY13:00 - 19:00London
DECEMBER 2020
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
CREATING AND EDITING WORKSHEET: 1

  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

CREATING AND EDITING WORKSHEET: 2

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

CREATING AND EDITING WORKSHEET: 3

  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
ENHANCING WORKBOOKS

  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

WORKING WITH 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

WORKING WITH TABLES AND CHARTS

  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

WORKING WITH ADVANCED FEATURES OF EXCEL

  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
CUSTOMIZING EXCEL

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

WORKING WITH WORKSHEET DATA

  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

WORKING WITH EXTERNAL DATA

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

WORKING WITH TABLES AND CHARTS

  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

AUTOMATING WORKBOOKS

  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