Microsoft Excel Intro Training Course

by Insight Training Claim Listing

The objective of this session is to provide the new user with a comprehensive overview of the capabilities of Excel as well as presenting the knowledge required to begin using the program effectively.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Insight Training Logo

img Duration

1 Day

Course Details

The objective of this session is to provide the new user with a comprehensive overview of the capabilities of Excel as well as presenting the knowledge required to begin using the program effectively.    

As the session is primarily hands on it will be restricted to one user per computer system and is suitable for both the novice and the person who has dabbled with the software.

 

Topics:

  • Overview of Microsoft Excel
  • The Screen /The Ribbon / File Tab / Quick Access Toolbar
  • Excel Options Menu
  • Screen Tips / Using HELP /Excel Shortcuts
  • Overview of the Spreadsheet / Cell Addresses
  • Cursor Movement / GoTo / Excel Navigator
  • Selecting Methods
  • Working with Ranges & Named Ranges / Name Manager
  • Data Types / Data Entry / Editing
  • Text / Numbers / Custom Lists / Fill Ranges
  • Cut / Copy / Paste / Paste Special Functions /Quick Functions etc
  • Relative / Absolute Cell Addresses
  • Copying between Sheets / Files
  • Creating / Importing / Using Customs Lists
  • = Functions / Named Ranges in Formula
  • SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF/ SUMIF
  • DATE & TIME FUNCTIONS / NOW()
  • IF STATEMENTS
  • 3D Data Entry & 3D Formula
  • Formatting Cells / Worksheet
  • Text / Numeric / Dates etc / Special / Alignment Options / Fonts / Borders / Patterns
  • Using Conditional Formatting  / Using the Format Painter
  • File Handling
  • Using Save / Save As – Directories / Drives / File Type.
  • Adding Password Protection
  • Protecting the Sheet / Workbook
  • Working with Comments
  • Print and Print Options
  • Changing the Set Up / Print Area
  • Headers and Footers / Page Break Preview / Orientation Print Preview
  • Freezing Panes/ New Window
  • Working with Charts
  • Creating a Chart / Chart Types
  • Change Design / Layout / Colours / Format
  • Data Tables
  • Sorting and Filtering
  • Glasgow Branch

    3 Lochview Terrace, Gartcosh, G69 8BA, Glasgow

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy