Learn how to use Flash Fill in Excel… in easy steps…
Introduced in Excel 2013, Flash Fill recognizes patterns in data based on neighboring cells. It’s much more sophisticated than Auto Fill. You can use it, for example, to reformat text and split or combine data. Here’s an example: 1) You might have a list of names, with the first name and last name combined. For the first […]
Here’s how to recognize the four essential types of data you can represent when coding a computer program…
There are four essential types of data you can represent and that can be stored in variables when coding a computer program. Although variables in the Python language can store any type of data it is important to understand the different types as you will sometimes need to convert from one type to another in […]
iPadOS 15 is here!
Apple released iPadOS 15 (a new version of the iPad operating system) yesterday! We’re currently updating our popular title iPad for Seniors in easy steps to cover this update. Some of the new features in iPadOS 15 that we’ll be covering include: Home screen widgets. The iPad Home screen now includes a range of customizable […]
New release: Assembly x64 Programming in easy steps
Available NOW from our online shop at the special launch price of only £9.99 (RRP £11.99). Ideal for anyone (including beginners) who wants to learn programming in modern x64 Assembly language on Windows – modern coding for MASM, SSE & AVX Assembly x64 Programming in easy steps shows how to write code to create your […]
How to tell the difference between a unit and a symbol in Electronics…
The unit expresses a value, whilst the symbol is just that: a symbol in a formula, and it’s important not to get the two mixed up. Also, don’t confuse the symbols, as they may not always be obvious. For example, it’s easy to remember C is for capacitance but then it can’t be used again […]
New to Sage Accounts? Here’s a quick guide on how to view your customers’ transactions…
Once customer activity has taken place, Sage 50 offers you a variety of options for checking customer transaction details: View customer invoices, receipts, credit notes, and balances on a monthly basis, as a graph or table. Use the Activity option to see a breakdown of each customer’s transactions. View or print the customer’s aged balances. […]
Shortcuts in Windows 10 will help to speed up your work
As you become more confident using Windows 10 you may want to access certain items more quickly. There are a range of keyboard shortcuts that can be used to access some of the items you use most frequently. The majority of the shortcuts are accessed together with the WinKey (Windows key) on the keyboard. To use the […]
Did you know you can get Alexa to remind you about important events?
Reminders can be set for Alexa, so that they are announced at specific times – either daily or weekly. This is an excellent way to be kept reminded about a range of tasks, including: Taking regular medication GP and hospital appointments Paying bills Birthdays (reminders to send cards and buy presents) Putting out the bins/recycling […]
Did you know you can share your screen during a Microsoft Teams meeting?
It’s a valuable feature of Teams so that participants can view files that have been created or are being edited in real time: 1) During an audio or a video meeting with one person or a group, click on the Share button on the top toolbar. 2) The bottom half of the Meeting window contains […]
Did you know you can use the Evaluate command in Excel to run a formula one step at a time to see how it operates?
To use this feature: 1) Select the cell with the formula you wish to investigate. 2) Select Formulas and click Evaluate Formula in the Formula Auditing group. The formula displays with the first step underlined. 3) Press Evaluate repeatedly, to run the calculation forwards, a step at a time. The expressions in the formula are calculated, one by one in turn. You can […]
How to create a Table of Contents in Microsoft Word
Did you know that you can create a Table of Contents for your Word document automatically, by asking Word to look for instances of particular styles or by using entries that you create manually? 1) Open a suitably long document that uses a structure of style headings. Make sure the References tab is active so that you […]
How to use Baseline Shift and Horizontal & Vertical Scale in InDesign
To use Baseline Shift A baseline is an imaginary line that runs along the base of text characters. It is an important concept when talking about typography. Use Baseline Shift to move highlighted characters above or below their original baseline. Use the Type tool to highlight the characters you want to baseline-shift. Enter a new […]
How to take the best photos with your smartphone
There are lots of things you can do with your smartphone to improve the photos you take. To specify a particular focal area in a photo: 1) Open the photo app and compose a scene. 2) Press and hold on the screen on the area that you want to be the main focal area – […]
Microsoft Teams – Raising a Hand, Breakout Rooms, & Live Captions
Are you getting the most out of Microsoft Teams? Maybe you’ve already used Microsoft Teams to have video calls with your friends and family, but did you know it can do so much more? If you’re hosting a meeting with a large number of participants it can be difficult at times, in terms of who […]
New release: InDesign in easy steps, 3rd edition
Available NOW from our online shop – at the special launch price of only £9.99! Master the essentials of Adobe’s InDesign, and then enjoy the full creative potential of this popular desktop publishing software – in easy steps. Written by an expert on Adobe software training for some of the largest and most prestigious magazine, book and newspaper […]
New release: Video Chatting for Seniors in easy steps
Available NOW from our online shop – at the special launch price of only £9.99! Video call and chat using FaceTime, Facebook Messenger, Facebook Portal, Skype and Zoom Video Chatting for Seniors in easy steps is the ideal companion to help you navigate the expanding world of video communication. It covers the following areas: The different devices that can […]
New release: Linux in easy steps, 7th edition
Available NOW from our online shop – at the special launch price of only £9.99! Explains the Linux environment and how to get more out of this popular, user-friendly, and free operating system Now in its seventh edition, Linux in easy steps explains the Linux environment and how to get more out of this stable, […]
New release: Working from Home in easy steps
Available NOW from our online shop – only £3.99! The ideal guide for home workers, as well as managers supporting staff working from home. Working from Home in easy steps helps you manage working from home successfully, including: The benefits and drawbacks of home working. Creating the best workspace for you, your home and your […]