Basic Microsoft Excel Training (Cebu)

Loading Map....

Date/Time
Date(s) - Jul 27,2018
9:00 am - 5:00 pm

Location
Harolds Hotel

Categories


LESSON 1: CREATING A BASIC WORKSHEET

  • Explore the User Interface and the Ribbon
  • Excel Workbook Windows
  • Basic Spreadsheet Skills
  • Navigate and Select in Excel
  • Enter Data and Save a Workbook
  • Customize the Quick Access Toolbar
  • Excel Help System

LESSON 2: PERFORMING CALCULATIONS

  • Cell Referencing and Request  
  • Create Basic Formulas 
  • Calculate with Functions 
  • Copy Formulas and Functions
  • Auto Sum and Auto Fill Function

LESSON 3: MODIFYING A WORKSHEET 

  • Manipulate Data 
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Understanding Worksheets
  • Editing, Copying and Moving Cells

LESSON 4: FORMATTING A WORKSHEET 

  •  Modify Fonts  
  • Add Borders and Color to Cells 
  • Change Column Width and Row Height 
  • Position Cell Contents 
  • Apply Cell Styles
  • Selecting Cells
  • Formatting Cells
  • Formatting Numbers
  • Placing Cell Alignment

LESSON 5: PRINTING WORKBOOK CONTENTS 

  • Page Layouts in Excel 
  • Print Workbook Contents Using Default Print Options
  • Set Print Options
  • Set Page Breaks
  • Spell Check a Worksheet

LESSON 6: MANAGING LARGE WORKBOOKS 

  • Opening and Closing Workbooks 
  • Understanding Workbook File Formats
  • Creating New Workbooks
  • Format Worksheet Tabs 
  • Manage Worksheets in a Workbook 
  • Manage the View of Large Worksheets

Bookings