Posts

Showing posts from April, 2020

How to Use Formula Tab in Excel 365

Image
Click Download for Exercise File Formulas Tab in Microsoft Excel 365.  Use the Formula tab to  insert  functions, define the name, create the name range, review the formula, etc. In the ribbon, the Formulas tab has a very important and useful tool to make easy our work. The formulas tab in Excel 365 Ribbon consists of 4 groups the del with formulas and functions. 

How to use layout tab in Excel 365

Image
Page Layout Tab: This  tab  is used to make changes to the  layout  of the Excel Sheet like orientation, page size, print area, print title, margins, page breaks, scale to fit, gridline, heading, and many options.  this tab in Ribbon consists of 5 groups it deals with layout and page sitting. 

How to Use Number format in Excel 365

Image
Click Download for Exercise File Number Format: Choose the format for your cells, such as percentage, currency, date, time, etc.

Using Basic Formatting tool (Font, Alignment) in Excel 365

Image
Click Download for Exercise File Using Basic Formatting tool (Font, Alignment) in Excel 365

How to use Cut, Copy, Paste & Paste Special tools in Excel 365

Image
Click Download for Exercise File

File Menu of Excel 365

Image
Click Download for Exercise File

Use of Data Type Stocks and Geography in Excel 365

Image
Click Download for Exercise File

Use of Sort and Filter Tool in Excel 365

Image
Click Download for Exercise File

How to Use Spark line Tool in Excel 365

Image
Click Download for Exercise File

Use of Chart Tool in Excel 365

Image
Click Download for Exercise File

How to use Illustrations too in Excel 365

Image
Click Download for Exercise File

Hot to use PivotTable in Excel 365

Image
Click Download for Exercise File

How to Use Conditional Formatting in Excel 365

Image
Click Download for Exercise File

How to Create a Table in Excel 365

Image
Exercise File Click Download

Custom Formatting of Cell No and CNIC No in Excel 365

Image
Exercise File Click Download

Interface of Excel 365

Image
Exercise File Click Download Button

Introduction and History of Microsoft Excel

Image
Exercise link below mentioned