Showing posts with label Microsoft Excel-Techniques. Show all posts
Showing posts with label Microsoft Excel-Techniques. Show all posts

Thursday, August 27, 2020

Easy way to protect your file through password

 

Brief Introduction

            It is most important to protect our various precious files through password like our Financial Record, Presentation, office works, etc. We mostly maintain our private or office work in files like Microsoft Word, Excel, PowerPoint, Access, etc. these files are easily protected by password to prevent the private data confidential, So for this purpose, we discuss in this article an easy way to protect our files. 

Purpose of Article:

To protect our files through Password.

              This article explains in simple terms how to protect our files through Password. It takes a step-by-step approach, & following the below contents we will touch in this post.

  1. How easily protect our files through Password.

Let’s start to learn something new about the process of protecting the files through Password.                

1.  How easily protect our files through Password.

             Let's get started. First, we'll need to open Microsoft Word & now we want to protect the word file through a password, so click on FILE Tab on the top of Microsoft Word file, as a new window will be open for us,

 


                For continue reading the article, click on the below Learn More Button,



Tuesday, August 25, 2020

Dollar ($$$) Symbol use in Microsoft Excel Formula

 Brief Introduction

            In Microsoft Excel the Dollar Symbol or Sign ($) is mostly used in Formulas where we want to fix or absolute the reference or location of the cell to stop it from changing, without $ sign in the formula the reference or location of cell change gradually, so it is important to know how & where the Dollar $ use.    

Purpose:

Use to fix or absolute the reference or location of the cell to stop it from changing.

              This article explains in simple terms how to use the Dollar Symbol or Sign ($) in Microsoft Excel formulas. It takes a step-by-step approach, & the following below contents we will touch in this post.

  1. Brief introduction of Relative and Absolute reference concepts.
  1. Relative reference in Microsoft Excel with Example.
  1. Absolute reference in Microsoft Excel with Examples.

Let’s start to learn something new about the Dollar Symbol or Sign ($) use in Microsoft Excel Formulas.                

1.  Brief introduction of Relative and Absolute reference concepts.

             Relative reference is the basic or default option of Microsoft excel formulas, every formula, we used in excel without Dollar $ Sign is carrying the relative reference, it means that it changes across the other cells when we drag or copy paste the formula to other cells, while Absolute reference carrying the Dollar $ Sign, which not change across the other cells by dragging or copy-paste option. Below in this article through various examples, I will explains the difference between Relative Reference & Absolute Reference.

 


    For continue reading the article & download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below Learn More Button,