Excel App – Productivity on the go.
Did you know that the excel app has powers that not even the desktop version has? (Update 20/03/2023: Now on desktop version too!) You can take a photo of some data and the Excel app will turn it into a spreadsheet. It doesn’t always get it 100% correct, but depending on the layout of the […]
Increase accuracy of data entry using Data Validation.
Using data validation in Excel means you can put restrictions on what can be entered into the cell, increasing accuracy. There are a lot of different options and settings within the data validation area. Here we have a drop down list of choices that the user can select from. You could also require the data […]
Time saver: Enter data in multiple cells at once.
Select cells to enter the data into (Holding down the ctrl key if they are not in one continuous block). Type into one cell. Press Ctrl + Enter, the data is entered into all the selected cells.
Avoiding manual data entry
Instead of doing lots of typing, did you know you can fill a series of cells based on just one manually entered cell? For example, if you write in a date, and take your mouse to the bottom right hand corner of the cell, (it should turn into a small plus sign) and RIGHT click, […]