Category Archives for "Excel"

Essential Excel Formulas for Accounting

Accounting Functions in Excel Use these essential functions to save time and speed up your accounting task. Excel may not take the place of QuickBooks but useful tips to help you clean up your accounting. For more ways to improve your Excel skills, check Master Excel Beginner to Advanced Compound Interest: A user can calculate […]

Continue reading
  • April 23, 2018
  • Excel

Excel Random Number Generator

There may be many cases where you need to create a random number generator. Luckily, Excel has a few native functions that will help achieve your goals. If you want to learn more about Excel,  Get 60% Off Online Excel Courses RAND() When you type the RAND() function in a cell  you will get a number […]

Continue reading
  • March 24, 2018
  • Excel

How to Properly Delete Blank Rows in Excel

Data rarely comes perfectly clean, without errors and well organized. Often, you will have to take steps to ensure that your data is in the best working order, One of the biggest issues is having blank rows in Excel that interrupt your data. Of course, if your data set is very small, you can simply […]

Continue reading
  • March 20, 2018
  • Excel

How to Use Excel IF Functions A to Z

IF-ELSE Excel Functions What is IF-ELSE functions in Excel: Definition: The IF function in excel returns one value if the condition is True and another value if it’s false How IF functions  work: Arguments/Syntax: IF ([Condition],[Value1],[Value2]) [Condition]: It can be any logical condition like greater than, smaller than or equals to value [Value1]: This value […]

Continue reading
  • March 18, 2018
  • Excel

70 Excel Keyboard Shortcuts to Save Time

One thing that I love to do more than anything is save time. So, here is a collection of some of the most useful Excel Keyboard shortcuts. These should help you become much more efficient and leave more time to analyze and visualize your data. These 70 tips range from general to data operation. If […]

Continue reading

Top 10 Text Functions in Excel

   Top 10 TEXTS Functions in Excel   Transforming and cleaning text is an essential for any analyst, teacher or secretary.  Luckily Excel provides a quick and easy ways to transform text in a spreadsheet using using native functions.   FIND: Definition: The FIND function is used in Excel to locate the position of the required […]

Continue reading
  • December 17, 2017
  • Excel

How to Remove Spaces in Cells in Excel

A big part of cleaning up data is removing spaces in cells with text. Usually, these spaces are imported when text is copied or pasted in Excel. Luckily, there is an easy function that you can use to remove leading and trailing spaces in cells with text. This function is called TRIM. How to Remove […]

Continue reading
  • November 26, 2017
  • Excel

How to Find Outliers in Excel

Excel has a lot of underused function that can greatly improve your data analysis. One of the best features is it’s statistical capabilities So you can find outliers in Excel easily with simple statistics formulas.. Why should you isolate and eliminate outliers in your data? One of the main reasons is that these extreme data […]

Continue reading
  • July 13, 2017
  • Excel

Best Online Excel 2018 Courses

The Best Courses to Master Excel  2016 Data Analysis Anyone who works with data knows that one of the most used data tools is Excel.  This is not only an essential tool but it is also the number one spreadsheet tool on the planet. Only followed by OpenCalc and Google Sheets.  On the whole those with advanced […]

Continue reading
  • June 22, 2017
  • Excel