|
|
|
|
|
|
|
|
|
|
|
|
| Excel Basics |
| Item: 202004ME20702 |
|
| |
| This course focuses on mastering the fundamental tasks performed in Excel, including data entry, basic formula calculations, and formatting and style operations. Upon course completion you should be able to: •Identify and understand the different components of the Excel interface •Enter and convert numerical and text data, dates, and times •Select, copy, and paste data in a workbook •Employ elements of style, create images, illustrations, shapes, and hyperlinks in a worksheet •Arrange, filter, and sort lists of data, apply basic formatting elements to the worksheet •
Formulate basic mathematical formulas and functions, including SUM, AVERAGE, and MAX and MIN VALUE •Reorganize data by removing duplicates, blanks spaces, and misspellings •Open, save, and protect the workbook |
| OPEN ENROLLMENT |
Fee: $79.00 |
| This is an online, self-paced open registration course. |
|
|
|
|
| Excel Tips and Tricks |
| Item: 202004ME20301 |
|
| |
| In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace. |
| OPEN ENROLLMENT |
Fee: $79.00 |
| This is an online, self-paced open registration course. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|