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.
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.
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.
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.
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.
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.
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.