Overview:
Basic Excel skills needed to create and manipulate data in an Excel spreadsheet.
Why you should Attend:
Are you wasting time fighting Excel? Instead, you could be working with how Excel is designed to be operated and improve your output, save time, and be confident about your work.
In an hour I will show you the basics of Excel so that you can begin to organize and calculate data right away. Don’t dismiss the basics! You might have been able to get around some of these issues, but working with Excel instead of against it is going to make your job so much easier and prepare you for more advanced functions.
Excel is a powerful and versatile tool you already have the only thing keeping from tapping into its power is knowledge.
Topics include using autofill, creating a custom autofill list, the golden rule of Excel, creating formulas and functions and understanding the difference, copying formulas and functions, relative vs. absolute references (the key to Excel!), your Aunt Sally and why you need to remember her, and formatting in Excel.
Areas Covered in the Session:
- Getting the most from Autofill
- The Golden Rule of Excel
- Formulas, Functions and why you should care about the difference
- The key to Excel - Relative and Absolute references
- How your Aunt Sally can help you in Excel
- Formatting know-how in Excel
Who Will Benefit:
- Administrative assistant
- Human resources (HR) administrator
- Market researcher
- Sales Manager
- Medical Administration
- Rising High School Grads
- Fleet Manager
- Cost Estimator
- Project Manager