B.Sc.
GENERAL STREAM WITH NO COMPUTER
COURSE AS CORE SUBJECT
B.Sc. SECOND YEAR
OFFICE AUTOMATION TOOLS
UNIT - 1
Excel basics : The usual spread sheet features, Overview of excel features, Getting Started, Creating a new work sheet, Selecting cells, Navigating with the mouse and keyboard, Entering and editing text, text boxes, text notes, checking spelling, undoing and repeating actions, entering and formatting numbers, entering and editing formulas, referencing cells, order of evaluation in formulas, look up tables, copying entries and equations to minimize typing, more auto fill examples, creating custom fill lists, protecting and unprotecting documents and cells.
Rearranging worksheets : Moving cells, copying cells, sorting cell data, inserting rows, inserting columns, inserting cells, inserting as you paste, deleting parts of a worksheet, clearing parts of a worksheet, how formulas react to worksheet design changes, Auditing tools help spot potential problems.
Excel formatting tips and techniques : Excel page setup, Changing column widths and row heights, auto format, manual formatting, using styles, format codes alter a number’s appearance, format painter speeds up format copying, changing font sizes and attributes, adjusting alignments, centering text across columns, using border buttons and commands, changing colors and shading, inserting and removing page breaks, hiding rows and columns.
Organizing large projects : Using names, splitting windows and fixing titles, outlining your worksheets, working with multiple worksheets, using multiple worksheets in a workbook, viewing multiple windows, summarizing information from multiple worksheets.
An introduction to functions : Parts of a function, functions requiring add-ins, online functions help, the function wizard, examples of functions by category, error messages from functions.
