Rumus & Shortcut Excel Lengkap

Tutorial Using Functions / Formulas Excel and Excel Shortcut Complete Offline

In the world of Excel computer is an application that is quite popular and is often used by many people to complete tasks and work. There are many formulas / functions in Excel applications that we can use to help complete our tasks and work.

Excel Complete Formula & Shortcut Application is an application that contains a tutorial on how to use excel formulas and functions. This application aims to facilitate us in learning Excel Functions and Formulas.

There are hundreds of Excel Formulas in this application, including:

 ★ Logic Formulas (AND, OR, NOT, and IF Functions)

 ★ Mathematical Formulas (SUM, COUNT, AVERAGE, etc.)

 ★ Logarithmic and Trignonometry Formulas (LOG, LN, SIN, COS, TAN Functions)

 ★ Text Processing Formulas (CONCATENATE, FIND, SEARCH, SUBSTITUTE, REPLACE, etc.)

 ★ Date and Time Formulas (SECOND, MINUTE, HOUR, DATE, DATEDIVE, DAY, MONTH, YEAR functions, etc.)

 ★ Lookup and Reference Formulas (VLOOKUP, HLOOKUP, INDEX, MATCH, ADRESS functions, etc.)

 ★ Financial / Financial Formulas (RATE, NPER, PMT, PV, FV functions)

 ★ Information Functions (ISBLANK, ISERROR, ISNA, ISTEXT, ISNUMBER, ISODD, ISEVEN functions)

Besides containing a collection of tutorials on how to use Excel Formulas, the Excel Complete Formula & Shortcut application also features a collection of Shortcut keys / keyboard shortcuts that can make it easier and faster to finish a job.

The material about the shortcuts in this application are:

 Shortcut Keys that are frequently used are often used in Excel

 Shortcut button for access to the Ribbon menu in Excel

 Function Shortcut Keys

 Shortcut key combination Ctrl

 Another useful Shortcut Button

This Excel Formula and Shortcut application is made as good as possible to facilitate users in learning and understanding formulas and functions in Excel. Some of the advantages and conveniences presented in this application include:

Explained the basic understanding of each function / excel formula

Tutorial each step / step by step how to use Excel formula

An example of how to use formulas / functions in Excel is included

There are pictures to make it easier for users to understand formulas and functions in Excel

The application can be read offline without the need for an internet connection

The size of the application is small and very light to run

For those of you who want to learn and understand Excel formulas, you can download this application.

May be useful. Yuk .. Download ..