Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the first session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Start Excel and open a new blank workbook • Check that your Excel version is up to date • Change the Office Theme • Maximize, minimize, re-size, move and close the Excel window • Download the sample files and open/navigate a workbook • Save a workbook to a local file • Understand common file formats • Pin a workbook and understand file organization • View, move, add, rename, delete and navigate worksheet tabs • Use the Versions feature to recover an unsaved Draft file • Use the Versions feature to recover an earlier version of a workbook • Use the Ribbon • Understand Ribbon components • Customize the Quick Access Toolbar and preview the printout • Use the Mini Toolbar, Key Tips and keyboard shortcuts • Understand views • Hide and show the Formula Bar and Ribbon • Use the help system
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the second session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Enter text and numbers into a worksheet • Create a new workbook and view two workbooks at the same time • Use AutoSum to quickly calculate totals • Select a range of cells and understand Smart Tags • Enter data into a range and copy data across a range • Select adjacent and non-adjacent rows and columns • Select non-contiguous cell ranges and view summary information • AutoSelect a range of cells • Re-size rows and columns • Use AutoSum to sum a non-contiguous range • Use AutoSum to quickly calculate averages • Create your own formulas • Create functions using Formula AutoComplete • Use AutoFill for text and numeric series • Use AutoFill to adjust formulas • Use AutoFill Options • Speed up your AutoFills and create a custom fill series • Use Flash Fill to split and concatenate text • Use the zoom control • Print out a worksheet
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the third session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Insert and delete rows and columns • Use AutoComplete and fill data from adjacent cells • Cut, copy and paste • Cut, copy and paste using drag and drop • Use Paste Values • Increase/decrease decimal places displayed • Transpose a range • Use the multiple item clipboard • Use Undo and Redo • Insert, View and Print cell comments • Understand absolute, relative and mixed cell references • Understand templates and set the default custom template folder • Create a template • Use a template • Add an App to a workbook • Freeze columns and rows • Split the window into multiple panes • Check spelling
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the fourth session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Format dates • Understand date serial numbers • Format numbers using built-in number formats • Create custom number formats • Horizontally and Vertically align the contents of cells • Merge cells, wrap text and expand/collapse the formula bar • Understand themes • Use cell styles and change themes • Add color and gradient effects to cells • Add borders and lines • Create your own custom theme • Create your own custom cell styles • Use a master style book to merge styles • Use simple conditional formatting • Manage multiple conditional formats using the Rules Manager • Bring data alive with visualizations • Create a formula driven conditional format • Insert a Sparkline into a range of cells • Apply a common vertical axis and formatting to a Sparkline group • Apply a date axis to a Sparkline group and format a single Sparkline • Use the Format Painter • Rotate text 
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the fifth session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Understand chart types, layouts and styles • Create a simple chart with two clicks • Move, re-size, copy and delete a chart • Create a chart using the Recommended Charts feature • Add and remove chart elements using Quick Layout • Apply a pre-defined chart style and color set • Manually format a chart element • Format 3-D elements and add drop shadows • Move, re-size, add, position and delete chart elements • Apply a chart filter • Change a chart’s source data • Assign non-contiguous source data to a chart • Understand data series and categories • Change source data using the Select Data Source dialog tools • Chart non-contiguous source data by hiding rows and columns • Create a chart with numerical axes • Deal with empty data points • Add data labels to a chart • Highlight specific data points with color and annotations • Add gridlines and scale axes • Emphasize data by manipulating pie charts • Create a chart with two vertical axes • Create a combination chart containing different chart types • Add a trend line • Add a gradient fill to a chart background • Create your own chart templates
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the sixth session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • View the same workbook in different windows • View two windows side by side and perform synchronous scrolling • Duplicate worksheets within a workbook • Move and copy worksheets from one workbook to another • Hide and unhide a worksheet • Create cross worksheet formulas • Understand worksheet groups • Use find and replace
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the seventh session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Print Preview and change paper orientation • Use Page Layout view to adjust margins • Use Page Setup to set margins more precisely and center the worksheet • Set paper size and scale • Insert, delete and preview page breaks • Adjust page breaks using Page Break Preview • Add auto-headers and auto-footers and set the starting page number • Add custom headers and footers • Specify different headers and footers for the first, odd and even pages • Print only part of a worksheet • Add row and column data labels and grid lines to printed output • Print several selected worksheets and change the page order • Suppress error messages in printouts
Download course book and sample files from here: https://thesmartmethod.com/you-tube-excel-essential-skills-course-support-materials/ This is the eighth session of our comprehensive 8-session Essential Skills video course. By the end of this session you will be able to: • Save a workbook to a OneDrive • Open a workbook from a OneDrive • Understand operating systems • Understand Excel Online • Open a workbook using Excel Online • Share a link to a workbook • Edit a workbook simultaneously with other users using Excel Online