MS Excel (2016, 2019, 365) - Level 1

by PMC (Performance Management Consultants) Claim Listing

Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

PMC (Performance Management Consultants) Logo

img Duration

1 Day

Course Details

Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool.

In this one-day workshop, you will learn the basics of creating, modifying, formatting and printing worksheets. You will learn to use basic formulas and functions and manage large workbooks to analyze and understand data.

 

Learning Outcomes:

  • Enter and edit data
  • Format data, cells and sheets
  • Use basic formulas and functions
  • Page setup and print worksheets
     

Workshop Topics:

  • Creating a Basic Worksheet
  • Navigate and select in Excel
  • Customize the interface
  • Performing Calculations
  • Create basic formulas
  • Calculate with functions
  • Copy formulas and functions
  • Modifying a Worksheet
  • Manipulate data
  • Insert and delete cells, columns, rows
  • Search for data
  • Formatting a Worksheet
  • Modifying a worksheet’s appearance, fonts, borders, colours
  • Column width and row height
  • Apply number formats
  • Cell styles
  • Printing Workbook Contents
  • Print workbook contents
  • Setting print options and page breaks
  • Managing Large Workbooks
  • Format worksheet tabs
  • Manage worksheets
  • Ottawa Branch

    858 Bank Street, Suite 109, Ottawa

Check out more MS Excel courses in Canada

ETS Formation Logo

Become Efficient With Excel

Effectively use formatting techniques to present data in an Excel spreadsheet. Focus on presenting beautiful spreadsheets.

by ETS Formation [Claim Listing ]
Mohawk College Logo

Excel 101 Workshop (INFO10255)

Learn a variety of Excel features through this half-day workshop. The user will be introduced to pivot tables and pivot charts, lookup functions, auto outlines, subtotals, scenarios, financial functions, filters, and advanced tips and tricks.

by Mohawk College [Claim Listing ]
Office Instructor Logo

Microsoft Power Point

Learn how to use the vast array of features and functionality contained within PowerPoint to create engaging, dynamic, multimedia presentations. Gain the skills you need to organize your content, enhance it with high-impact tables, charts, and graphics, and deliver it with a punch.

by Office Instructor [Claim Listing ]
CIMT College Logo

Microsoft Access

The course covers from basic to advance functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, data entry forms, multilevel reports, and multi-table queries.

by CIMT College [Claim Listing ]
Learning Tree International Logo

Microsoft Excel Training (Intro)

Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers.

by Learning Tree International [Claim Listing ]

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