## Top Resources for Intermediate and Advanced Concepts | Excel for Absolute Beginners

After covering the absolute Beginner Series on Ms Excel, We now present you the most useful of the resources. Please go through all of the tutorials again to make sure you didn’t miss anything. We Covered: Past Tutorials: 5 Things That You Should know About Excel | Excel For Absolute Beginners 5 Things That You … Read more

## How to calculate percentage in Excel

How to calculate percentage in Excel? The different percentage calculation types are: [vtftable ];;;E.G.;nn;Percentage of a Number;;;What is 25% of 50?;nn;Percentage as a Proportion;;;E.g. If a flight have to fly 1000 KM from it’s origin, and now it flied 780KM. How many % of journey have it completed?;nn;Percentage Change;;;E.G. If you got a pay raise … Read more

## Looking at the View tab in Excel | Excel for Absolute Beginners

In This Walkthrough We: Take a look at the View tab in Ms Excel Aimed At: Who know how to use Excel and want to learn View functions in Excel Prerequisites: Please Read Exploring The Home Tab | Excel for Absolute Beginners Exploring the Home tab (Part 2) | Excel for Absolute Beginners Setting the … Read more

## Top 5 most useful String functions in Excel

In This Walkthrough We Take a look at some of the most useful text/string functions in Excel Aimed At: Who know basic Excel and want to learn about Excel text functions Prerequisites: Please read: Exploring The Home Tab | Excel for Absolute Beginners Exploring the Home tab (Part 2) | Excel for Absolute Beginners Top … Read more

## How to sort and filter data in Excel?

In this walkthrough, we will illustrate how to sort and filter data in Excel. Followed by: Take an in-depth look at Excel Filter Option & Copying Excel Cells through the Fill handle Aimed At: People who know nothing about Excel and want to know the Basics Prerequisites: Please Read : Exploring The Home Tab | … Read more

## Top 5 most useful Excel functions – Maths

Excel offers a wide range of functions which you can in any kind of worksheet. Excel formulas work on Strings as well as Numbers. Lets take a look at some of very useful Mathematical functions in Excel. In this walkthrough, we will learn the 5 most useful mathematical Excel functions – how to get the … Read more

## How to insert pictures, shapes or Text box and make Your Excel Workbook look more Professional

In This Walkthrough We will learn to: Insert Pictures, Shapes and Text Boxes in Excel to make your Workbook look more Professional Aimed At: People who are still pretty much learning Excel and want to make their workbook look more formal Prerequisites: Please Read Exploring The Home Tab | Excel for Absolute Beginners Exploring the … Read more

## How to set the layout, page size, print area of an Excel document

In This Walkthrough We will learn how to: Set the layout, page size of the page and also take a look at the Print Option and print area of a document in Excel Aimed At: People who know basic functions in Excel and want to learn about Print options in Excel Prerequisites: Please Read: Exploring … Read more

## Exploring the Home tab (Part 2) | Excel for Absolute Beginners

In This Walkthrough We will learn to: Choose a Number format for our Cells Apply Pre-formatted tables from the Library Insert and Delete Cells Adjust the height and width of cells Aimed At: People who know nothing about Excel and want to know the Basics Prerequisites: Please Read : Exploring The Home Tab | Excel for … Read more

## Exploring The Home Tab | Excel for Absolute Beginners

In This walkthrough We: ⦁ Access The Home Tab⦁ Learn Basic Functions like Cut, Copy and Paste⦁ Alter the Appearance of the font⦁ Change the Alignment and Merging Cells⦁ Change the format of the Cells Aimed At: People who know nothing about Excel and want to know the Basics Prerequisites: Please Read: Our Previous Post … Read more