Masterclass Microsoft Excel 2013: Formulas
- Offered byXLNC
Masterclass Microsoft Excel 2013: Formulas at XLNC Overview
Duration | 6 months |
Total fee | ₹1,999 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Masterclass Microsoft Excel 2013: Formulas at XLNC Highlights
- Earn a certificate after completion of course from XLNC
Masterclass Microsoft Excel 2013: Formulas at XLNC Course details
For Everyone who wants to be Master at Excel Formulas
Introduction to Formulas in Excel 2013
Cell References and Range Naming
Working with Built-in Excel Functions
Logical Functions and Conditional Statements
Text Manipulation and Data Cleaning
Introduction to array formulas and how to use them
The Masterclass Microsoft Excel 2013: Formulas course is designed to take your Excel skills to the next level by focusing on the powerful formula and function capabilities of Excel 2013
Whether you're a beginner looking to understand the basics or an experienced user wanting to master advanced formulas, this course will teach you how to harness the full power of Excel’s formula tools
Masterclass Microsoft Excel 2013: Formulas at XLNC Curriculum
Welcome
Introduction
The Work Files
Reviewing the basics
Formulas
Guide to the Work Files
Mathematical calculations
Counting Numbers
Counting Specific Items
Statistics
Central Tendencies
Central Variations
Data Analysis Toolpak
Using the Toolpak
Understanding addressing
Relative vs. Absolute
Name Box to Anchor Cells
Edit Names
Reference to Other Sheets and Books
Introduction to functions
Using the Function Wizard
Syntax of a Function
Popular expressions
VLOOKUP
Names in VLOOKUP
The IF Function
The Nested IF Function
The AND Function
IF with VLOOKUP
Working with text
Text Functions
Concatenation
SUMIF
Working with dates
Adding Dates
Difference Between Dates
Converting Dates
Other courses offered by XLNC
Student Forum
Anything you would want to ask experts?