Course Catalog

Key Applications Intro using Excel and Word

Topics

• Common functions of Microsoft windows applications
• starting word and excel
• examining the word and excel application windows
• working with word and excel menus and toolbars
• opening word and excel files / switching between documents
• changing the view and magnification level of a document
• closing word and excel files
• getting help
• exiting from word and excel
• additional shared elements of word and excel
• more on opening files
• Creating a word document
• entering text into a document
• saving a document
• printing a document
• using autotext
• performing a spelling and grammar check
• more on printing a document
• Editing a word document
• moving the insertion point within a document / selecting text
• inserting text into a document / deleting text from a document
• reversing an edit operation
• finding text in a document
• finding and replacing text in a document
• moving a text block
• copying a text block
• Formatting a word document (part 1)
• applying attributes to text
• applying a new font and font size to text
• simultaneously applying multiple font options to text
• indenting a paragraph
• formatting existing text
• resetting line and paragraph spacing in a document
• resetting paragraph alignment in a document
• using the format painter
• Formatting a word document (part 2)
• resetting the left and right margins of a document
• resetting the page orientation and paper size for a document
• setting and clearing tab stops in a document
• using decimal tab stops
• setting the tab stop with a leader
• creating a bulleted/numbered list
• applying styles to text
• creating a new style
• using atuoformat / applying a theme to a document
• Working with multiple-page and multiple-section word documents
• creating a multiple-page document
• adding borders and shading to text
• adding a header/footer to a document
• adding page numbers to a document
• creating a multiple-section document
• Setting up a word table
• inserting a table in a document
• formatting a table
• inserting and deleting rows/columns in a table
• merging and splitting table cells / entering vertical text into a table cell
• splitting a table
• drawing a table
• using table autoformat
• Miscellaneous word features
• using a word template to create a document
• inserting a picture into a document
• creating a drawing in a document
• adding special effects to text
• inserting symbols into a document
• Creating an excel worksheet
• moving the cell pointer in a worksheet
• entering labels and values into a worksheet
• reversing an edit operation
• saving a workbook
• entering a formula into a worksheet
• adjusting column width in a worksheet
• adjusting row height in a worksheet
• printing a worksheet
• Editing an excel worksheet
• working in edit mode
• selecting ranges in a worksheet
• using autofill
• copying cell entries
• moving cell entries
• clearing cells
• using autosum
• inserting and deleting rows and columns
• inserting and deleting a range of cells
• Formatting an excel worksheet
• resetting the alignment of cell entries
• resetting font options for cell entries
• resetting the number format of cell entries
• adding borders and shading to a worksheet
• creating a new style / applying a style
• using autoformat
• Enhancing an excel worksheet printout
• changing the page setup for a worksheet
• previewing a worksheet
• inserting a page break into a worksheet / including print titles in a printout
• printing the selected worksheet entries
• Using excel functions
• what is a function
• using the sum function
• using the average function
• using the max and min functions
• using the count function
• Using absolute cell references in excel formulas
• entering an absolute column and absolute row cell reference into a formula
• entering an absolute column or absolute row cell reference into a formula
• dealing with errors in formulas
• Linking worksheets in an excel workbook
• renaming worksheets in a workbook
• moving the cell pointer from one worksheet to another
• inserting and deleting worksheets
• entering a formula to link related worksheets in a workbook
• formatting multiple worksheets in one operation
• previewing and printing multiple worksheets in one operation
• Creating an excel chart
• what is a chart?
• plotting a chart
• modifying and enhancing a chart
• previewing and printing a chart
• including non-contiguous data ranges in a chart
• Miscellaneous excel features
• sorting the records of a list
• inserting a picture into a worksheet
• creating a drawing on a worksheet
• hiding rows and columns in a worksheet
• creating a custom table
• Final case study
• Conclusion

Audience

Course Length

For More Information

Other Key Applications Courses: