Lynda Excel 3 Courses
English | MOV | 1.08 GB
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cell ranges
Formatting data and worksheets
Finding and replacing data
Creating SmartArt diagrams
Creating charts and PivotTables
Recording macros
Sharing workbooks
Introduction
1. Getting Started
2. Worksheet Basics
3. Excel Formula Basics
4. Essential Formatting
5. Advanced Formatting
6. Printing Preparation
7. Large Excel Projects
8. Collaborating with Others
9. Exploring Excel�s Database Features
10. Analyzing Data
11. Advanced Analysis with PivotTables
12. Creating and Using Charts
13. Creating and Using Macros
14. Customizing Excel
Conclusion
Pure VPN - Up to 27 Months
Gemini AI PRO 18 months Offer
