Blog Main Categories
- Project Management 77
- Business Skills 135
- Business Processes 82
- IT and Web Development 68
- Creative Design 70
- Digital Marketing 103
- Cyber Security 1
- Technical IT 1
- Programme Management 1
- Portfolio Management 1
- Risk Management 1
- Benefits Management 1
- Change Management 1
- Health & Safety 1
- Enterprise Architecture & Enterprise IT 1
- Data Protection 1
- Online Courses 1
- Lean Six Sigma Training 1
- ILM 1
You are viewing posts from the Microsoft Office category. Click to view all posts
We are delighted to announce that we have expanded further across the United Kingdom to ensure that we can cover all your training requirements in your local area!
Some of our New Locations:
- Milton Keynes
To see the full list of locations please visit the link below:
Use these step by step instructions to sort your lists with maximum efficiency in Excel.
Excel can sort columns into order alphabetically and numerically. You can perform a single column sort of multi column sort.
The Sort command can be found on the Home tab under the Editing group.
Important: When setting up the list, include a set of column headings (as example below). These are used to control the sort columns. The list must be sequential, i.e. no row gaps from the top of the list to bottom.
Single Column Sort
Click into a cell in the column that you wish to sort by, as in the example below the First Name column.
Select the Data tab, then to sort by A to Z or Z to A.
If you've ever tried to copy and paste from a PDF into Office software, you'll know how frustrating it can be.
Luckily, with Acrobat XI you can easily export information to any Office program - you can even just export snippets of information.
In my example, I've been sent a report and I want to do three things:
- Import the data into Excel to perform my own analysis
- Use the key points in a PowerPoint presentation
- Use insights in my own Word report
Here's how to do each task using Acrobat XI:
Convert PDF to Excel, PowerPoint & Word
This process works great for exporting data, text and graphics from PDF files and even allows you to keep your formatting.
This tutorial is an extract from our popular 1-day Advanced Excel course. Lookup formulas are one of the most asked about topics so we decided to put together a short tutorial.
Lookup tables provide a way of producing numbers or text that cannot be calculated with a formula. For example they could look up a salesman's commission dependent on what has been sold (Example 1), or the amount of discount available to a customer based on the amount of goods ordered (Example 2).
Excel has two Lookup functions; Vertical and Horizontal.
VLOOKUP looks down the vertical column on the left side of the table until the appropriate comparison is found.
HLOOKUP looks across the horizontal row at the top of a column until the appropriate comparison is found.
The decision to upgrade to a new version of Office doesn't come lightly. It's not just the monetary cost to consider it's also the time spent training staff on the new software, compatibility issues and potential bugs if you're an early adopter.
We run most of our Office courses on Office 2010 because very few businesses have taken the leap of faith and upgraded to Office 13. A lot of them actually can't; Office 2013 is incompatible with XP, Vista and early versions of Windows - making it unavailable for more than half of Windows users.
However, we know that some businesses are thinking about making the switch so we've put together this list of Office 2013 guides to help you decide whether it's worth upgrading and what you need to know if you decide to.