Members, make sure you enter coupon code and click on apply coupon to get your discount.
Contact firstname.lastname@example.org for the code if you don’t know it!
- This event has passed.
Excel – Intermediate
July 11, 2018 @ 8:00 am - 4:00 pm
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel more effectively is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
As an employee, learning how to use Excel efficiently provides value, since most jobs utilize this application. This opens up more opportunities for employment and career advancement.
When employees know how to use Excel, it improves their efficiency in the workplace. Employees who know how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.
The Excel – Intermediate session will help participants to create advanced workbooks and worksheets that can help them use the program and deepen their understanding of their organization’s information. This course will use Microsoft Office Excel 2016 – computers and software will be provided for instruction purposes. Don’t have the 2016 version? No problem – you can still apply most of what you learn in this session to older versions and/or nonprofits can purchase the newer version at a significantly lower price through TechSoup!
Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will:
- Work with Functions
- Work with Lists
- Analyze Data
- Visualize Data with Charts
- Create advanced formulas
- Analyze Data with PivotTables and PivotCharts
- Working with Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
- Working with Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
- Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
- Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Analyzing Data with PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Program Level: Basic
Prerequisites: Have foundational knowledge and skills in Excel
Instructional Method: Adult In-person classroom – Hands-on interaction with Excel 2016
Social Worker CEU Credits: 7 hours
Regular rate for this course is $295 — nonprofits registering with CNM benefit regardless of CNM membership! Lunch not provided – hour break for lunch
Member – $250/Non-member – $265
ABOUT NEW HORIZONS
For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer courses and certifications at over 300 computer trainings centers in 70 countries. As the world’s largest independent IT training company, they are ranked in the top 5% of the industry for training quality and customer satisfaction. New Horizons is an official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VM Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide. For students that means training with the highest quality source materials and the latest products and technologies. For businesses it means getting the highest return on their training investment.