Learning Objectives
- Apply key Excel functions and formulas.
- Change and customize the workbook appearance to optimize spreadsheets.
- Manage spreadsheets using filter and sort table data capabilities.
- Re-order and summarize data effectively.
- Use data from multiple sources.
- Perform data visualization using basic charts.
Modules
- Selecting and naming ranges
- Using AutoCalculate
- Using functions and formulas
- Using AutoSum and AutoFill
- Using Date & Time functions
- Using text functions
- Using the IF function
- Managing information
- Clearing information
- Deleting and inserting ranges
- Moving and copying information
- Copying formulas
- Understanding relative, absolute, and mixed formulas
- Creating absolute and mixed references
- Copying values only
- Using AutoComplete
- Working across worksheets & workbooks
- Working with multiple-sheet formulas
- Consolidating information
- Linking information between workbooks
- Working with large worksheets
- Understanding data lists
- Creating and removing subtotals
- Using data validation
- Restricting cells to numbers/dates/times
- Restricting cells to a list of values
- Converting, sorting, filtering, and managing lists
- Working with Clip Art
- Using shapes
- Working with icons
- Working with SmartArt
- Creating different charts
- Modifying titles and labels
- Modifying Axes, Gridlines, and Legends
- Working with data tables
- Changing the data range
- Working with data series
- Deleting a chart
- Highlight cells rules
- Top/Bottom rules
- Data bars, color scales, and icon sets
- Adding your own formatting rules manually
- Showing only one icon
- Showing data bars and icons outside cells
- Representing trends with icon sets
- Building a Legend for your conditional formatting
HNI Partners
Our Partners
We are proud to collaborate with leading organizations that share
our commitment to excellence and growth.
our commitment to excellence and growth.
