Excel
Slider

All time zones are listed as CST

Multiple studies suggest that most users take advantage of about 10% of what Microsoft Excel can do. Every percentage beyond that makes you more valuable to any employer. Excel has occupied a space in every technologist’s toolkit as the ideal tool for managing data, and data transforms from platform to platform. Prepare to be surprised as you learn more and more about this remarkable tool.

New call-to-action

1/2 Day Seminar Schedule

The PivotTable has emerged as the preferred analytical tool of those responsible for managing large datasets.
Lookup functions are among the most frequently used advanced features in Excel, enabling powerful applications and bringing the power of relational databases to the spreadsheet experience. This course takes you through the selection and most effective use of these powerful functions.
Data dashboards have demonstrated the power of color and highlights when displaying data for rapid, accurate consumption. Excel's toolset for visual emphasis is Conditional Formatting which changes the color and other features of cells depending upon the results of computations. See how this is most effectively put to use, making spreadsheets substantially more valuable to users.
Find out more about everything they need to know about PivotCharts to use them effectively with their data. We will discuss how PivotCharts work, as well as how to create, modify, filter, and format them to easily visualize and analyze interactive data.
  • Microsoft Excel Video Tip: Flash Fill
  • Microsoft Excel Video Tip: Moving Columns
  • You did WHAT with Excel?

    Many consider Microsoft Excel to be the "swiss-army-knife of software" while others have no idea just how extensive its capabilities are. We explore the various different ways different people use the many tools of Excel. Travel deeper into this amazing, versatile productivity provider and expand your own portfolio of magic you can work with Excel.

  • Find helpful worksheet data displayed onscreen (Excel 2016)

    Without even having to type a formula, Excel automatically displays helpful information about the cells you select. Open a spreadsheet and select several cells containing numeric data. If you look at the status bar at the bottom of your window, you’ll see the average, count, and sum for the selected data. Even better, you can customize the data shown in the status bar. With the cells still selected, right-click on the status bar. Select any additional information you’d like to display.

  • Convert units of measurement within your data (Excel 2016/2013/2010)

    Excel’s CONVERT function provides an easy way to display your data in another unit of measurement. For example, if you have a list of temperatures in Fahrenheit and you’d like to add a column that displays each temperature in its Celsius equivalent, you need look no further than the CONVERT function. Let’s assume your first Fahrenheit temperature, 98.6, is located in cell C7. In cell D7, type =CONVERT(C7,"F","C"), where C7 refers to the temperature you want to convert, “F” refers to Fahrenheit, and “C” refers to Celsius. Excel allows conversions for dozens of units of measurement, including mass, pressure, distance, magnetism, and many others. Search for the term convert in Excel’s help pages to find an exhaustive list of all conversions and their text values you’ll use in your formula. For example, “m” represents meter, “in” represents inch, “T” represents Tesla, and “ga” represents Gauss.