MS Excel Basic Series

Dates: 2/9, 2/23, 2/26, 9 am - 12 pm

Laptops provided In MS Excel BASIC topic areas including getting started with terms and navigating a spreadsheet, entry and editing data a beginning modification to spreadsheets are covered. Upon completion, attendees will be able to: Define a spreadsheet and identify spreadsheet components Identify the main components of the excel window Open and navigate workbooks Create a workbook from a template Enter and edit text and values in a worksheet Enter and edit formulas in a worksheet Save and update a workbook, and save a workbook in a different file format Move and copy data in a worksheet Move, copy, and view formulas in a worksheet Use absolute references in formulas Insert and delete ranges, rose, and columns in a worksheet Apply the SUM function to calculate the sum of values use the AutoSum to enter some functions Use the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to find average, minimum, and maximum values, and the count of cells in a range Apply text formatting Customize column widths, row heights, and alignment, and apply color and border formatting Format values as currency, percentages, and ordinary numbers Apply conditional formatting based on specific criteria Copy formatting, apply cell styles, and use Find and Replace to update the formatting for specific content Create charts based on worksheet data, and move charts within a workbook Customize charts and format chart elements Insert a picture into a worksheet use graphics as conditional formatting to represent cell data insert and modify SmartArt graphics Preview how a worksheet will look when printed, use the spelling checker, and use find and replace to update data set page orientation, scaling, and margins, and create headers and footers print a worksheet and a selected range