Skip to main content

Posts

New Article

How to SUM by matching partial text in Excel

How to Insert and Delete Rows and Columns in Excel Worksheet

How to print a worksheet in Excel

How to Move or Copy WorkSheet in Microsoft Excel

How to insert, color, rename and delete a worksheet

In Excel, you can easily insert, rename, color and delete worksheets in your workbook. In this video you will learn how to insert, rename, color and delete worksheets in few methods.

Basic Microsoft Excel Worksheet Interface

We have seen How to run Microsoft Excel from Start menu in our previous lesson. In this section we will see what are the different objects in Excel to do our jobs. More specifically I have shown here: Menu Bar which is called TAB, Groups, Ribbons. With these 3 things I will help you to learn excel. Below objects are not described right now, but will explain in future. Address Bar: We can see the active Cell, Range or Object Name here. Formula Bar: We can write a formula in Cell or Object using Formula Bar. Application or Windows Button: We can use this to minimize, maximize or close the application. Status Bar: Where you can see the status of the Application task. Zoom: We can increase or decrease the zoom levels of the worksheets. Quick Access Tool Bar: We can assign any utility to quickly access it.

Create A Blank New Workbook in Excel

A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. Creat a blank new workbook in excel is the first lesson to start learning Microsoft Excel. You can create a blank workbook in many ways. Such as from Start Menu, from Taskbar, from Shortcut Key or from File Tab. In this video I have shared the most basic ways to create a blank new workbook in excel. Below are few ways to create a blank new workbook in excel: Start Menu: - Click on Start > Excel 2016 Shortcut Key: - Open Excel file - Press Ctrl + N Create from Template: - Select File > New - Double-click on a template This tutorial is eligible for: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel Starter 2010.

Create your own custom Tab in Excel Ribbon 2016

    To make your favorite and most used commands accessible easily, you can add your own tab to the Excel ribbon. You will find it very convenient to have your own tab and most used commands at your fingertips. In this video you will learn how to create your own custom Tab in Excel ribbon 2016. Also you can learn how you can perform with your custom Tab in Excel Ribbon.