Microsoft Office Excel 2007: The L Line, The Express Line to Learning
- 6h 37m
- Kathy Jacobs
- John Wiley & Sons (US)
- 2007
Get on the fast track to mastering Excel
Want to find success in your profession or business? Master the timesaving tools you'll need in the real world, like Excel 2007. Whether you're a student, a professional, or an entrepreneur, you can learn Excel with this start-to-finish guide. Gain solid skills as you go from station to station in a series of clear-cut tutorials on Excel spreadsheet basics, integration with other applications, macro creation, and more. Start your journey today on The L Line.
- Get the basics of the new user interface and how to create spreadsheets
- Apply formulas, build charts, and explore pivot tables
- Filter, sort, analyze, and validate your data
- Customize Excel, create macros, and use add-ins
Along The L Line
- Complete tutorial coverage with step-by-step instruction
- Ample illustrations and examples
- Real-world case studies, applications, and hints for avoiding pitfalls
- Practice exams that let you evaluate your progress
About the Author
Kathy Jacobs, Microsoft MVP in PowerPoint and OneNote, has been using Office since its earliest days. She started out using Word for newsletters, letters, books, and other documents in the late 1980s. She added PowerPoint to her areas of expertise in the early 1990s, when she first moved to Office on the PC while developing training at Honeywell. At that same training job, she started using Excel to create budgets, track students, and perform a wide variety of other tasks. In truth, she couldn’t live without any of the major Office products. She has been an active Office beta tester since its 2002 release and has been working with Office 2007 for many months.
Kathy specializes in helping people from all backgrounds and all walks of life learn to use Office to make their lives easier. As a PowerPoint and OneNote consultant, trainer, and writer, she has written about Office topics for her own site (onppt.com), her blog (Vitamin CH — The cure for all computer ailments), Office Online, Lockergnome, IndeZine, and the PowerPoint FAQ. She presents regularly on a variety of subjects at the Phoenix PC User Group, where she is vice president. She has given the AZ Association of Computer Clubs User Group tour twice, including a tour of Office 2007.
Actively involved in PPT Live (the PowerPoint conference for users) since its inception, Kathy has written Kathy Jacobs on PowerPoint and co-written Unleash the Power of OneNote. She is the creator of KeyStone Learning’s OneNote 2003 training DVD. Right now, she specializes in helping people solve their Office emergencies through her service, Call Kathy Solutions.
In this Book
-
Exploring Excel
-
Creating Your First Excel Worksheet
-
Fine-Tuning Your Worksheet
-
Understanding Excel Formulas
-
Charting—Basic Excel Chart Types and When to Use Them
-
Pivoting Data—Looking at Your Data in a Different Way
-
Adding Data from Other Sources
-
Designing Your Data for Viewing and Printing
-
Exporting Data to Other Applications
-
Sorting and Filtering Data
-
Ensuring Your Data Is Right
-
Analyzing Data with Excel
-
Customizing Excel
-
Extending Excel—Using Existing Add-Ins
-
Programming Excel—An Introduction to VBA and Macros
-
Building Your Own Excel Add-Ins
