MS Excel Foundation And Intermediate

MS Excel Foundation And Intermediate

INTRODUCTION

MS Excel Foundation & Intermediate enables participants to improve their accuracy and productivity by handling large worksheets more effectively as well as enhancing the formatting of spreadsheet data by using conditional formulas.

OBJECTIVES

Upon completion, participants will be able to;

  • Understand why and how to use the MS Excel
  • Understand how an Excel file is structured
  • Use an Excel file and input data & contents
  • Format spreadsheet
  • Calculate file results using basic formulas and calculations

Upon completion, participants will be able to;

  • Understand why and how to use the MS Excel
  • Understand how an Excel file is structured
  • Use an Excel file and input data & contents
  • Format spreadsheet
  • Calculate file results using basic formulas and calculations

KEY TOPICS

  • THE USE OF EXCEL TOOLS
  • HOW TO USE/ADD & DELETE WORKSHEETS
  • HOW TO CUSTOMIZE THE BACKGROUND COLOR, FONT COLOR IN CELLS AND RANGES
  • HOW TO COPY & PASTE CONTENT, DATA AND FORMAT
  • HOW TO OPEN, SAVE & PRINT EXCEL FILE
  • HOW TO INSERT, MODIFY, ALIGN & FORMAT IMAGES & OBJECTS IN EXCEL WORKSHEET
  • HOW TO INSERT CHARTS INTO SPREADSHEETS
  • HOW TO CUSTOMIZE THE LAYOUT OF THE SPREADSHEET PAGES
  • HOW TO USE BASIC FORMULAS (SUM, AVERAGE, COUNT, IF, MAX, MIN…)
  • HOW TO CUSTOMIZE THE VIEW OPTION OF YOUR WORKSHHET

TARGET AUDIENCE

  • Anyone who wants to learn how to use MS Excel as a student or for professional purposes
  • Anyone who does calculations & report results on spreadsheet or tables

Related Courses

SOCIAL MEDIA COMPLAINTS MANAGEMENT

Customer communications have evolved with the introduction of social media. In the past, customers can only send their written feedback 

CYBER SECURITY

Every organization is responsible for ensuring Cyber Security. The ability to protect its information systems from impairment or even theft is essential to  

MS PROJECT

Microsoft Project is a project management software program, that is designed to assist a project manager in developing a plan, assigning resources