Wednesday, December 2, 2020

MS Excel (INTERMEDIATE)

Start Date:

February 26, 2020

Start Time:

9:00 am

Location

University of Cyberjaya , Cyberjaya

Introduction

These intermediate Microsoft Excel courses are designed for delegates who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.

MS Excel (INTEREMEDIATE)

At the end of the training participants will be able to;
  • Quickly summarize multiple sheets of data into one
  • Turn long lists and reports into easy to read tables
  • Use formulas to check whether cells pass or fail your rules
  • Create links between cells so that they all update automatically
  • Highlight targets, trends, duplicates and errors with Conditional Formatting
  • Formatting and layout consistency by saving as Template
1. Working with Large Worksheets
  • Viewing options
  • Adjusting zoom
  • Using Freeze Panes
  • Using Split Window Hiding and displaying data
  • Hiding rows and columns
  • Creating an outline Printing large worksheets
  • Page Break preview
  • Working with page breaks
  • Printing multiple sheets
2.Working with Multiple Worksheets and Workbooks
  • Using multiple worksheets
  • Navigating between sheets
  • Moving and copying sheets Linking worksheets
  • Creating 3-D formulas
  • Consolidating data Linking workbooks
  • Creating a formula to link workbooks
  • Using the Paste Link option
  • Maintaining links
3.Working with Dates
  • Entering date functions
  • TODAY function
  • NOW function Date and time formats Using dates in formulas
4.Conditional Formulas and Formatting
  • The IF function Conditional formatting
  • Based on a cell value
  • Based on a formula
  • Identifying cells with conditional formatting
  • Copying conditional formats
5.List Management
  • Working with lists
  • Structure of a list Sorting and filtering lists - Simple sorting
  • Sorting by multiple columns
  • Using AutoFilter Advanced filtering
  • Using custom filter
  • UsingAdvanced Filter Adding subtotals to a list
6.Documenting and Auditing
  • Comments
  • Viewing, adding, editing and deleting comments
  • Auditing features
  • Tracing formula errors Protection
  • Protecting a worksheet
  • Protecting cell ranges Using Templates, Built-in templates
  • Accessing and using Excel’s templates
  • Creating and managing templates
  • Creating, using and modifying a custom template file
Excel users with a good understanding of basic Excel and able to automate reporting with functions and formulas.

Click here to download E-flyer

Event Days

2 Day Programme

Sorry, Event Expired

Location

Total Seat: 20
  • University of Cyberjaya
  • Persiaran Bestari, Cyber 11
  • Cyberjaya
  • Selangor
  • Malaysia

Event Schedule Details

  • February 26, 2020
    9:00 am - February 27, 2020 - 5:00 pm
Share This Programme
ADD TO YOUR CALENDAR