training@mercury-training.com
Istanbul-Turkey: +905395991206 - Amman-Jordan: +962785666966 - London (UK): +447481362802

Strategic Business IT Planning, Deployment & Management Courses


MS Excel Training Course

Course Content:  

Unit 1: Introduction:

  • Introduction
  • Interface
  • Tabs and Ribbons
  • Document Windows
  • Navigation Tips
  • Office Button and Save

Unit 2: Entering, Editing and Formatting Data:

  • Introduction
  • Entering Data
  • Fonts, Fills, and Alignment
  • Cut, Copy, and Paste
  • Paste Special
  • Undo and Redo
  • Moving, Finding, and Replacing a Value
  • Cell Styles
  • Comments

Unit 3: Formatting Numbers:

  • Introduction
  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats

Unit 4: Managing Worksheets:

  • Introduction
  • Naming and Moving Worksheets
  • Copying Worksheets
  • Adding, Deleting and Hiding Worksheets
  • Moving, Copying, Deleting and Hiding Grouped Worksheets

Unit 5: Modifying Rows and Columns:

  • Introduction
  • Inserting and Deleting Columns and Rows
  • Inserting & Deleting Cells
  • Inserting Multiple Columns & Rows
  • Modifying Cell Width and Height
  • Hiding and Unhiding Rows and Columns

Unit 6: Understanding Formulas:

  • Introduction
  • Using Operations
  • Creating Formulas
  • AutoSum
  • Common Formulas
  • Searching for Formulas
  • Copying Formulas
  • Using Relative and Absolute References

Unit 7: Changing Views

  • Introduction
  • Workbook Views
  • Show/Hide
  • Zoom Features
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows
  • Minimize The Ribbon
  • Worksheet Backgrounds
  • Watermarks

Unit 8: AutoFill and Custom Lists:

  • Introduction
  • AutoFill a Series
  • AutoFill Non-Adjacent Cells
  • AutoFill on Multiple Sheets
  • Creating Custom Lists
  • Series Formatting

Unit 9: Conditional Formatting:

  • Introduction
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Custom Formatting Rule

Unit 10: Tables:

  • Introduction
  • Insert a Table and Style Options
  • Add Rows and Columns
  • Perform a Function in a Table
  • Summarise With Pivot Table

Unit 11: Data Tools:

  • Introduction
  • Data Validation
  • Drop-Down Lists
  • Removing Duplicates
  • Text To Columns
  • Goal Seek
  • Scenario Manager

Unit 12: Referencing Formulas:

  • Introduction
  • Multiple Sheet References
  • Consolidating Data - With or Without Links
  • Trace the Precedents and Dependents
  • Using the Watch Window

Unit 13: Ranges and Dates:

  • Introduction
  • Cell Names
  • Named Ranges
  • Formulas with Cell Names
  • Date Formulas

Unit 14: Lookups:

  • Introduction
  • VLOOKUP
  • VLOOKUP Exact Match
  • HLOOKUP
  • HLOOKUP Exact Match

Unit 15: Conditional Logic:

  • Introduction
  • IF Statement
  • Nested IF
  • AND
  • OR
  • NOT
  • IFERROR
  • SUMIF
  • AVERAGEIF
  • COUNTIF & COUNTIFS
  • SUMIFS
  • AVERAGEIFS

Unit 16: Text Formulas:

  • Introduction
  • Case Formulas
  • Fix Number Fields
  • Trim Spaces
  • Substitute Text

Unit 17: Introduction to Charts:

  • Introduction
  • Chart Types
  • Instant Chart
  • Update Chart
  • Column Chart
  • Picture Fill
  • Adjust Chart Size
  • Line Chart
  • Scatter Chart

Unit 18: Formatting Charts:

  • Introduction
  • Chart Styles
  • Chart Layouts
  • Add Labels
  • Axis Options
  • Chart Title
  • Legends
  • Data Labels

Unit 19: Adding Graphics to Spreadsheets

  • Introduction
  • Insert Pictures
  • Modifying Pictures
  • Insert Shapes
  • Insert SmartArt
  • Apply Themes
  • Arrange

Unit 20: Outline, Sort, Filter, and Subtotal:

  • Introduction
  • Group and Ungroup
  • Sort Data
  • Sort Multiple Levels
  • Filter Data
  • Advanced Filter
  • Conditional Sorting and Filtering
  • Sorting with Custom Lists
  • Subtotal

Unit 21: PivotTables:

  • Introduction
  • Creating PivotTables
  • Choosing Fields
  • PivotTable Layout
  • Filtering PivotTables
  • Modifying PivotTable Data
  • PivotCharts

Unit 22: Protecting Data:

  • Introduction
  • Workbook Passwords
  • Protecting Workbooks
  • Unlocking Cells

Strategic Business IT Planning, Deployment & Management Courses
MS Excel Training Course (B15093)

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.

Istanbul Office (Turkey)

training@mercury-training.com +905395991206

London (UK)

training@mercury-training.com +447481362802

Amman (Jordan)

training@mercury-training.com +962785666966