Microsoft Excel Training Course

by Bay Software Consultancy Limited Claim Listing

This one-day introductory class covers all the basics of Microsoft Excel. Participants will learn how to enter and edit information in a worksheet; manage and navigate worksheets and workbooks; perform calculations and manipulate worksheet data.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Bay Software Consultancy Limited Logo

img Duration

1 Day

Course Details

This one-day introductory class covers all the basics of Microsoft Excel. Participants will learn how to enter and edit information in a worksheet; manage and navigate worksheets and workbooks; perform calculations and manipulate worksheet data; format the worksheet contents; and prepare, set up, and print information.

 

Objectives:

  • Enter and edit information in a worksheet and manage workbooks.
  • Navigate worksheets and workbooks.
  • Perform calculations on worksheet data.
  • Manipulate worksheet data.
  • Format the contents of a worksheet.
  • Prepare, set up, and print information.

 

Outline:

  • Working with Worksheets and Workbooks
  • Starting Excel
  • Getting help
  • Entering information
  • Editing information in cells
  • Undoing an action
  • Managing workbooks
  • Saving, closing, and creating workbooks
  • Creating a new workbook using templates
  • Exiting Excel
  • Managing Worksheets and Workbooks
  • Changing the view of your workbook
  • Navigating a worksheet
  • Managing multiple workbooks
  • Performing Calculations
  • Selecting and naming ranges
  • Using Autocalculate
  • Using functions and formulas
  • Using Autosum and Autofill
  • Managing Workbook Information
  • Clearing information
  • Deleting and inserting ranges
  • Moving and copying information
  • Copying formulas
  • Understanding relative, absolute, and mixed formulas
  • Creating absolute and mixed references
  • Copying values only
  • Using AutoComplete
  • Formatting Worksheet Information
  • Formatting numbers and characters
  • Formatting cells and ranges
  • Merging cell information
  • Copying and deleting formatting
  • Checking and Printing Information
  • Checking spelling in a worksheet
  • Finding and replacing information
  • Previewing a worksheet
  • Setting up the page
  • Setting the page options and margins
  • Adding headers and footers
  • Inserting and removing a page break
  • Setting worksheet options
  • Printing a worksheet
  • Tauranga South Branch

    52 Wharf Street, Tauranga South, Tauranga

Check out more MS Excel courses in New Zealand

Computer Learning Centre Logo

Access - Accelerated Introduction

Participants can bring work that they would like to put on a database. Over the 3 hour course participants can apply their new skills to work that is relevant to them and they can take their work away with them.

by Computer Learning Centre [Claim Listing ]
knowitinc Logo

Microsoft Office

This training will provide the skills to efficiently use Outlook to manage your Emails, Calendar Appointments and Meetings, Tasks and Notes.

by knowitinc [Claim Listing ]
Chalk Box Logo

Microsoft Excel Functions

Learn the power of Excel. Turn stress into efficiency by using Excel formulae to simplify tasks. Expand your knowledge and gain new skills for using more of Excel’s wide range of functions.

by Chalk Box [Claim Listing ]
Auldhouse Logo

Microsoft Excel (Data Analysis and Reporting)

You will automate some common Excel tasks, vLookups, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

by Auldhouse [Claim Listing ]
Simply Training Logo

MS PowerPoint

MS PowerPoint training is offered by Simply Training. Simply Training can help you deliver real benefits for your employee IT training programmes through our Training Project Management service.

by Simply Training [Claim Listing ]

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