Category Archives for "Excel"

RIGHT and LEFT Functions in Excel

Left & Right function in Excel 1. LEFT: Definition: LEFT function in Excel returns the left-hand side characters from a text string based on the number of characters specified by the user. Arguments/Syntax: LEFT(text, [num_chars]) text: It is a required argument. It is the text string that contains the characters user wants to extract a […]

Continue reading
  • August 12, 2018
  • Excel

Scrape Website Data with Excel or Power BI

Scraping website data can be done easily using Power Query in Excel or by using Power BI. Both these tools have the ability to scrape tabular data from a website. The applications will search for a table within in the website and allows you to import it into the data model or Excel. Follow the instructions […]

Continue reading
  • August 7, 2018
  • Excel

Count Unique Values in Excel

Counting unique values in Excel Summary: One of the most common requirements of data manipulation is to either remove duplicates from the data or get the unique count of values. Although, excel doesn’t provide any default function to get the unique count of values but still the removing of duplicate values and getting the unique […]

Continue reading
  • August 6, 2018
  • Excel

Change Horizontal Axis Values in Excel 2016

Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016. You will add corresponding data in the same table to create the label. You can also create a new set of data to populate the labels. 1. Select […]

Continue reading
  • July 16, 2018
  • Excel

Excel Pivot Table Tips & Tricks

Pivot Tables: Pivot tables in Excel are considered as the most important tool. A pivot table allows the users to organize and summarize the selected columns of data to develop a required analysis report. Using pivot table user can do quick data analysis and it is quite easy to use as well. In this article, […]

Continue reading
  • June 22, 2018
  • 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