Excel Tutorials

XLSX Templates Excel Tutorials Provides complete learning solution from basics to advance excel, more so upto the level VBA macro learning.   Before we start you must understand about what is Microsoft Excel?

Excel is a commercial spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS X. 

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.

By default, documents saved in Excel 2010 are in .xlsx extension whereas the file extension of the prior Excel versions were .xls.

This Excel tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.

XLSX Templates is one of those Excel solutions where you can find some of the most amazing Excel and data analytics solution. We have 500+ Tutorials which can help you to learn Excel, faster. As a team, we have combined experience of 20+ years using Microsoft Excel and analytics

 

Table of Contents

1. Basic Excel Tutorials

How To Deselect Cells in Excel

Table of Contents How to Deselect Cells in Excel After adding the deselecting cells feature …

Read More

Learn how to Select Non-Contiguous Cells in Excel

Table of Contents Select cell without using Ctrl Key By following these simple steps we …

Read More

How to use Format Painter in Excel

Table of Contents Where’s the Format Painter Button? It’s there on your Home Tab. If …

Read More

How to apply Strikethrough in Excel [Shortcut + Command]

Table of Contents Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in …

Read More

Formula Bar in Excel

Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide …

Read More

Tips for customizing quick access toolbar in Excel

Below are some of the tips that you can learn to use the quick access …

Read More

Quick Access Toolbar in Excel

Table of Contents Quick access toolbar important to have all the commands that you frequently …

Read More

Learn excel formulas and excel functions from Basics to advance

Without formulas, a Excel spreadsheet is just a good to organize data set. Thus, Formulas …

Read More

2. Excel Shortcuts

Learn How To Clear Content in Excel

In order to clear the content in excel from a cell or a range of …

Read More

How To Strikethrough In Excel | Keyboard Shortcut

To apply strikethrough in a cell in Excel, you need to press the shortcut key …

Read More

Learn To Find And Replace In Excel

In order to open the find and replace option you can use the keyboard shortcut …

Read More

Learn Keyboard Shortcut To Drag Down in excel

To drag down in excel values from above cell to the active cell you need …

Read More

Excel Shortcut to Print Preview

To get the print preview in excel of your work, you can use the keyboard …

Read More

Learn how to merge and unmerge cells in excel

To merge unmerge multiple cells in one single cell you can use the shortcut keys …

Read More

Excel Keyboard Shortcut to Open Format Cells Options

To open the format cells options in Excel, you need to select a cell or …

Read More

Learn how to Apply Remove filter shortcuts

To apply a filter on the data column you need to use keyboard shortcut Control …

Read More

Excel short cut for AutoSum

For performing an autosum in Excel for the values you have in the cells above …

Read More

Learn 200+ Excel Shortcuts to Increase Productivity

Table of Contents Excel Keyboard Shortcuts – Extending the Selection Short Cut for Create a …

Read More

3. Advance Excel Tips

What Is Wildcard Characters In Excel

Table of Contents What are Excel Wildcard Characters? Sometimes working with data is not that …

Read More

How To Install Barcode Font To Generate Barcode In Excel

How to create Barcode in Excel? Every business which deals in goods and products are …

Read More

Learn How To Use Excel Watch Window

Table of Contents Often there are some cells in our worksheet where we have important …

Read More

Learn How To Highlight Dates Between Two Dates In Excel

How to highlight dates between two dates? You have dates in the column and you …

Read More

How to Auto Format Excel

Table of Contents How to use Auto Format Option in Excel? Formatting is a very …

Read More

How to use Goal Seek in Excel Sheet

In school days, we used to solve mathematical equations….where we have the result of the equation… …

Read More

How to Create a Data Entry Form in Excel without VBA

The best way to enter data in a table is Data Entry Form.  But, creating a …

Read More

4. Pivot Table Tips and Tricks

How to Update a Pivot Table Range in Excel Automatically

Table of Contents Updating a pivot table is a pain, isn’t it? I’m sure that …

Read More

How to create a pivot table in Excel using VBA MACRO CODE

Table of Contents A Step By Step Process to Create a Pivot Table in Excel …

Read More

How To Refresh All Pivot Tables at Once in Excel

Table of Contents Believe me, if you are able to refresh all the pivot tables …

Read More

3. Excel Learning Blogs

Learn excel formulas and excel functions from Basics to advance

Without formulas, a Excel spreadsheet is just a good to organize data set. Thus, Formulas …

Read More