MOF 003 – Microsoft Excel (Beginner & Intermediate) 25 & 26 July 2023

MOF 003 – Microsoft Excel (Beginner & Intermediate) 25 & 26 July 2023

Teachers
Beatrice V. Xavier
Category:
IT PP/ Public Programs/
RM 1,990.00
D4 (4)

RM 1,990.00

Duration: 2 Days
Lectures: De Palma Hotel
Certificate of Completion

Objective

This course introduces participants to the basic and Intermediate levels of Microsoft Excel environment.

    • Participants will learn the basics skills necessary to create and edit basic worksheets and workbooks, enter data, formulas, format and print workbooks.
    • Participants gain knowledge on working with Name Ranges, more complex formulas and functions, Charts, filtering and sorting tables and adding subtotals. Participant will know how to highlight important data using conditional formats. At the end of the course, the participant will be able to demonstrate the ability to perform complex calculation and manage data efficiently with Microsoft Excel.

Target Audience

Designed for anyone with minimal or no prior knowledge of Microsoft Excel and looking to acquire solid foundational skills that is neccessary to create and perform basic spreadsheet functions.

Methodology

Participants need to know basic Windows, keyboarding and mouse skills as well as have a basic understanding of using files and folders. Participants need not have prior knowledge of Microsoft Excel.

2 Days Training Content

This content is restricted to members only. Please log in to view more details. Registration are Free!

Day One (9am-5pm)

  • Exploring the Excel Interface
  • Creating and saving a workbook
  • Opening and closing a workbook
  • Saving Files and opening files in Office 365
  • Navigating in a Worksheet

  • Entering and editing data in cells
  • Copying and moving data
  • AutoComplete data
  • AutoFill data
  • Finding and replacing data

  • Understanding Formulas
  • Entering a simple formula
  • Editing formulas
  • Copying formulas
  • Absolute and relative formulas
  • Understanding Functions
  • Using the Autosum, Average, Count, Max and Min Functions

  • Modifying column width and row height
  • Inserting additional rows and columns
  • Deleting rows and columns
  • Applying Font formats
  • Applying Number formats
  • Applying Borders and Shading
  • Applying cells styles
  • Changing Text Alignment and wrapping text
  • Merging cells
  • Copying and reapplying cell formats
  • Clearing cell formats
  • Applying table styles

  • Naming worksheets
  • Copying and moving worksheets
  • Grouping worksheets
  • Moving data between sheets
  • Adding and deleting worksheets

  • Creating Charts
  • Modifying chart
  • Printing a chart

Day Two (9am-5pm)

  • Changing View Options
  • Freezing and Splitting a Worksheet
  • Inserting Headers and Footers
  • Inserting Page Breaks
  • Setting Page orientation
  • Setting Margins
  • Viewing and Printing Gridlines and Headings
  • Printing Titles on every page
  • Setting a Print Area
  • Previewing and Printing Worksheets

  • Understanding and Defining Named Ranges
  • Editing Named Ranges
  • Using Named Ranges in Formulas

  • Text Functions
  • Upper, Lower Proper
  • Concatenate
  • Date & Time Functions
  • Inserting Current Date and Time
  • Date Calculations using
  • Datedif
  • Mathematical & Statiscal Functions
  • Countif
  • Sumif,
  • Averageif
  • Logical Functions
  • If Function

  • Applying table format to data
  • Sorting data in a table
  • Filtering data in a table
  • Removing table format

  • Conditional formatting based on cell value
  • Conditional formatting based on formulas

  • Tracing Formula Precedents and Dependents
  • Showing Formulas
  • Evaluating Formulas
  • Using the Watch Window

About Instructors

Beatrice V. Xavier
- Microsoft Word - Microsoft Excel, Excel Formulas & Functions, Pivot Tables - Microsoft PowerPoint - Microsoft Access - Microsoft Outlook