Organizations rely on data for decision-making, but the increasing volume of information makes it challenging to manage. Fortunately, this is where the power of Microsoft® Office Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. You will learn to:
    • Create, save, and navigate worksheets and workbooks
    • Enter and modify data and simple formulas
    • Use the sum feature, undo/redo, find and replace, and smart lookup
    • Edit worksheets using ranges, flash fill, copy and paste, clipboard, drag and drop, insert and delete columns/rows, and change column width and row height
    • Format worksheets with alignment and text wrapping, cell borders and cell colors, merging and centering cells, and hiding/unhiding and freezing/unfreezing rows and columns
    • Setup worksheets for printing with defining print area, adjusting margins, setting page orientation and size, and inserting headers and footers
    • Insert/copy formulas such as relative, absolute, and mixed references, and insert functions
    • Modify workbooks by adding, deleting, copying, renaming, repositioning, and grouping worksheets

Build upon the foundational knowledge presented in the Introduction to Excel course and start down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. Analyze massive amounts of data, extract actionable information from it, and present that information to decision makers. You will learn to:
    • Create and modify tables and charts
    • Add pictures, shapes, WordArt, SmartArt, and format drawing objects
    • Work collaboratively with others through emailing a workbook, converting worksheets to web pages, inserting hyperlinks, and viewing and editing comments
    • Use functions such as IF, Nested, PMT, FV and auto calculate
    • Understand date and time function, add date and date interval, subtract dates, and calculate time intervals
    • Create a workbook through a template, create and edit a template, and use and customize sparklines

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. You will learn to:
    • Import external data, convert text to columns, remove duplicate rows of data, link and embed objects, export data, and publish worksheets or workbooks to the web
    • Create, run, edit, and save Macros
    • Use data analysis tools to trace and fix errors
    • Create, rearrange, and format a PivotTable, filter PivotTables with Slicers, and create a PivotChart
    • Summarize data with list subtotals, nesting, advanced filters and data validation
    • Analyze data with Goal Seek, Solver, create and display scenarios, data tables and forecast future values
    • Continue workgroup collaboration with features such as locking and unlocking cells, protecting a worksheet, tracking changes, encryption, and checking document compatibility and accessibility