Learn to create the right chart for the right job.
Work with the more obscure chart types to display data.
Learn to use AutoFilter commands and color sorting.
Discover why Goal Seek eliminates formula guesswork.
Find out how to use the Excel PivotTable to create a quick, easy-to-read summary of data in an otherwise unwieldy spreadsheet.
Become proficient at using the PivotTable to filter, group, and chart data.
Find out how Excel's Solver tool can help you determine the optimal conditions for meeting a target.
Use the Solver tool to find the ideal solution for a real-world scenario.
Understand how macros can help you work more efficiently by automating tasks you find time-consuming or repetitive.
Learn how to use Excel's text functions to trim, concatenate, or convert text from one form to another.
Use Excel's sumif and countif functions to count or add values that meet a desired condition.
Discover how Excel's VLOOKUP function can help you extract the values you need from a table.