Advanced MS Excel Skills You Should Know

Microsoft Office is the excellent software which is consists of many applications like MS Word, MS Excel, MS PowerPoint and Outlook. You can install this excellent software through office.com/setup. This software helps the common computer user, a professional. It gives user friendly interface and supports all the gadgets like Window OS, Mac, Computers, Laptops and Android Phones. It saves lot of time and money of the customer. It increases the productivity of the organization and helps the employees to do their work efficiently and effectively. MS Excel is the very useful application of MS Office and it is used for creating spreadsheets. Those who are the regular user of MS Excel must know the advanced skills of MS Excel. In this blog, you will read the advanced skills of MS Excel which everybody should know.

Read Also – How to Repair Corrupt MS PowerPoint File?

What are the Advanced Skills of MS Excel?

  1. Choose the Right Layout: The first thing for creating a spreadsheet, you should do a little planning. Then you should understand your data, and make a layout of your spreadsheet so that you can achieve what you want. This will make your work easier and accurate.
  2. Use Fill Function: This function makes your work easier and less time-consuming. For creating a complex report, you can make use of the Excel’s “Fill Across Sheets” tool. Through this you can duplicate one sheet across many others quickly.
  3. Use Named Ranges: You should use named ranges, in this you do not have to put the symbols on anchor refs. You can use names in formulas, or you can select a named range. Through this, you can create a named range on one sheet and you can also use that name on other sheet.
  4. Formatting: When you create your spreadsheet, first you have to enter data or review data. You can select the fonts, sizes and colors, so that your spreadsheet becomes easy to understand. You can use Bold or Italics, for the headers so that there is a difference between the data and the header. Use this formatting till last one.
  5. Protecting Your Work: It is very important to protect your Excel file. You can prevent others for making any changes in your Excel sheet. You can secure formula cells by stop any other changes, and also stop the rows and columns from being resized. It stops the user from making any changes in the structure of the workbook.
  6. Use Keyword Shortcuts: Basically, users use mouse to do action in Excel, but if you use the keyboard it will make your work easy and also speed up your work and saves time.
  7. Converting to PDF: If you really want your client to look at the data of your spreadsheet, then you should convert your spreadsheet to PDF. You do not require any software for converting spreadsheet to PDF.

If you want to know more about MS Excel, then you can visit to the official website of MS Office through www.office.com/setup.  #Office.Com/Myaccount

How to Resolve Excel Pivot Table Problem?

How to Resolve Excel Pivot Table Problem? Office.Com/Setup

Microsoft Office is the great software which has many applications like MS Excel, MS Word, MS PowerPoint and Outlook etc. You can install this amazing software through www.office.com/setup. All the application of MS Office increases the productivity of the user and makes their work easier than before. It regularly updates its application to give its user more advanced feature and protection from unknown threat. Excel application helps the user in formatting, editing, making spreadsheets and you can use this software on the devices like Window OS, Mac, Computers, Laptops and Android Phones. 

But sometimes the customer faces some problem in MS Excel like Pivot table problem. In this blog, you will read how to solve the Pivot table problem.

Resolve Excel Pivot Table Problem:

  1. Pivot Table Not Refreshing Data: Pivot table do not get refresh by itself so first you have to refresh Pivot Table. For this, you have to click anywhere in your Pivot Table. You will see that the Pivot Table Tools appears on your Excel ribbon. After this, you have to tap on Analyze and then click on Options button. Here from the Data tab you have to choose the check box”Refresh data when opening the file”. This will refresh your data automatically.
  2. Refresh a Pivot Messes Up Column Width: If you do not want your Pivot column and width messes up then you have to click anywhere in your Pivot Table. This will show you the PivotTable Tools on your Excel ribbon. Now just click on Analyze option and then hit on Option button. After this, you have to go to the Layout & Format tab, and then choose these two options: Autofit column widths on update and Preserve cell formatting on update.
  3. Excel Pivot Table Sum Value Not Working: The reason of this error is when there is blank cells in the value column of your data. If you have just one empty cell in the values column, it will consider the whole column as text based.
    If there are some text cells in the value column of your data. Then it will turn your pivot table sum values to count. This happen when the user has downloads the data from any external system.
  4. Pivot Table Grouping Affects Another Pivot Table: To solve this, you have to create a second Pivot Cache. For this, you have to cut down your 2nd pivot table. Then open a new Excel workbook and just paste it. Here you have to make changes in the grouping of 2nd pivot table. After this, you have to cut your 2nd pivot table which you have just pasted in the new workbook. Now you have to paste it back in your original workbook. This will create two separate pivot caches and now you can group each of your pivot table.
  5. Excel Pivot Table Not Showing Data: To show all Pivot field data, you have to right click on the pivot table item and then click on the Field settings options. When the Field Settings dialog box open, you have to click on the Layout & Print tab. Now you have to check the check box ‘Show items with no data’. At last, click on OK button.

If you want more information, then you can visit to the site of MS Office through www.office.com/setup. #Office.Com/Myaccount

Excel Filter to Save Time and Money

Microsoft Office is the famous software which is used for homes and businesses. It has amazing applications which make the work of the user easy. You can install this well known software through www.office.com/setup. It provide user friendly interface and it is developed by Microsoft. Its apps are MS Excel, MS Word, MS PowerPoint and MS Outlook etc. It supports many devices like Window OS, Mac, Laptop, Computers and Android Phones. This software helps the user in formatting, editing, creating text document and making presentation etc. In this blog, how you can filter data in Excel.

Easy Method to Filter Data in MS Excel:

  1. Enter In The Search Bar: For this, first you have to add filters to your data. Then, you have to open the filter drop down and just click on the search bar. Now in the search bar, you have to type the name which you want to filter. When you do this, it will filter the entire values where word is presented. At last, you have to click OK button.
  2. Filter by Color: Filter by color is used to filter values. If you highlight some cells in the worksheet with color, it can be easily filtered out. For this, first you have to apply a filter to your data. Then you have to open the filter drop-down. After this, go to Filter by color and then you should choose the color for which you want to filter. When you click on the color, this will filter the whole cells with the red color.
  3. Add a Condition with OR: It works well with more than one situation. For this, first you have to add filters to your data. Then for the column where you want to filter data and after this, open filter drop down. Now you have to select go to and then choose Text Filters and then click on Custom Filters. Here you will see the window appears to select filters options. Now from this window you have to choose “contains” from both the drop downs. After this, in the input bar you have to type “name” and in second input bar enter “other option”. Now from the options button you have to choose “Or”. At the end, click on OK button.
  4. Pre-Defined Date Parameters: Here there are so many options where you can filter date. There are 21 filter options for dates. If you want to filter custom data, then you can use custom filters. Year to Date: This is used if you want to filter the whole data from the year starting to till date. All Dates in a Period: This is used to filter whole dates in a particular month or quarter.
  5. Filter Top 10 Values: First you have to apply filters. Then from the column where you want to filter and then open filter drop down. After this, you have to select Go to and then you have to select Number Filters. After this, click on Top 10. Then the pop-up window will open up. From that window, you have to choose the following things like Top or Bottom Values, Number of Values, and Type of Filter. After this, click on OK button.

Read Also – Problem with Microsoft ATP’s Phishing Detection which Put Users at Risk

These are some of the tips which help to filter data, for more details you can visit to the site of MS Office via office.com/setup.

How to Fix Runtime Error 1004 in Excel?

MS Excel is the very useful application of MS Office and it is used for making spreadsheet, storing, organizing and manipulating data. This software is utilized in homes as well as for business purposes. You can install MS Excel application through office.com/setup. It has two extensions XLS and XLSX format. It is easy to use but some users face the Runtime error 1004.

This error basically occur due to corruption in MS Excel icon, conflict with other programs when you open VBA Excel file, when filter data is copy and paste in MS Office Excel workbook, due to application error, and if program range value is incorrectly set. In this blog, you will read the solution for the runtime error 1004 in Excel.

Read also – How You Can Use Microsoft Family Safety App?

Fix Runtime Error 1004 in Excel:

  1. Uninstall Microsoft Works: For this, first you have to go to the Task Manager and then you have to stop entire running programs. After this, you have to go to Start menu and then you have to select Control Panel. Now in the Control Panel, you have to select Add or Remove Program. Here, you will see the list of programs which are installed on your computer and from this list you have to select Microsoft Work. At the end, you have to click on uninstall to remove Microsoft Work from your computer.
  2. Delete GWXL 97.XLA File: First you have to right click on the start menu. Then you have to select the Explore option. After this, you have to open the following directory C:\Program Files\MSOffice\Office\XLSTART
    Now you have to delete “GWXL97.XLA” file. After this, close the explorer and open the Excel.
  3. Create New Excel Template: For this, first you have to start your Excel application. Then you have to create a new Excel workbook. Now you have to delete the entire sheets present on it and just have to leave only a single one. After this, you have to format the workbook according to your need. Here you have to click on the MS Office button and then select Save As option. From the Save as option, you have to select Template for the Save As Type. Now in the File name field, you have to name for your template. At the end, click on Save option. You can programmatically insert the template by using following code:
    Add Type:=path\filename
  4. Visual Basic Fix: First open Microsoft Excel, you have to click on the Office Button, and then you have to click on Excel Options. When Excel Options loads up, you have to click on the Trust Center Tab. After this, you have to click on Trust Center Settings.In the Trust Center Options, you have to click on the Macro Settings Tab, and then you have to click on Trust access to the VBA project object model. At the end, just click on OK button.

These solution will fix the runtime error 1004 in Excel, incase if you have any problem then contact to the customer care executive of MS Office through www.office.com/setup.

How you can Share MS Excel File? Www.office.com/setup

Microsoft Office is the essential software which is consists of apps like MS Word, MS Excel, MS PowerPoint and MS Access. This software helps to send and receive emails in Outlook. In MS Excel you can generate spreadsheets, and MS Word is used for creating text documentse. You can install all these applications of MS Office through www.office.com/setup. This software makes the work easier and convenient. And it also increases the productivity of work. This software also provides its customer cloud storage so that they can store the backup of their data online and can use this data anywhere and anytime.

Read More – How You Can Install Microsoft Office on Linux?

Share an MS Excel File:

If you have Micro soft Office, then you must have active OneDrive account. But if you don’t have then sign up for OneDrive before continuing. Fist you have to open the Excel workbook which you wish to share. Then just you have to Select Share, which is located in the upper right-hand side of the screen. When the pop-out box comes, then just select Sign In. Then it asks for Microsoft account credentials. Just follow the instruction to complete the authentication process. After signing in, go to the main Excel window and then just select Share again. You will see a pop-out window, for sharing details. In the Name field just enter a title for the shared workbook. Here, just select the Place menu to where you want to share the file, like your OneDrive repository, a SharePoint library or an internal network location and select Save. The file will now be uploaded to the location. Just Select Share once again. Here the new set of Sharing Options will be there in the pop-out window and just select Invite People. In the Invite People dialog, just type the email address of the person with which you want to share this workbook. Here just Enter a message for the recipients. The Can’t Edit option, is enabled by default which dictates that the recipients cannot make any modifications to your Excel file. If you want to remove this read-only restriction, then disable the settings. Here just Select Share. Your workbook has been shared with them.

How you can Share Excel File Online?

For this, go to Excel Online in your web browser and then open the workbook which you wish to share. Then just select Share which is located in the upper right corner of your browser window. In the Invite People dialog just type the email address with which you want to share this workbook. Just enter a relevant message for your recipient. Here Select Recipients can edit. The Two drop-down menus will appear on your screen, you can select either Recipients can edit or Recipients can only view. The second drop-down menu tells that whether or not your recipients need a Microsoft account to access your document. Select the option according to your need. After this, select Share. Your recipients will get workbook which you have shared with them.

For more information, just visit to the official website of MS Office through office.com/setup. For help, contact the customer care on toll free number.

How to Import Contacts from Excel to Mobile?

MS Office is developed by Microsoft. It includes many applications like Excel, Word, PowerPoint, and Access etc. You can install via office.com/setup. This is the world of cell phones, as they are easy to carry so everybody wants all the information in their Mobile Phones. Any person who has number of contacts in their Excel sheet with email addresses, and other information, it will be difficult to type this data in another phone. So, in this blog we will discuss about getting the contacts from excel to mobile with no data misfortune and accidents.

If you want transfer your all Excel contacts to your Mobile, then you have to change over Excel document to vCard. You can make single or various vCard documents for all contacts.

Import Contacts from Excel To Mobile:

For this, you have to follow 2 steps:

Step 1: Excel Sheet to vCard Conversion:

First, you have download and Install the MS Excel to vCard Converter then you have to click on Browse button to choose the Excel file. After this click on open to start the conversion process. When the Excel file is added it will show you preview of the content. Then click on the Next button. After this, in the mapping option, you have to map the fields. Just select another field from vCard Fields and add it to export Excel to Android contacts. Then match the fields, and hit the Add button. Now, click on Next. Just check the export option which you want to apply-

Apply Empty Email Address to be Imported or Single vCard File for All Contacts. Now,hit the Convert button to complete the process. Then it will show you a confirmation screen, and just click on Yes. At the end, the Excel file is converted into the vCard.

Step 2: Transfer vCard File To Mobile Phone:

First, open your Android phone and select the Contacts list then you has to click on the three vertical dots icon. From the menu list just to click on Import/Export option then select Import from .vcf file option. After this, go to the location where you saved the vCard file. Then, choose the .vcf file. Now, ‘All contacts .vcf will be imported shortly’. After completing the import contacts from Excel to Android process, ‘Finished importing vCard .vcf’ notification will be seen. Now, you can access the vCard contacts in your Android Phone. Here, you can select and open any contact.

But if you find any problem in importing the contacts from excel to mobile phone then you can visit to the official website via www.office.com/setup.