Microsoft Excel Formulas & Functions

Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. Attending a live Excel course is a good way to quickly and efficiently learn Excel. There are 3 primary reasons why you should learn Excel and how learning Excel is helpful for your career.

Objectives:

• Learning Excel increases your value in the job market
• Excel training makes you more efficient
• Conditional formatting allows you to apply format to a cell or a range of cells based on a given criteria which will make data easier to read
• Pivot tables and charts will allow you to quickly identify trends in large datasets and inform business decisions
• Learning Excel prepares workers for Data centric positions

Course Outline:

• Module A: About Formula
• Operators in Formulas
• Cell and Range Reference
• Convert Formulas to Values
• Hiding Formulas
• Module B: About Range Names
• Naming Methods
• Create Multisheet Names
• Working with Range and Cell Names
• Problems with Range Names
• Use Functions to Name a Range
• Module C: About Worksheet Functions
• Function Argument Types
• Ways to Enter Functions
• Text Functions
• Data & Time-Related Functions
• Counting & Summing Functions
• Lookup Functions
• Database Functions
• Rounding Numbers
• Module D: About Array
• Introduction on Array Formulas
• Dimensions of Array
• Working with Array Formulas
• Using Single-Cell and Multicell Array Formulas