Microsoft Excel: Basic & Intermediate

COURSE OBJECTIVE

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. You will also be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

COURSE CONTENT
Getting Started with Excel

Explore the user interface and the ribbon
Navigate and select in Excel
Obtain help 
Enter Data and Save a workbook

Performing Calculation 

Create Basic Formulas 
Calculate with function 
Commonly used Function
Copy formula and function 
Auto fill 

Modifying a Worksheet 

Inserting, Renaming, Deleting, Hiding Worksheet
Inserting, Renaming, Deleting Rows and Columns
Moving and copying Worksheet 
Moving and copying Data’s 

Formatting a Worksheet (Appearance of Worksheet)

Modify Fonts
Add borders and colors cells
Change column width and row height 
Apply number formats 
Varying Decimal in Number Formats 
Cell Styles 
Find and Replace text and numbers on a worksheet 

Managing a Workbook 

Inserting Header and Footer 
Freeze, split options 
Arrange the windows 
Using Sorting, Custom AutoFill Lists 

Printing Workbooks

Printing Workbook 
Set Page break 
Print Area 

Calculating Data with Advanced Formulas

Using Range Names 
Creating & Define Range Names
Using Range Names in Formulas 
Consolidating data 
Using Text and Date Functions 
Using Logical Functions 
Using the Vlookup and Hlookup Functions 

Organizing Worksheet and Table Data

Format Tables 
Modify Tables 
Create a Data List in Excel 
Learn more about filtering 
Common filter 
Clear a filter 

Presenting Data Using Charts

Types of Charts 
Creating Charts and Modifying Charts