About Course

Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This course teaches Microsoft Excel basics as a prelude to the use of Statistical Analysis System (SAS) software in carrying out more complex statistical analysis.

What Will You Learn?

  • How to use Inbuilt functions
  • How to use Absolute referencing formulae
  • How to use Nested-if functions
  • VLOOK AND HLOOKUP
  • Logical IF functions
  • Concatenation formulae
  • Create a workbook
  • Add a worksheet to an existing workbook
  • Copy and move a worksheet
  • Search for data within a workbook
  • Navigate to a named cell, range, or workbook element
  • Insert and remove hyperlinks
  • Change worksheet tab color
  • Rename a worksheet
  • Change worksheet order
  • Insert and delete columns or rows
  • Change workbook themes
  • Adjust row height and column width
  • Insert headers and footers
  • Hide or unhide worksheets
  • Hide or unhide columns and rows
  • Customize the Quick Access toolbar
  • Modify document properties
  • Display formulas
  • Create custom number formats
  • Configure data validation
  • Create custom conditional formatting rules
  • Create conditional formatting rules that use formulas
  • Manage conditional formatting rules
  • Apply styles to tables
  • Configure table style options
  • Insert total rows
  • Filter records
  • Sort data by multiple columns
  • Change sort order
  • Remove duplicate records
  • Insert references
  • Perform calculations by using the SUM function
  • Perform calculations by using MIN and MAX functions
  • Perform calculations by using the COUNT function
  • Perform calculations by using the AVERAGE function
  • Perform logical operations by using the IF function
  • Perform logical operations by using the SUMIF function
  • Perform logical operations by using the AVERAGEIF function
  • Perform statistical operations by using the COUNTIF funnction
  • Concatenation function
  • How to rename multiple file names in a folder using excel and DOS

Course Content

Introduction

  • Introduction
    04:17

Manage Workbook Options and Settings

Perform Operations with Formulas and Functions

Student Ratings & Reviews

No Review Yet
No Review Yet
ZK200

Material Includes

  • assignments
  • videos
  • Articles

Requirements

  • Good internet connection
  • Laptop
  • Microsoft office package installed on the computer
  • being able to Practice and practice

Audience

  • Anyone willing to learn Excel

Want to receive push notifications for all major on-site activities?