Course Description
Discover the basics, plus expert power tips!Starting with the basics and moving to more advanced features, you'll learn how to turn Excel into your most powerful productivity tool. If you're only tapping into a few of the features of this powerful and versatile software, get set for a productivity explosion! You'll learn hundreds of ways to work faster, smarter, and savvier with Excel!You don't have to waste hours wading through thick manuals … sitting in classes for days, even weeks … fruitlessly punching keys in trial and error learning efforts — forget all that! Our guaranteed one-day computer training gives you the most information possible in the least amount of time. Most of us don't have time in our busy workdays for extended training or on-the-job learning. Enroll in Excel Basics today, and you'll master the basics and move on to the tough stuff — away from deadlines, demands, and office pressures.So many of us work by habit — doing things the same old way we learned to do them the first time. Break free of old habits and discover the Excel power tools that are available and just waiting to be used! You'll learn the ABCs of using charts, graphs, fonts, borders, shading, and more — and produce spreadsheets that communicate better and really get attention! You'll leave the seminar with a pack of professional tips for brilliant, distinctive output every time, on every worksheet!This one-day seminar is for beginning to intermediate users. Learn how to set up Excel to meet your personal needs at work or at home, and customize its many features so that it works for you!Objectives:Master an array of Excel formulas and functions that put spreadsheet power at your fingertips!Design and organize the best possible worksheet — before you enter the first numberGive your worksheets visual punch with exciting charts and graphs, step by step, the easy way!Make editing easy — fearlessly copy, move, delete, insert, or replace anything in your worksheet!Solve common printing problems and end irritating output surprises once and for allMacros now! Even if you're a beginner, create and use simple macros that save time and sidestep mistakes! Agenda
Take a Quick Tour of Excel Basics!Shortcut menus: the most efficient way to access commands for any taskHelp for Help! How to find what you need in Help without the endless searching and scrollingHow to select cells or ranges of cells — 2 methods to choose fromHow to find a single file or a particular workbook in record timeBuild a Worksheet From the Ground UpWhat to consider before you create a worksheet — expert advice on building a worksheet framework that will accomplish your objectivesTips for entering text and numbers, and a super-quick way to cancel or confirm your entryThe view you need — how to zoom in and zoom out of your worksheetWhen titles and labels keep moving out of view: techniques to freeze them in place while you move around your worksheetHarness the Real Power Behind the NumbersFormula and Function basics — on-the-mark advice that will end confusion once and for allMathematical formulas made easy: how to subtract, multiply, or divide dataBasic Excel functions that let you calculate averages, percentages, and much more using built-in predefined formulasLearn the Techniques That Produce Visually Exciting Worksheets!The secrets to attractive, readable worksheets: 5 formatting guidelines that apply to any worksheet you produceHow to control alignment, decimals, dollar signs, and more — in one easy operationFonts, shading, and borders that increase the readability and attractiveness of your worksheetGet the Output You Want Without Trial-and-Error PrintingPrint Options: the many choices Excel gives you to customize your printing. Plus, how to add headers, footers, and page numbers to a worksheetNo more strange page breaks — how to set manual page breaks and ensure that your titles and labels print on every pageAdd Impact and Visual Punch To Your Data!An easy-to-understand glossary of the terms used in charting and graphing dataThe Chart Wizard — how to easily produce vivid, exciting charts to accompany your data, even if you're a total noviceWhere to actually put your chart: all about embedded charts, separate charts, and chart sheets within a workbookGain Speed, Efficiency, and Ease At Every Session!Large worksheets with Split Windows — the best way to effortlessly view distant figures side by sideFor mouse-haters: a quick guide to shortcuts that keep your hands on the keyboardAn end to macro mystery — how you can automate many tasks using macrosOur Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level!