- Creating a worksheet and chart. Start using Excel. Selecting cells and entering text. Entering numbers. Calculating sums using formulas. Using fill handle. Calculating Average, Maximum, and Minimum. Saving and formatting. Adding pie charts. Changing sheet titles and colors. Excel document properties. Printing a worksheet. Viewing automatic calculations and correcting errors.
- Entering titles and numbers into Excel. Flash fill. Entering formulas. Option buttons. Using statistical applications: AVG, MAX, MIN, etc. Verifying formulas using range finder. Formatting, checking spelling, and displaying & printing worksheet.
- Working with large datasheets, charting, and what-if analysis. Rotating text and using fill handle to create a series. Copying cells. Inserting and deleting cells. Absolute and relative references. IF functions. Sparkline charts. Formatting. Column charts. Organizing. Changing views. Insights and accessibility.
Click here for more info.