* Shortcuts for Applying Formats * Shortcuts for General Number & Scientific Number Formats * Shortcuts for Time and Date Format * Shortcuts for Percentage Format * Shortcuts for Currency Format Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to format numbers. * Shortcuts for Autosum * Shortcuts for Copy Formulas Down * Shortcuts for Insert Functions, Formulas and Arguments * Shortcuts for Array Formulas * Shortcuts for Calculate the Worksheet Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to to enter formulas. Learn Excel Basics - Excel for Beginners Tutorials Basic Excel Skills - The best way to learn Excel Online * Free Excel 2010 Training * 6 Online Excel Tutorials * Parts of the Screen * Columns, Rows, Cells * Parts of the Worksheet Starting out in Excel it’s important to identify and understand all what you see on the screen. The Ribbon, Tabs, the Quick Access Toolbar, the Name Box, the Formula Bar, Column and Row Labels, Cells and Cell Addresses and the Worksheet Tabs. * Saving and Opening a Workbook * Creating a New Workbook * Recent Places * Print Preview An overview of the common tasks that can be completed using the File Tab aka The Backstage View including the list of recent documents, using pushpins to keep documents at the top of the list, print and print preview, and save and save as. * Normal View * Page Layout View * Page Break Preview * Zoom Options There are different ways to view your worksheet depending on what you want to do. Understanding and using the different views in Excel can make your work much easier.
This includes Normal, Page Layout, Page Break views and the Zoom feature. * Navigating Around a Worksheet * Selection Methods * The Go To Function Excel worksheets can be quite big and contain multiple columns and rows of data. Knowing how to use the mouse, keyboard and Go To features as well as how to select columns, rows and multiple cells makes using Excel much easier and can save you a lot of time. * How is the Ribbon organized? * How are Tabs organized?
* What are Contextual Tabs? * Identifying Groups on the Ribbon * Show/ Hide the Ribbon The Ribbon replaces the old Menu system.