Prerequisites
Participants who wish to attend this training must at least have basic PC skills or working knowledge of Windows
Course Description
Most jobs require basic knowledge in using Microsoft Excel. Any employee should at least know its user interface, have the ability to enter and format data, calculate totals and summaries through basic formulas or create simple reports and charts.
This 2-day instructor-led training will teach beginning Excel users the basic functionalities to use and navigate Microsoft Excel 2013 or 2016.
Course Objectives
Upon completion of this course, participants will be able to:
-
Explore the Excel window
-
Use help and the Office Assistant
-
Open, close, and navigate workbooks
-
Create workbooks
-
Enter and edit data
-
Enter and edit formulas
-
Use functions like SUM, AVERAGE, MIN, MAX, & COUNT
-
Format worksheets
-
Print a worksheet
-
Specify page setup options
-
Create, modify, and print charts
-
Save worksheets as Web pages
-
Insert and edit hyperlinks in worksheets
-
Send workbooks via email
-
Hide and display data
-
Print large worksheets
-
Work with multiple worksheets and workbooks
-
Customize toolbars and menus
-
Use chart formatting options
-
Create combination charts
-
Add borders and shading to a cell or range of cells
-
Work with dates
-
Work with styles
-
Merge and split cells
-
Sort and filter lists
-
Trace errors
-
Protect a worksheet by using passwords
-
Merge and share workbooks
-
Create and manage templates
Who Should Attend
Working professionals from any job level or function or students using Windows-based PCs and wishing to use Microsoft Excel 2010, 2013 or 2016.