Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.Target StudentThis course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.PrerequisitesBasic Windows, keyboarding and mouse skills.Course OutlineGetting StartedStarting ExcelOpening a WorkbookUnderstanding the Display ScreenWorking with the RibbonExploring the File TabWorking with the Quick Access ToolbarWorking with the Status BarSwitching Between Opened WorkbooksUsing Excel HelpEntering DataMoving the Cell PointerSelecting a Range of CellsCreating a New WorkbookInserting, Renaming, and Deleting WorksheetsEntering Constant ValuesUsing Auto Fill to Enter DataSaving a WorkbookEditing Cell ContentsClearing Cell ContentsWorking with Undo and RedoClosing a WorkbookUsing FormulasEntering FormulasUsing Auto Fill with FormulasUsing the SUM FunctionSumming Columns or Rows AutomaticallyUsing Statistical FunctionsWorking with the Range FinderUsing Formula Error CheckingWorking with Constant Values and FormulasCopying and Pasting Constant Values and FormulasCutting and Pasting Constant Values and FormulasUsing Collect and PasteFormatting WorksheetsFormatting NumbersChanging the Font FormatAligning Cell ContentsMerging CellsAdding BordersApplying Cell StylesModifying Columns and RowsChanging Column WidthChanging Row HeightInserting and Deleting Columns or RowsHiding Columns or RowsEditing WorkbooksWorking with AutoCorrectChecking SpellingUsing Find and ReplacePrinting WorksheetsUsing Print PreviewWorking with Print SettingsUsing Page Setup ToolsWorking in Page Layout ViewCreating a Header and FooterUsing Page Break PreviewPrinting a WorksheetExiting Excel
Overview
Taught by
ONLC Training Centers
