Microsoft Excel 2016 Basic

Download as pdf or txt
Download as pdf or txt
You are on page 1of 1

@ASK Training Pte Ltd

Microsoft Excel 2016 - Basic


Course Code: ASKEB6
Course Duration: 2 days (16 hours), 9:00am - 5:00pm
Course Fee: $353.10 (Inc. GST) per participant, SDF grant entitled.
Course Date: Refer to http://asktraining.com.sg/calendar
Course Outline:
Program Fundamentals  Adding Cell Borders and Background Colors
 Starting Excel 2016  Copying Formatting
 Understanding the Excel Program Screen  Applying and Removing Cell Styles
 Giving Commands  Creating and Modifying Cell Styles
 Customizing the Quick Access Toolbar  Using Document Themes
 Using Command Shortcuts  Applying Conditional Formatting
 Creating a New Workbook
 Open, Save & Close a Workbook Managing Workbooks and Print layout
 Using Help & Exiting Excel  Using Workbook Views
 Select & Switch Between Worksheets
Getting Started with Worksheets  Insert & Delete Worksheets
 Navigating a Worksheet  Rename, Move & Copy Worksheets
 Entering Labels and Values  Splitting and Freezing a Window
 Selecting a Cell Range and Entering Data in  Working with Multiple Workbook Windows
a Cell Range  Creating Headers and Footers
 Entering Content Automatically  Hiding Rows, Columns, Worksheets
 Overview of Formulas and Cell References  Previewing & Printing a Worksheet
 Entering Formulas  Setting the Print Area
 Formulas with Multiple Operators  Adjusting Page Margins and Orientation
 Referencing External Data  Adding Print Titles, Gridlines, Headings
 Adjusting Paper Size and Print Scale
Editing a Worksheet  Printing a Selection, Multiple Worksheets,
 Editing Cell Contents and Workbooks
 Copying and Moving Cells  Creating a Template
 Controlling How Cells Are Moved or Copied  Protecting a Workbook
 Collecting Items to Move or Copy  Protecting Worksheets
 Checking Spelling
 Using and Customizing AutoCorrect Working with Data Ranges
 Insert Cells, Rows, and Columns  Sorting by One Column
 Delete Cells, Rows, and Columns  Sorting by Colors or Icons
 Using Undo and Redo  Sorting by Multiple Columns
 Finding and Replacing Content  Filtering Data
 Finding and Replacing Formatting
 Adding Comments to Cells Introduction to Charts
 Choosing and Selecting the Source Data
Formatting a Worksheet  Choosing the Right Chart
 Formatting Text  Changing Chart Layout and Style
 Formatting Values  Changing Chart Type
 Adjusting Row Height and Column Width
 Working with Cell Alignment

Contact: +65 6484 6723 HQ: 8 Jurong Town Hall Road, #27-01 The JTC Summit Singapore 609434
www.asktraining.com.sg Branch: 229 Mountbatten Road, #03-43 Mountbatten Square Singapore 398007

You might also like