BONUS! LEXX Online Subscription Included: All LEXX Live students receive complimentary ninety (90) day access to the LEXX Online learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
This one day, instructor led Excel Intermediate course with Google Sheets builds on the basic concepts and skills of our Introduction to Excel course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel. At the completion of this course, participants will be able to:
- Identify afferences and similarities between Excel and Google Sheets
- Determine the pros and cons of using Excel and Google Sheets
- Manage workbooks and customize the Excel environment
- Use named ranges in formulas
- Organize Excel tables and how to sort data
- Use PivotTables
- Use conditional formatting
- Use special chart features
- Implement permissions to control access to and prevent changes in your workbook
Schedule
Currently, there are no public classes scheduled. Please contact a LEXX LIVETraining Consultant to discuss hosting a private class at 301-258-8200.
Course Outline
Introduction
- Module A key differences Googles Sheets
- Module C: Differences between Excels and Google Sheets
- Module D: Pros and Cons of Excel and Google Sheets
Chapter 1: Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
Chapter 2: Named ranges
- Module A: Using names in formulas
Chapter 3: Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
Chapter 4: Summarizing data
- Module A: Consolidation
- Module B: Subtotals
Chapter 5: PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
Chapter 6: Presentation features
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
Chapter 7: Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
Chapter 8: Collaboration
- Module A: Permissions
- Module B: Shared workbooks
BONUS! LEXX Online Subscription Included: All LEXX Live students receive complimentary ninety (90) day access to the LEXX Online learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
LEXX Live is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
Hubs