Microsoft Excel Level 1

Microsoft Excel Training Philippines

Download PDF
Microsoft Excel Level 1

COURSE CODE

121

DURATION

1 day

Overview

Courses Benefits

Microsoft Excel is the industry leading tool to help workers work with data on the desktop. This Excel training course enables you to become more productive by allowing you to automate data processing essential to your daily work.

You Will Learn How To

  • Create and format workbooks
  • Enter and format data
  • Summarize data using formulas and functions
  • Sort and filter data
  • Use time-saving tools such as AutoFill, AutoSum, and FlashFill
  • Properly prepare a spreadsheet for printing

Who Should Attend

Anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing.

Course Investment

Course Outline

The Excel Interface

  • Getting Started
  • Signing In
  • The Ribbon, Groups, and Tabs
  • Excel Templates
  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook

Entering Data

  • Selecting Data
  • Entering Text, Numbers and Dates
  • Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste
  • Using Paste Special
  • Using Find and Replace

Working with Cells, Rows and Columns

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Hiding and Unhiding Cells
  • Hiding and Unhiding Rows
  • Hiding and Unhiding Columns
  • Sorting a Column
  • Filtering Rows

Working with Worksheets

  • Adding Worksheets
  • Deleting Worksheets
  • Copying Worksheets
  • Moving Worksheets
  • Hiding a Worksheet
  • Adding Color to Worksheet Tabs
  • Viewing Multiple Worksheets at Once
  • Viewing Multiple Parts of a Worksheet at Once
  • Freezing the Top Row
  • Freezing the First Column

Using Formulas and Functions

  • Understanding Cell References
  • Using SUM()
  • Using AVERAGE()
  • Using COUNT()

Using Time-saving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate

Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting
  • Using Format Painter

Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format
  • Changing Date Format

Formatting the Workbook

  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background

Printing Your Workbook

  • Using Excel's Different Views
  • Using Print Preview
  • Specifying Number of Copies to Print
  • Selecting a Printer
  • Other Printing Settings
  • Specifying Page Orientation
  • Specifying Page Size
  • Changing Margins
  • Centering on Page
  • Adding Headers and Footers
  • Printing Portions of a Worksheet
  • Scaling to Fit Page
  • Repeat Headers on All Printed Pages

Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Schedule

Nov 15, 2021 (Also available Live Online Training)

Reviews

"Instructor was very eager to discuss the topics and answer the questions with good amount of knowledge and experience"

Microsoft Excel Level 1

Jeizmon L. Sagaran

Associate Channel Operations Manager, Infor PSSC

"Our instructor is very approachable and knowledgeable of the subject matter. He sees to it that we clearly understood the chapter before heading on to the next. The course content covered clearly the complex topics in which I expected to learn about. What I liked the most is the use of pivot tables, vlook up/hlook up and the named ranges, as these will be helpful for me in my field of work. Thank you, ActiveLearning, for the smooth processing in my enrollment and to the admins who assisted us well."

Microsoft Excel Level 1

Janine Yonzon

Treasury Analyst, Shopee

"I like how our instructor acknowledged the area of excel that we want to know more, he clearly state the objective in class, provide thorough explanation of the subject matter, discuss the course in a way that we understand it even though some of us were first timer and did not attended any formal training in excel prior this course and lastly he make sure that we understand the training by providing concrete sample relating to our work and everyday life."

Microsoft Excel Level 1

Brendelmeri Divina

Accounting Analyst, Aboitiz Power Corporation

"The course content and the flow of the lecture topics were easy to follow and track throughout the lecture."

Microsoft Excel Level 1

Alexandra Gatchallan

United Laboratories Inc. (Unilab)

"The course met my expectations. I gained additional skills and knowledge. The activities are easy to follow and understand. Content is really useful for my work ."

Microsoft Excel Level 1

Ella Marie Grace Lingao

Land Bank of the Philippines

Request More Info