Faysal Easy Excel

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.

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.

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.

    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.

    ROUNDUP function in Excel helps you to round a specific number to nearest upper or next number. More specifically it converts a specific mentioned number to nearest upper number. It can convert both Integer numbers (Whole numbners) or Decimal numbers as user requires. For anyone who performs financial or data analysis in excel, it can frequently be important to round a number. In this video, I will show you how to round a number up in Excel using the ROUNDUP function. This formula will be a major help in saving your time when performing financial modeling and it will also improve your accuracy in Excel.

How to copy a specific data from a webpage and Value Paste it in Microsoft Excel?   What is Web Scrapping: Copying specific data from many websites into your Excel and share the file to your Buyers is called Web Scraping. In a word web scraping is the process of extracting web data. Not only it is important for your Buyers, I believe it is also important for your own Business Analysis. You need web data because you base all your decisions related to business strategy on web data. Whether it is price intelligence, sentiment analysis, or lead generation, you need data to arrive at your strategy. Excel for Web Scraping : Excel is amazing application to scraping data from web. It is a fantastic application that deals with your data and you can play with your data. No words more about Excel. Let's come to the point. How to copy a specific data from Web : If your buyer share links, then you need to go to that site or if buyer not share any link, just mention you to collect specific item