PowerPoint tip: Managing objects on a slide
It can get confusing to select and manage objects when a PowerPoint slide has too many items, like this one:
Excel tip: An easier way to AutoFill thousands of rows of sequenced data in Excel
Most people have used AutoFill in Excel to copy a formula or create a sequence in adjacent cell.
SharePoint Tip: searching your site using wildcards and exact phrases
Learn how to search your site with Wildcards and Exact Phrases in SharePoint
Excel Tips: Show leading zeros on numbers
If you want to keep a leading zero on a number, a workaround people often use is to format the cell as text or type an apostrophe before the number – e.g. '0822 will automatically store the leading zero, but keep the text as a number.
But what if you want to have numbers that display leading zeros, and keep the numbers as a numeric value?
Microsoft Word tip: updating fields in long documents
Heres how to update all fields at the same time, including those in headers, footers and, and different sections:
Excel tip: Making the most of Excel's conditional formatting
There is so much you can do with conditional formatting in Excel, and you will save yourself a lot of time in the long term if you take a little time to learn a few tricks. If you are new to conditional formatting, one quite easy feature to get you started is highlighting duplicated data.
PowerPoint tip: Resetting a Slide To The Default Layout
In Microsoft PowerPoint, most slides start from one of several predefined layouts. The layout includes placeholders which can be used to insert text, pictures, tables, charts, diagrams, and videos. These layouts allow you to easily format the page and make sure that slides maintain a standard look and feel.
Excel tip: How to use Get & Transform to Merge Columns
The Get and Transform feature of Excel 2016 sounds new, but some of you may know it by its old name, Power Query. You now get the data, and then you transform it, hence the new name.
Excel tip: Map your data with 3D Power Map
Power Map has become even more powerful in Excel 2016 – you can take a table of data with geographic information and create impressive 3D maps.
SharePoint tip: How to create a form in InfoPath
In our SharePoint Site Owner Advanced course, one of the topics we will teach you is how to create a form in InfoPath, and how it can be easily linked to a SharePoint list or library. Follow these steps to make the link to a form library.
Excel tip: Make an interactive button bar with Power View
Power View is used to examine and analyse data and is just one of the features you will learn about in our Excel Advanced Data Analysis course.
Excel tip: How to copy code into the VBA editor
In the VBA for Microsoft Excel course, you will not only learn how to record macros in Excel, but write the code behind them.
Excel tip: How to create related tables in PowerPivot
PowerPivot is used to for connecting and manipulating data, particularly from external sources. It allows you to connect tables of data that have common fields (just like a relational database) and is just one of the features you will learn about in our Excel Advanced Data Analysis course.
Excel tip: Use flash fill to extract data in separate columns
Flash Fill recognises a pattern in your data and is a great tool to extract a field and break it down into its component elements.For example, in this video tip Column A has the first and last name in one field. Flash Fill makes splitting the names up into two separate cells (first name and surname column) very easy.
SharePoint tip: How to create a Wiki library
Learn how to create a Wiki Library in SharePoint with our free tutorial on Microsoft SharePoint.
PowerPoint tip: How to create slides from a Word doc
Information required for a presentation may already exist in a Word document. You're able to import this information into a PowerPoint presentation without having to retype or cut and paste.
Top 5 Microsoft Excel tips you probably don't know
There are so many hidden features in Excel, it could take a lifetime to learn them all. Thankfully, we have done the hard work for you, and come up with five very helpful Microsoft Excel tips to resolve some of the questions you never even knew to ask about Excel.
Excel tip: How to create a sequence of dates in Microsoft Excel
Need to create a sequence of dates? It's very easy using Excel's AutoFill feature.
Microsoft Word tip: The difference between pressing Enter and Shift-Enter
Most people know that when you press the Enter key on the keyboard when using Microsoft Word, a new line is inserted into the document. What many people don’t realise is the difference between pressing Enter and Shift-Enter.
Microsoft Outlook tip: Create an Outlook Quick Step to Automate Actions
A Quick Step is a feature that lets you make a shortcut to any multi-step action. For example, moving emails and marking them as read, or forwarding an email and flagging it. It makes short work of a repetitive task.
Tips to help your team to embrace their SharePoint intranet
Staff intranet sites are driven by people actively contributing and collaborating. If your site doesn’t get this “buy-in” from the users, it is destined to fail.
Excel tip: Custom Cell Formatting in Excel
Want some clever cell formatting in Excel but get confused by the Custom Format Cell options? Here is a quick tutorial to writing clever cell formats.
Excel tutorial: Pasting Values with Drag and Drop
Pasting the values from a formula (so that the numbers never change) has always involved several steps. Often you want to calculate an answer, but store the number, not the calculation.
Excel tip: Generate a pivot chart with a slicer
A PivotChart is an interactive chart that provides a graphical analysis of data. Your data comes from existing tables, databases or PivotTable reports. A slicer is a visual filter that allows further insight into a particular field. You can learn more about PivotCharts in our Excel Advanced and Excel Advanced Pivot Tables courses.
Excel tip: How to create a drop-down list in Excel
In this video, you will learn how to create a drop-down so you can select from a list without having to retype each time. In this example, we have a simple database with a Department field and will create a list of departments as the drop-down list.
Excel tip: Analysing data by date using PivotTables
One of the simplest changes in Excel 2016 relates to date data when you're working in a PivotTable. In prior Excel versions date data was added to the PivotTable as is.
SharePoint tip: How to create a document library
To create a Wiki library you'll need to have the appropriate permissions as a Site Owner.
Excel tip: Enable the Power add-ins
The Excel 2016 Power add-ins allow extra functionality in Excel. This includes Power Pivot, Power View, Power Map, and Power Query (Excel 2013).
Excel tip: Use Get & Transform to connect to a website
Taking data from a web page and linking it to a spreadsheet has never been easier. Here is a website with the latest currency exchange rates. This data at xe.com refreshes regularly. We want to bring this data into cells in the spreadsheet, even if it currently isn't laid out the way we want to display it in Excel.
Insights in your
By signing up, you will receive our free insider newsletter, with complimentary downloads, tips, resources & much more to accelerate your development journey.