Course

Create and manage worksheets and workbooks:Create worksheets and workbooks: create new workbooks use templates; import files; open non-native files directly in Excel; add worksheets to existing workbooks; and copy and move worksheets.Navigate through worksheets and workbooks:Search for data within a workbook; insert hyperlinks; change worksheet order; use Go To; and use Name Box.Format worksheets and workbooks:Change worksheet tab color; modify page setup; insert and delete columns and rows; change workbook themes; width; insert headers and footers; and set data validation.Customize options and views for worksheets and workbooks:Hide worksheets; hide columns and rows; toolbar; customize the Ribbon; manage macro security; change workbook views; record simple macros; add values to workbook properties; use zoom; display formulas; freeze panes; assign shortcut keys; and split the window.Configure worksheets and workbooks to print or save:Set a print area; save workbooks in alternate file formats; print individual worksheets; set print scale; repeat headers and footers; maintain backward compatibility; configure workbooks to print; save files to remote locations.Create cells and ranges:Insert data in cells and ranges; append data to worksheets; find and replace data; copy and paste data; use AutoFill tool; expand data across columns; and insert and delete cells.Format cells and ranges:Merge cells; modify cell alignment and indentation; change font and font styles; use Format Painter; wrap text within cells; apply Number format; apply highlight; apply cell styles; and change text to WordArt.Order and group cells and ranges:Apply conditional format insert subtotals Create a table; move between tables and ranges; add and remove cells within tables; and define titles Modify a table.Apply styles to tables; band rows and columns; insert total rows; and remove styles from tables Filter and sort a table:Filter records; sort data on multiple columns; change sort order; and remove duplicates Apply formulas and functions:Utilize cell ranges and references in formulas and functions Utilize references (relative, mixed, absolute); define order of operations; and reference cell ranges in formulas.Summarize data with functions:Utilize the SUM function; utilize the MIN and MAX functions; utilize the COUNT function; and utilize the AVERAGE function.Utilize conditional logic in functions:Utilize the SUMIF function; utilize the AVERAGEIF function; and utilize the COUNTIF function Format and modify text with functions Utilize the RIGHT, LEFT and MID functions; utilize the TRIM function; utilize the UPPER and LOWER functions; and utilize the CONCATENATE function.Create charts and objects:Create charts and graphs; add additional data series; switch between rows and columns in source data; and use Quick Analysis.Format a chart:Add legends; resize charts and graphs; modify chart and graph parameters; apply chart layouts and styles; and position charts and graphs.Insert and format an object:Insert text boxes; insert SmartArt; insert images; add borders to objects; add styles and effects to objects; change object colors; modify object properties; and position objects. Create and Manage Worksheets and Workbooks 29%;Create Cells and Range 17%;Create Tables 15%;Apply Formulas and Functions 22%;Create Charts and Objects 17%.