• Post category:StudyBullet-5
  • Reading time:7 mins read


What you will learn

Learn About Introduction to Excel shortcuts,The Ctrl + [A-Z],The F[1-9]

Learn About Working with Ribbon,Navigation and Drag and Drop,Selelction and Ribbon and Formatting and Number Formatting

Learn About Work shortcuts and Formulas

Learn About Anyone who wants to learn more features and functions of Microsoft Excel 2016

Description

Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.

The training will help you learn about Introduction to Excel shortcuts,The Ctrl + [A-Z],The F[1-9],File formatting,Working with Ribbon,Navigation and Drag and Drop,Selection and Ribbon,Formatting and Number Formatting,Work shortcuts,Formulas.

This training is ideally suited for students, home-makers and professionals – essentially anybody with a need for spreadsheet skills.

Microsoft estimates that a staggering 5 million users utilize at least one Office product, with Word and Excel being the most popular of their products. Hence this course is beneficial to a large spectrum of people, including Administrative staff, Secretaries and Personal Assistants, Retail Professionals, Store Supervisors, Business Analysts, Data-mining experts, Accountants, Project Managers, Marketing and Sales professionals and Investment Bankers. This course helps you develop a thorough understanding of Excel’s extensive Chart/Graph features. With this, you’re exposed to the best ways to capitalize on your data, and illustrate their value for maximum effect.


Get Instant Notification of New Courses on our Telegram channel.


English
language

Content

Introduction

Introduction to Excel reports

Shortcut Function

Shortcut Key Function – F6
Shortcut Key Function – F10
Formatting Text and Numbers
F2 and Shit Plus F2
CTRL Plus Apostrophe
CTRL Plus Shift Plus Tilde

Excel_Functions

Entering a Formula
Entering a Function
Operator Precedence
Name and Formula in Excel
Count functions in Excel
Sum Functions in Excel
More in Count Functions in Excel
Counts of Logical Values in Excel
Sum Product Function in Excel
Average Counting Blank and Non Blank
Offset and Concat Function in Excel
Relative Reference in Excel
Absolute and Mixed Reference in Excel
Logically if Function in Excel
Logically AND & OR Function in Excel
Nested if and Switch Function
Example of Logical Function
Basic of Date and Time Format
Dated if and Weekday Function
Network Day Function
Work Day Function
Example of Date and Time Function
String Concentration Function
Upper and Lower Function
Lenth of the Function
Trim and Clean Function
Search and Concat Function

Vertical Lookups

Vertical Lookups (v LOOKUPS)
Horizontal Lookups (H Lookups)
Match Function
Left V Lookups
Tow Ways Lookup
Tow Ways Lookup Continues
Example of Lookups

Financial Function

PMT Financial Function
Loan with Different Terms
Loan with Different Terms Continues
PPMT and IPMT
Example of PPMT and IPMT

Average If Function

Average and Average If Function
Random Number and rank Function
Random Number and rank Function
Random Number and rank Function Continues
Percentile and Quadrilles
Round and Even Odd Function
Trendline and Trend Analysis
Trendline and Trend Analysis Continues
Round up and Round Down Function
INT and TRUNC Function