Digital practice admin
Because pivot tables exist as values in cells once you have created them you can then apply conditional formatting to their results to further clarify their summaries for your viewers.
A feature of the Subtotal TOOL is the ability to also group your data into a form ready for printing. For example, let’s say you have a lot of records that you want to separate by one of the fields in the records.
- can be used to convert your current vertically formatted data into horizontally formatted data and vice versa. In this example we see the ‘horizontal’ data transposed to a ‘vertical’ format.
Amongst the advantages of the PDF format is the ability to exist as individual files that can be printed and sent as email attachments. With Adobe Acrobat DC you can now edit PDF files and include interactive elements that can capture user responses.
Excel has a great filtering ability which allows you to filter down by multiple criteria .
By using Insert > Link in OneNote it’s easy to add a link to another webpage and OneNote sections or pages. But how can you link to a specific location ON the page? Here’s how.
Pivot tables are an Excel topic that many people say they have heard about but are not sure about; some are even a little nervous about them. Here is a view of what Pivots can do for you.
In this example we look at how to get Excel’s inbuilt date functions to automatically signal expired or soon to expire event.
This is a moderately advanced topic but is an especially useful method for tracking a date value over time.
Our colleagues at York’s St Johns University have published excellent resources on their blog.
Here are two methods for moving a notebook from your personal OneDrive to the OneDrive for Business version of OneNote.