Category:

Course Description:

Learning objectives: – Learn a faster way to use the fill handle in Excel. – Learn how to use the Format Painter in Excel. – Learn an Excel keyboard shortcut that makes the AutoSum function even faster. – Learn how to add shortcuts to the Quick Access Toolbar in Excel. – Learn a shortcut for making an exact copy of an existing worksheet. – Learn a shortcut for quickly jumping to any sheet within a workbook. – Learn these Excel shortcuts for selecting an entire row or column at one time. – Learn how to find a sum without using a formula. – Use the Center Across Selection feature to easily merge cells in Excel. – Learn how to browse through different visualization options with the Quick Analysis tool. – Learn how to use tables to keep charts up to date using this Excel feature. – Learn how to use the Transpose feature to rearrange your data instantly. – Learn how to convert a cell reference to an absolute reference with the F4 key. – Learn a keyboard shortcut that lets you add a row anywhere in your spreadsheet. – Learn how to use an entire column as a cell range in Excel. – Learn how to use named ranges to make your formulas easier to write and read. – Learn a trick for quickly finding inconsistent data in a large spreadsheet. – Use VLOOKUP to find specific information in your worksheet. – Use SUMPRODUCT to calculate weighted averages. – Use the PROPER function to capitalize names in your spreadsheet. – Use the COUNTA function for counting cells and for determining how many cells have data in them. – Use the CONCATENATE function to combine two or more things in one cell. – Use these tips for printing Excel spreadsheets. – Learn how to work with fractions in Excel. – Learn how to add line breaks in Excel. – Use these free resources for learning Office for Mac. – Use regional settings in Excel to use the program in any language.

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.