Excel Tricks with Tejraj

Title Bar is the bar holding title of the excel file. But apart from showing title, it also contains many other important functionalities. so let's get familiar with Title Bar in this blog post. Title Bar is divided in 03 parts: 1. Quick Access Toolbar 2. File Name 3. Minimize, Maximize/Restore, Close buttons Let’s see in detail about this. Quick Access Toolbar:  The commands which we are using frequently can be added to Quick Access Toolbar. Following steps will help you to add desired commands here. 1. Right click on the desired command. (In below screenshot we have selected “ Format Painter ” as a desired command) 2. Select option “Add to Quick Access Toolbar”. 3. Now, you will see “ Format Painter ” command is added in the Quick Access Toolbar. 4. To remove desired command from Quick Access Toolbar, just right click on the command and then select option “Remove from Quick Access Toolbar”. 5. No...

Data Representation and Data Analysis are two important things in today’s corporate world. Excel provides an excellent solution for this. Excel is a Microsoft Office application used to store the data in the spreadsheets. With excel functions, formulas, charts one can easily analyze as well represent data effectively.  In this blog post we will see introductory part of excel like how to open excel, how it looks and some basic things in excel sheet. Detailed excel topics will be covered in subsequent blog posts. Stay tuned!!!! So let’s start with introductory part… How to open excel file? How Excel file looks like? How to save excel file? How to close excel file? How to open Excel File? There are multiple ways to open an excel file: 1.        Start Menu à Microsoft Office 2013 à Excel 2013 2.        Open Run command  (Windows + R) à type “excel” à Press OK 3.    ...