Latest Author Post

  • Excel Tutorial PDF: Learn Basics for Beginners
    $20.20 $9.99 for today 4.5 (105 ratings) Key Highlights of Excel PDF: 186+ pages in this Excel eBook PDF A cheap Excel handbook PDF specially designed for beginners Beautifully annotated screenshots in this Excel notes PDF Purchase Excel Book PDF Inside which you will get lifetime access Excel is the…
  • 13 Best Free Microsoft Courses & Certification (2021 Update)
    Microsoft Office is a bundle of productivity software. The primary programs it contains are word processors, spreadsheets, and presentation software. It is a set of business applications with the same style of user interface. Microsoft Office is the most popular software in this category, but it is paid. Following is…
  • 15 BEST Excel Books (2021 Update)
    We are reader supported and may earn a commission when you buy through links on our site Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data. Excel is the most powerful tool to manage and analyze various types of Data. Here is a curated…
  • 20 BEST Free Excel Alternatives Software in 2021
    Excel is a spreadsheet software included in the Microsoft office suite. It widely is used to create grids of numbers and formulas that specify calculations, inventory tracking, and accounting, and more. However, it has some limitations like a lack of security, and controlling different versions of the same file is…
  • 15+ Best Microsoft Excel Courses Online with Certification [2021]
    Excel is a spreadsheet software included in the Microsoft office suite. It is a hugely popular software, widely used to create, share, and collaborate with numbers. It is a powerful tool that helps you perform various kinds of sums, formulas, functions, tables, and charts according to your business needs. Following…
  • Top 10 Excel Formulas Interview Questions & Answers (2021)
    Following are the Most Frequently Asked Excel Formulas in an interview 1) SUM formula: =SUM (C2,C3,C4,C5) In excel, SUM formula is used to calculate the total number. For instance here we had calculated the total number of computer items sold across different region in U.S.A by using formula =SUM (C2,C3,C4,C5)…
  • Top 40 Microsoft Excel Interview Questions and Answers (2021)
    We have organized the most commonly asked Microsoft Excel Interview Questions and Answers that will help you prepare for the MS Excel interview questions and answers that an interviewer might ask you during interview. In this list of MS Excel interview questions, we have covered all frequently asked basic Excel…
  • SUMIF function in Excel: Learn with EXAMPLE
    What is SUMIF Function? SUMIF is the function used to sum the values according to a single criterion. Using this function, you can find the sum of numbers applying a condition within a range. This function comes under Math & Trigonometry functions. Similar to the name, this will sum if…
  • Sparklines in Excel: What is, How to Use, Types & Examples
    What is Sparklines in Excel? Sparkline in Excel is a small graph which is used to represent a series of data. Apart from a well-fledged chart, it fits into a single cell. Three different data visualizations available in Excel Sparkline are: Line Column Win/Loss It is an instant chart that…
  • Excel VLOOKUP Tutorial for Beginners: Learn with Examples
    What is VLOOKUP? Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel. In other words, it allows you to find (look up) a value from one column of data and returns it’s respective or corresponding value from another…
  • Excel ISBLANK Function: Learn with Example
    What is ISBLANK function? ISBLANK function used to check whether a cell is empty or not. Since this is an information function, it always returns a Boolean value, true or false. If the cell contains a value it will return false and true will be returned if it is not…
  • VBA Tutorial PDF: Excel Programming Course (FREE Download)
    $20.20 $9.99 for today 4.6 (119 ratings) Key Highlights of VBA Tutorial PDF 85+ pages eBook Designed for beginners Beautifully annotated screenshots You will get lifetime download access of this VBA Tutorial PDF VBA stands for Visual Basic for Applications. It is a combination of the Microsoft’s event-driven programming language…
  • CSV vs Excel (.xls) – What is the Difference?
    Excel and CSV both help store data in tabular format. Besides this commonality, there is huge difference between Excel and CSV in their respective features and usages. Let’s discuss what is the difference between CSV and Xlsx in detail in this CSV and Excel difference article Difference between Excel Vs…
  • Microsoft Office 365 Cloud: Benefits of Microsoft Excel Cloud
    What is Office 365 Cloud? Office 365 is a cloud-based product suite containing Microsoft programs for office use that can be run locally and synchronized to cloud storage. With the help of Office 365, you can work from anywhere and share the work documents with your colleagues worldwide. It helps…
  • Top 22 VBA Interview Questions & Answers (2021 Update)
    1) Explain what is VBA or Visual Basic for Applications? VBA stands for Visual Basic for Applications; it is an event driven programming language developed by Microsoft. It is predominantly used with Microsoft office applications like MS-word, MS-Access, and MS-Excel. 2) Mention where you can write your VBA program for…
  • Advanced Excel Charts & Graphs [With Template]
    Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. There may be times when we would like to go beyond the basic charts that excel creates for us. This tutorial will focus on…
  • Web Scraping with VBA
    What is Data Scraping? Data scraping is the technique that helps in the extraction of desired information from a HTML web page to a local file present in your local machine. Normally, a local file could correspond to an excel file, word file, or to say any Microsoft office application….
  • How to Create Pivot Table in Excel: Beginners Tutorial
    There will be times when you will be required to analyse large amounts of data and produce easy to read and understand reports. Pivot tables allow us to analyse such data and produce reports that meet our business reporting requirements. In this tutorial, we are going to cover the following…
  • Excel VBA Range Object
    What is VBA Range? The VBA Range Object represents a cell or multiple cells in your Excel worksheet. It is the most important object of Excel VBA. By using Excel VBA range object, you can refer to, A single cell A row or a column of cells A selection of…
  • How to Import SQL Database Data into Excel File [Example]
    Import SQL Data into Excel File In this tutorial, we are going to import data from a external SQL database. This exercise assumes you have a working instance of SQL Server and basics of SQL Server. In this Excel tutorial, you will learn – Import SQL Data into Excel File…
  • Excel VBA Function Tutorial: Return, Call, Examples

    What is a Function?

    A function is a piece of code that performs a specific task and returns a result. Functions are mostly used to carry out repetitive tasks such as formatting data for output, performing calculations, etc.

    Suppose you are developing a program that calculates interest on a loan. You can create a function that accepts the loan amount and the payback period. The function can then use the loan amount and payback period to calculate the interest and return the value.

  • Excel VBA Subroutine: How to Call Sub in VBA with Example
    What is a Subroutine in VBA? A Subroutine in VBA is a piece of code that performs a specific task described in the code but does not return a result or a value. Subroutines are used to break down large pieces of code into small manageable parts. Subroutines can be…
  • VBA Logical Operators: AND, OR, NOT, IF NOT in Excel VBA
    VBA Logical Operators: AND, OR, NOT Excel VBA Logical Operators Let’s say you want to process a customer order. For that, you want to first check to see if the ordered product exists or not. If it does, you also want to check if the quantity on hand is enough….
  • How to Import CSV File into Excel [Example]
    How to Import/Convert CSV to Excel In this tutorial, We will import external data from a simple CSV file containing customer payments. You can download the CSV file for this exercise. Download the CSV File Open a new workbook Click on DATA tab on the ribbon Click on From Text…
  • How to Import XML to Excel [Examples]
    Data is the bloodstream of any business entity. Businesses use different programs and formats to save the data depending on the business data storage requirements. You could have a payroll program powered by a database engine, you could have data in a CSV file or even from a website that…
  • VBA Comparison Operators: Not equal, Less than or Equal to
    VBA Comparison Operators These are operators that are used to compare values. Comparison operators include equal to, less than, greater than and not equal to Comparison operators are used to compare values for validation purposes. Let’s say you are developing a simple point of sale application. In this application, you…
  • VBA String Operators | VBA String Manipulation Functions
    VBA String Operators String data is used to hold data that is made up of numbers, characters, and symbols. “Jul-2015” is an example of a string data. It is made up of Characters (Jul) Symbol (-) Numbers (2015) String operators are used to manipulate string data. For example, you can…
  • Excel Personal Finance: How to Create Budget in Excel Template
    “Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!” – Bradley Vinson It takes discipline to use money properly. In this tutorial, we are going to look at how to use Excel for personal finance to properly manage our budget and finances. We…
  • VBA Arithmetic Operators: Addition, Subtraction, Multiplication
    VBA Arithmetic Operators VBA Arithmetic Operators are used to perform arithmetic operations such as adding, subtracting, dividing or multiplying numbers. The following table shows the VBA mathematical operators Operator Description Example Output + Addition: This operator is used to add up numbers 2 + 2 4 – Subtraction: This operator…
  • How to Create Charts in Excel: Types & Step by Step Examples
    A picture is worth of thousand words; a chart is worth of thousand sets of data. In this tutorial, we are going to learn how we can use graph in Excel to visualize our data. What is a chart? A chart is a visual representative of data in both columns…
  • VBA Controls: VBA Form Control & ActiveX Controls in Excel
    Creating VBA Form/GUI controls in Excel GUI is the acronym for Graphical User Interface. The GUI is the part of the program that the user interacts with. A GUI is made up of controls. These Excel VBA controls can be used in a Form. The following table shows some of…
  • IF, AND, OR, Nested IF & NOT Logical Functions in Excel
    Things will not always be the way we want them to be. The unexpected can happen. For example, let’s say you have to divide numbers. Trying to divide any number by zero (0) gives an error. Logical functions come in handy such cases. In this tutorial, we are going to…
  • Excel Formulas & Functions: Learn with Basic EXAMPLES
    Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions. In this article, we will cover the following topics. What is Formulas in Excel? Mistakes to avoid when working with formulas in Excel What is Function in Excel?…
  • Excel VBA Arrays: What is, How to Use & Types of Arrays in VBA
    What is VBA Array? An array is defined as a memory location capable of storing more than one value. The values must all be of the same data type. Let’s say you want to store a list of your favourite beverages in a single variable, you can use VBA array…
  • Data Validation in Excel: Filters, Grouping, Sorting Examples
    In this tutorial, we are going to cover the following topics. Data validation Data filters Group and Ungroup Adding images to spreadsheets Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let’s assume you are recording student exam marks…
  • VBA Variables, Data Types & Declare VBA Constants in Excel
    Variables are used in almost all computer program and VBA is no different. It’s a good practice to declare a variable at the beginning of the procedure. It is not necessary, but it helps to identify the nature of the content (text, data, numbers, etc.) In this VBA tutorial, you…
  • VBA in Excel: What is Visual Basic for Applications, How to Use
    Everybody in this country should learn how to program a computer… because it teaches you how to think.” -Steve Jobs I wish to extend the wise words of Steve Jobs and say everyone in the world should learn how to program a computer. You may not necessary end up working…
  • How to Do Addition, Subtraction, Multiplication & Division in Excel
    How To Perform Arithmetic Operations in Excel In this tutorial, we are going to perform basic arithmetic operations i.e. addition, subtraction, division and multiplication. The following table shows the data that we will work with and the results that we should expect. S/N ARITHMETIC OPERATOR FIRST NUMBER SECOND NUMBER RESULT…
  • How to Write Macros in Excel: Macro Tutorial – What is & Use
    What is an Excel Macro? Excel Macro is a record and playback tool that simply records your Excel steps and the macro will play it back as many times as you want. VBA Macros save time as they automate repetitive tasks. It is a piece of programming code that runs…
  • Introduction to Microsoft Excel 101: Notes About MS Excel
    In this Microsoft Excel tutorial, we will learn the Microsoft Exel basics. These Microsoft Excel notes will help you learn every MS Excel concepts. Let’s start with the introduction: What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data. Microsoft Excel…
  • Microsoft Excel Tutorial for Beginners: Learn MS Excel in 7 Days
    Microsoft Excel Tutorial Summary Excel is the most powerful tool to manage and analyze various types of Data. This Microsoft Excel tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process. This Excel…
  • Excel VBA Tutorial for Beginners: Learn in 3 Days
    VBA Tutorial Tutorial Summary This Excel VBA tutorial for beginners covers in-depth lessons to learn VBA Excel and VBA basics. This Visual Basic for Applications Excel Tutorial covers all the basics as well as advanced concepts of VBA for beginners. What is VBA? VBA stands for Visual Basic for Applications….