How to Safely Change Your WordPress Permalinks

Website permalink is a crucial address to your content and changing it can be a big challenge. You may have to forcibly decide as some of your content has become outdated and needs updating. You may have created your WordPress site without the knowledge of how to structure the permalinks? Or a decision is made to customize the structure as the present ones look clumsy. But, all these overhaulings may come at a cost of losing your past backlinks. (more…)

Using Get & Transform in Microsoft Excel 2016

Get & Transform is a powerful data analysis tool in Microsoft Excel that allows you to import, refine and work with data from a range of sources, including files saved to your computer and web pages on the internet. You can shape data in order to display the details relevant to your purposes and hide information that is not required, without making permanent and irreversible changes to the data. (more…)

Alternate Layouts in Adobe InDesign CC

Many documents created today need to be re-purposed for use in different ways.  A document originally intended for print will usually be required in a digital format. A document intended for a mobile device such as an iPad will need to be produced in both landscape and portrait orientations. All of this is made possible in InDesign through the use of alternate layouts.

 

(more…)

Understanding Advanced Filters in Excel

Excel worksheets can be used to keep lists of information such as employee details, subscribers, accounts, sales, or even bird sightings if need be. The Advanced Filter in Excel enables you to analyse the data in a list by filtering it according to specific criteria. Excel worksheets can be used to keep lists of information such as employee details, subscribers, accounts, sales, or even bird sightings if need be. The Advanced Filter in Excel enables you to analyse the data in a list by filtering it according to specific criteria. (more…)

Creating Slicers in Excel

Slicers are special field filters that can be applied to Excel tables. They are most useful for further dissecting an existing PivotTable report in a worksheet. Slicers are actually graphics objects comprising of a rectangle and special filter buttons. Slicers are inserted into the worksheet from the Slicer command on the INSERT tab of the ribbon. (more…)

The Benefits Of Microsoft Excel Training

Microsoft Excel is a spreadsheet application that is usually part of a suite of Microsoft applications, known as Microsoft Office. You can use Excel for all sorts of tasks involving numbers such as budgeting, sales analysis, forecasting, charting and graphing and much more. Excel is a tool used to perform calculations with numbers, so virtually any task that requires calculation and number crunching can be set-up and performed in Excel. (more…)