Microsoft Excel: Introduction for Beginners (1 day)

Course Overview

This course is designed to provide new users with a good understanding of the basic concepts of Microsoft Excel.

Booking a Microsoft training course with CourseMonster couldn't be easier. Simply click on the date and location that suits you best, confirm your booking and we'll send you all the information that you need.

Related Courses

• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Financial Modelling using Excel
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)

Audience

Users who are new to spreadsheets.

Skills Gained

For users new to Excel, this course provides the ideal introduction.

Course Outline

Excel Basics

• Spreadsheet Terminology
• Exploring The Excel Window
• Opening And Navigating A Workbook
• Closing A Workbook

Entering And Editing Data

• Creating A New Excel Workbook
• Entering And Editing Labels And Values
• Entering And Editing Formulas
• Saving And Updating A Workbook

Printing

• Preparing To Print
• Page Set up Options

Modifying A Worksheet

• Moving A Copying Data
• Moving And Copying Formulas
• Using Absolute References
• Inserting And Deleting Ranges Using Functions
• • Entering Functions
  • Using Autosum
  • Using AVERAGE, MIN, MAX, And COUNT

Formatting Worksheets

• Formatting Text
• Formatting Rows And Columns
• Number Formatting
• Other Formatting Features Creating Charts
• Creating A Chart
• Printing Charts

Web Features

• Saving A Worksheet As A Web Page
• Adding Hyperlinks
• Sending A Workbook Via Email