Most people have used AutoFill in Excel to copy a formula or create a sequence in adjacent cell.
Excel tip: An easier way to AutoFill thousands of rows of sequenced data in Excel
Tag: excel tips
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 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: 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: 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: 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.