Cost: $209 Members/$309 Non-Members
*Six (6) CAPS, CAM, CAS, NALP, and CAMT Continuing Education Credits (CECs)*
This live virtual course sets you on the road to creating more advanced Excel workbooks and worksheets. You will learn to work in Excel more efficiently through mastering advanced formulas, performing timely data manipulation and analysis, and creating impressive charts and graphs. You will create spreadsheets and workbooks that you can use to store, manipulate, and share your data more effectively.
This course is the Intermediate Level course.
Who should attend?
Individuals who are comfortable with the basics of Excel and are looking to take their market surveys, owner reports, budgets, make-ready schedules, or sales reports to the next level. This course is designed for individuals who already have foundational knowledge and skills in Excel and are ready to advance their data analysis skills and abilities through the application of Excel techniques such as advanced formula creation, tables, charts, PivotTables and PivotCharts.
- Working With Advanced Functions
- Working with Lists
- Analyzing Data Using Tables
- Visualizing Data with Charts
- Analyzing Data Using PivotTables, Slicers, and PivotCharts
An optional reference book can be purchased here.
Looking for something a little more advanced? Check out our Advanced Excel Course.
For More Information:
Meet Your Instructor:
Ken Carmack has over 20 years of experience in the technology field and provides onsite services for a broad range of IT needs. A former CPA, Ken knows what a business needs, and can help you meet your financial and productivity goals.
Technology is moving at a dizzying pace, one that most people cannot master on a daily basis. Ken plunged into technology as a student at Wake Forest University in the 1980s, working in the main computer center and various student labs. He later served as the technology officer for a commercial real estate company with three offices in North Carolina and is now also an instructor at NC State.
Ken graduated cum laude from Wake Forest University in 1989 with a B.S. in Accounting and went on to earn his CPA certificate. He constantly monitors new technology developments and regularly takes classes on networking, security and hardware/software support to stay abreast of emerging trends. Ken also teaches group, corporate and one-on-one classes in Excel and other technology topics at NC State University’s Technology Training Solutions Center.
In his spare time, Ken enjoys mountain biking, road cycling and running.