Excel Formulas: 10 Formulas That Helped Me Keep My Job


Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports.

Here are the most 10 functions used in term of data processing in Excel:

Top 10 Functions in Excel

Goals for Day 2

1- Pivot Table:

Try IT

2- Date & Time Functions:

Try IT

3- Two-way Lookup

Try IT

4- Data Validation

Try IT

Goals for Day 3

1- Data Analysis ToolPak

Try IT

2- Project 1

File

Document

Goals for Day 4

1- Correlation analysis

Try IT

Example file

2- Regression Analysis

Try IT

Example file

3- Charts

Try IT

4- Drop List

Try IT

Goals for Day 5

1- Automated Invoice

Try IT

2- Registration Form

Register!

3- Some useful web-Application

a) www.smartsheet.com

b) https://www.xlstat.com/en/

c) KUTOOLS

4- Create Excel Dashboard

Watch Video!


176 views

© 2020 by Advancement Consulting Solutions (ACS)