MICROSOFT EXCEL ESSENTIALS

Level:Covers the Basic and Intermediate Functions of MS Excel

Duration:2 days; 9:00 am – 5:00 pm (16 hours)

OVERVIEW

Basic Microsoft Excel will teach you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set. IF statements combine to number functions

  • Fundamentals of Formulas
  • Simple Operations
  • Basic Data Reporting
  • Printing Preferences

LEARNING OBJECTIVE

At the end of this training course, learners will:

  • Navigate Microsoft Office Excel software at the feature and functionality level.
  • Be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel
  • Be able to use Microsoft Office Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations.
  • Create personal documents which may include family monthly budget, daily work schedule, or personal money tracker
  • Create business-related reports such as project budget, financial report, loan tracker, or client database

TARGET AUDIENCE

This course is intended for novice information workers who want to learn beginning and intermediate Microsoft Excel skills

LEARNING OUTLINE

TOPIC 1: THE BASICS

  • Understand and use common Windows elements
  • Launch Excel
  • Understand the concept of a spreadsheet
  • Recognize Excel screen elements
  • Work with Toolbars
  • Use Menus
  • Get Help

TOPIC 2: MOVE AROUND AND ENTER DATA

  • Navigate between worksheets
  • Navigate to any point in a worksheet
  • Enter numerical or textual data
  • Edit entered data or delete it
  • Selecting various parts of sheet or workbook simultaneously

TOPIC 3: FORMULAE AND FUNCTIONS

  • Understand the difference between functions and formulae
  • Enter by typing, simple functions and formulae
  • Understand and use BODMAS
  • Enter functions and formulae in using mouse, keyboard or ribbon.
  • Use basic conditional functions
  • Use the Fill handle to enter multiple formulae
  • Understand and use Absolute and Relative cell references

TOPIC 4: FILE OPERATIONS

  • Open and close files
  • Create new files
  • Save files
  • Understanding file types and filenames
  • Save files with different names in different locations
  • Save as different types of files

TOPIC 5: MOVING AND COPYING DATA

  • Use cut copy and paste
  • Drag and drop information
  • Transfer data between files

TOPIC 6: FORMATTING

  • Format cell appearance
  • Format data appearance
  • Format rows and columns
  • Use and understand the format dialog box
  • Merge and unmerge cells
  • Change row and column heights
  • Change orientation of cells and data

TOPIC 7: NAMES

  • Name cells and ranges by three methods
  • Edit names
  • Manage names
  • Sort and filter names
  • Use names in functions

TOPIC 8: WORKING WITH SHEETS

  • Rename worksheets
  • Create worksheets
  • Copy and move worksheets
  • Create formulae and functions across worksheets
  • Group worksheets
  • Protect worksheets
  • Work with document windows

TOPIC 9: PRINTING

  • Set up printing preferences using the page setup dialog
  • Use the ribbons for setting up page preferences
  • Insert and edit Headers and Footers
  • Use Print preview and page layout views
  • Scale printing to a fixed set of pages
  • Set page breaks
  • Set up and change Margins by various methods
  • Print and collate multiple copies
  • Set up print areas
  • Change print quality
  • Print page ranges or entire workbooks.

TOPIC 10: UTILISING LARGE WORKSHEETS

  • Split screen
  • Freeze panes
  • Use zoom controls
  • Use name box to navigate
  • Use Go to command

TOPIC 11: CUSTOMISING EXCEL

  • Access and change Excel settings
  • Create excel ribbons
  • Edit existing ribbons
  • Edit quick access toolbar
  • Set language choices
  • Set defaults for Excel

OUR PARTNER’S PROFILE

  • Microsoft Certified Professional (MCP), Microsoft Office Specialist (MOS), Microsoft Technology Associate (MTA), TESDA NCII Computer Hardware & System Servicing, National TVET Trainer’s Competency, BS Computer Engineer, Rizal Technological University
  • Over 6 Years in IT Professional Training for Government and Corporate Accounts; Certified IT Trainer of BSP, DTI, DEPED, Pag-ibig Fund, Coca-Cola, Jollibee, San Miguel Corporation, SM Supermalls
  • Director for Technical Curriculum Development, Academics Manager, 2014 Academic Excellence Award for Most Outstanding Academic Trainer
  • Proficient in Office Productivity, Database Management, and Computer Programming

UPCOMING PUBLIC TRAINING SCHEDULE

Please view here.

For inquiries on registration, course content, course customization, and on-site training, please click here.