All About MS Excel Tips and Tricks

Are you looking for beginner to advanced Microsoft Excel courses with a free certification? Microsoft Excel is an extremely powerful tool that is used by well-respected career professionals such as Business Analysts, Accountants, Project Managers, Data Scientists, Financial Analysts, and more. Microsoft Excel is the most common and the most popularly learned application around the …

Top 5 Pay Free Certification Courses in Microsoft Excel Read More »

One may often require to convert numbers in Excel from one format to another e.g. decimal number 20 to Roman numerals XX etc. Also, from decimal to binary, octal and hexadecimal. Excel provides some inbuilt functions to help users convert numbers from one numbering system to another with ease. Also read: Convert Excel to Google …

How to Convert Numbers in Excel – Step-By-Step Read More »

This tutorial is a detailed guide to freezing rows and columns in Microsoft Excel. We will learn to freeze panes, split a sheet, and hide windows in Excel with the help of significant examples and supporting images. Also read: 6 Simple Ways to Format Cells in Excel in Less Than 5 Minutes Steps to Freeze …

How to Freeze Panes, Split a Sheet, and Hide Windows in Excel Read More »

This article is a detailed tutorial on how you can format cells in Excel. We will learn to adjust cell sizes, lock and unlock cells, protect sheets, and much more with the help of the Format tool in Excel. Steps to format cells in Excel The Format tool is situated in the Home tab in …

6 Simple Ways to Format Cells in Excel in Less Than 5 Minutes Read More »

This article is a complete guide to the Find and Replace in Excel. We will discover the new tips and tricks that can be done with the Find & Replace tool. This tool can be of huge advantage to you than just finding and replacing values from a large database in Excel. Steps to Find …

How to Find and Replace in Excel Like a Pro Read More »

This article is a detailed guide to counting characters and searching values in Excel. We will learn to count characters in a cell and search for a word in a cell that results in the character position of that word all with the help of formulas. Also read: How to Flip Data, Change Case and …

Count Characters and Search in Excel [An Easy Introduction] Read More »

This tutorial is an easy step-by-step guide to calculating frequencies, ratios, and percentages in Microsoft Excel. We will learn to calculate these elements with the help of formulas, appropriate examples, and supportive images. Steps to calculate frequency in Excel We will take a sample mark list of students that contains the grades and percentage of …

Calculating Ratio, Frequency, and Percentage in Excel – Quick and Easy Guide Read More »

This article is a detailed guide to flip and combine data in Microsoft Excel. We learn to flip and combine columns, rows, and data with the help of important formulas and tools, step-by-step. Steps to Flip Data in Excel To flap one cell’s data with another cell, follow these steps. We wish to swap the …

How to Flip Data, Change Case and Combine Files in Excel Read More »

In this tutorial, we are going to learn to make a monthly budget in Excel. Budgets help you increase your savings or profits by helping you stay within the estimated costs and expenses. We will learn to create a budget both automatically and manually, step-by-step. Steps to create a budget in Excel Let’s get started …

[Step-by-Step] Create A Budget In Excel In 10 Minutes Read More »

In this tutorial, we’re going to learn to create a project timeline in Excel. We will also learn to customize timelines as we like. Steps to create a timeline in Excel Let’s begin to quickly create and customize a timeline with the help of this step-by-step tutorial. Before creating a timeline, you can either have …

Easy Ways To Create A Timeline In Excel Like A Pro Read More »