Suitable for beginners this class will teach you how to create, modify, format and print worksheets. You will learn basic formulas, functions, data manipulation, charting and more.You will be learning Microsoft Excel from a live instructor.They will teach you step-by-step how to master Excel, using demonstrations, hands-on exercises and one-on-one help.Suitable for Excel 2016, 2019 & 365 users.Course OutlineExcel EssentialsStarting ExcelThe Excel InterfaceOpening a WorkbookNavigating around a WorkbookFinding DataEntering DataSaving and Closing a WorkbookCreating WorksheetsTypes of DataEntering TextAdjusting Column WidthEntering NumbersTypes of FormulasEntering FormulasAbout FunctionsInserting FunctionsCopying and Moving DataCopying FormulasAbsolute and Relative ReferencesFormattingText FormattingNumber FormattingAlignmentText WrappingMerging Cell DataBorders and HighlightingStyles and ThemesManipulating DataData Entry ShortcutsFill and Auto FillReplacing DataPaste OptionsInserting and Deleting Rows and ColumnsHiding Rows and ColumnsChartsCreate Simple ChartsChanging a Chart's TypeAdding Elements to ChartsOutputManaging Worksheet WindowsFreezing PanesPrinting WorksheetsPrint Setup OptionsPrint Areas and TitlesHeaders and FootersSharing WorkbooksSettings and TemplatesWorkbooks Options and PropertiesWorking with TemplatesOur outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
Overview
Taught by
Training Connection
