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 auto calculate
- Using functions and formulas
- Using auto sum and autofill
- Using date & time functions
- Using text functions
- Using 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
- Convert, sort, filter, and manage lists
- Working with clip art
- Using shapes
- Working with icons
- Working with SmartArt
- Creating different chart
- 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
Our Partners
