Students create and format spreadsheets to analyze and share information, and to make informed decisions. This course offers an introduction to basic spreadsheet concepts (basics, file management, ranges, sorting, columns and rows) using Excel. These concepts include Excel's built-in functions (moving and copying data; formatting a worksheet; printing worksheets; functions and formulas (AutoSum, Inserting functions, Aver, Min and Max functions); referencing and absolutes (consolidating data with 3D references, now and today functions, absolute referencing); charts (creating a chart, selecting, moving, sizing and deleting chart items, preview and printing charts); and advanced built-in functions in Excel (financial function, using range names, split screens and freeze pane, working with clip art). Prerequisite: YMCR 5030 or XPCS 0040 or knowledge of computer file management.
Students create and format spreadsheets to analyze and share information, and to make informed decisions. This course offers an introduction to basic spreadsheet concepts (basics, file management, ranges, sorting, columns and rows) using Excel. These concepts include Excel's built-in functions (moving and copying data; formatting a worksheet; printing worksheets; functions and formulas (AutoSum, Inserting functions, Aver, Min and Max functions); referencing and absolutes (consolidating data with 3D references, now and today functions, absolute referencing); charts (creating a chart, selecting, moving, sizing and deleting chart items, preview and printing charts); and advanced built-in functions in Excel (financial function, using range names, split screens and freeze pane, working with clip art). Prerequisite: YMCR 5030 or XPCS 0040 or knowledge of computer file management.
