Course description
Microsoft Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This new version of Excel incorporates robust error checking, numerous file validation/verification tools, image editing, and Sparklines (charts within individual cells). This Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. This manual will also help more experienced users who have little to no experience with Excel and the ribbon interface.
Upcoming start dates
Who should attend?
Training content
Section 1: Advanced File Tasks
- Using Windows Explorer within Excel
- Saving your Files
- Using File Management Tools, Part One
- Using File Management Tools, Part Two
Section 2: Working with Functions and Formulas
- Using Formulas in Excel, Part 1
- Using Formulas in Excel, Part 2
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
- Working with Array Formulas
Section 3: Managing Tables
- Working with Tables
- Working with Records and Fields
- Working with Tables and Filters
- Using Excel as a Database
Section 4: Adding the Finishing Touches
- Research Tools
- Using Themes
- Adding Text Boxes
- Inserting Pictures and ClipArt
- Editing Pictures
Section 5: Showing Data as a Graphic
- Inserting SmartArt
- Formatting SmartArt
- Adding Symbols, Equations, and Shapes
- Adding Sparklines
- Editing Sparklines
Why choose BBLN?
In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.
All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.
We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.
Contact this provider
Building Blocks Learning Network
Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...