Members, make sure you enter coupon code and click on apply coupon to get your discount.
Contact Membership@thecnm.org for the code if you don't know it!
- This event has passed.
Excel – Intermediate
June 6 @ 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! Learning Objectives: 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 FunctionsWork with ListsAnalyze DataVisualize Data with ChartsCreate advanced formulasAnalyze Data with PivotTables and PivotChartsCourse Outline: Working with FunctionsWork with RangesUse Specialized FunctionsWork with Logical FunctionsWork with Date & Time FunctionsWork with Text FunctionsWorking with ListsSort DataFilter DataQuery Data with Database FunctionsOutline and Subtotal DataAnalyzing DataCreate and Modify TablesApply Intermediate Conditional FormattingApply Advanced Conditional FormattingVisualizing Data with ChartsCreate ChartsModify and Format ChartsUse Advanced Chart FeaturesAnalyzing Data with PivotTables and PivotChartsCreate a PivotTableAnalyze PivotTable DataPresent Data with PivotChartsFilter Data by Using Timelines and SlicersTarget Audience: 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: BasicPrerequisites: Have foundational knowledge and skills in ExcelInstructional Method: Adult In-person classroom – Hands-on interaction with Excel 2016 CostRegular rate for this course is $295 — nonprofits registering with CNM benefit regardless of CNM membership! Lunch not provided – hour break for lunchMember – $250 (15% discount) Non-member – $265 (10% discount) Register Here________________________________________________________________________________________ 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. URL:http://cnmconnect.org/event/excel-intermediate-3/