This webinar will show you how to set up your spreadsheet, how to use the powerful auto-fill feature to help you build it more quickly. You will learn how to efficiently add up a whole column of numbers with autosum. You will also learn the proper way to perform math calculations and formulas in your spreadsheets. The webinar will also cover formatting your spreadsheet to make it look great. It is becoming must-know information to know Excel. This webinar will start at the beginning, and really show you how to build a spreadsheet from scratch, and give you the basic building blocks you need to build more complicated spreadsheets.
In this information age, there is an overwhelming amount of data out there. You and your company may be literally swamped with thousands or even tens of thousands of lines of transactions. Microsoft Excel can really help manage that data and organize your business and get you real results, when used properly.
Areas covered in this webinar – Function and Purpose
- Navigating around the spreadsheet
- Basic terminology
- Adding data to the spreadsheet
- The powerful autofill feature
- Adding up a column with autosum
- Building mathematical formulas
- Copying formulas with autofill
- Relative and absolute formulas
- Creating headers with merge and center
- Formating the spreadsheet to make it look better
Who will benefit from this webinar
- Business owners
- CEO’s / CFO’s / CTO’s
- Managers of all levels
- Administrative assistants
- Anybody who would like to use Excel on a regular basis to be more efficient and productive.
Presenter – Tom Fragale
Tom Fragale, a computer professional with over 30 years of professional experience, has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.