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.
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.
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.
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.
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.
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.
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.
The Excel 2016 Power add-ins allow extra functionality in Excel. This includes Power Pivot, Power View, Power Map, and Power Query (Excel 2013).
