Full program description
In this course, you'll learn how to format data for clarity, create simple formulas to perform calculations, organize and transform data, and create charts that communicate information effectively. You'll also explore time-saving features like Flash Fill, Fill Down, Grouping Sheets, and Text to Columns to streamline your everyday tasks. These practical skills will help you work more efficiently, improve the accuracy and presentation of your spreadsheets, and make it easier to analyze and share your data with confidence.
Excel 2 includes four modules:
- Module 1 - Formatting Cells and Simple Functions
- Module 2 - Conditional Formatting, Grouping, and Fill Handle
- Module 3 - Combining and Separating Data
- Module 4 - Data Visualization
This course is designed to provide an overview of Excel, covering the essential features below:
- Formatting cells
- Simple formulas
- Conditional formatting
- Grouping sheets
- Flash fill and fill down
- Text to column
- Separating data
- Concatenate
- Creating charts
By the end of the course, you will be able to:
- Select large data ranges instantly using keyboard shortcuts and apply accounting or currency formatting with proper decimal adjustments
- Calculate data totals, averages, minimums, maximums, and item counts using basic functions
- Implement dynamic conditional formatting rules
- Group multiple worksheets to execute simultaneous changes
- Split dataset strings using delimiters or formulas, and combine text using flash fill or concatenate functions
- Create column, pie, and multi-series combo charts
*Note: If you do not have an existing Canvas account, request access to the course by completing this form: https://wkf.ms/3Q5WsiG