web analytics

Tag Archives: Microsoft Excel 2013

INSERT HEADERS OR FOOTERS INTO MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to insert headers and footers into Microsoft Excel 2013. Headers and footer are standard texts that appear on every page of the report. The header is in the top margin of the page and footer is in the bottom margin. Both are centered vertically in the margins and unless you specify otherwise Excel does not automatically add either to a new workbook.

To add a header or footer to your report you go to page layout view by clicking the button on the status bar, then position the mouse pointer over the section in the top margin of the first page marked click to add header or in the bottom margin of the first page marked click to add footer.

1

HOW TO AUTOMATE COMMANDS IN MICROSOFT EXCEL 2013 WITH MACROS – PART 2

Microsoft Excel 2013

This is a continuation of PART 1 of this article.

For this example macro, select the personal macro workbook so that you can use it to enter the company name in the any excel workbook that you create or edit. Click on the OK button in order to close the record macro dialog box. Select the cells, enter the data and choose the Excel commands required to perform the tasks that you want. Recorded just as you normally would in creating or editing the current worksheet, using the keyboard, the mouse or a combination of the two. After you are finished recording, just click on the Stop Recording button located in the status bar or the Developer Tab on the ribbon.

To run a recorded macro just click on the View Macros option located on the macros buttons drop-down menu on the View tab or you can just press Alt+F8 in order to open the macro dialog box.

1

HOW TO AUTOMATE COMMANDS IN MICROSOFT EXCEL 2013 WITH MACROS – PART 1

Microsoft Excel 2013

This article will show you how to automate commands in Microsoft Excel 2013 with Macros. Macros automate the excel worksheet by enabling you to record complex command sequences. The Excel status bar located at the bottom of the Microsoft Excel 2013 window contains a record macro button. What you should do is to click this button in order to turn on the macro recorder. The view tab contains a macros command button and the drop down menu has an option for recording macro.

1

HOW TO FORMAT YOUR PIVOT TABLES IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

With this article you will be able to learn how to format your pivot tables in Microsoft Excel 2013. Formatting a new pivot table in Excel 2013 is quick and easy. All you need to do is click a cell of the pivot table. To add the pivot table tools can textual tab to the ribbon and then click it’s designed tab to display the command buttons. The design tab is divided into three groups. The layout group lets you add subtitles and grand totals to the pivot table and modify its basic layout.

The pivot table style options group enables you to refine the pivot table style you select using the pivot table styles gallery to the right and the pivot table styles group contains the gallery of styles you can apply to the active pivot table by clicking the desired style thumbnail.

1

USING ADD-INS IN MICROSOFT EXCEL 2013

Microsoft Excel 2013

This article will show you how to use add-ins in Microsoft Excel 2013. Microsoft Excel add-in programs are small modules that extend the program’s power by giving you access to a wide array of features and calculating functions not otherwise offered in the program there are three types of built-in add-ins that are available. When you install Excel 2013, add-ins you can download from Microsoft Office online website and add-ins developed by third-party vendors. These generally need to be purchased. When you first install Excel 2013, the built-in add-ins programs included with Excel are fully loaded and ready to use.

To load any others choose file, options, add-ins.

1