Skip to main content

Advanced Microsoft Excel 2007

ID : 23651   
« back to classes page
Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you'll see how to maximize Excel's functions and capabilities.

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making.

Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
 

Click here for class start dates, syllabus, requirements and student reviews.

Call 701-224-5600 to register Send to Friend » Checkout »

Class Details

0 Sessions

Start Date:upon registration

 

Notice

Please read:  BSC has partnered with Ed2Go, one of the industry leaders in online learning for adults, to provide this online class. Most Ed2Go classes start either the 2nd or 3rd Wednesday of each month. All registrations after the class start date will be enrolled in the next month’s class session.

These six-week online instructor-led courses are the perfect way to learn a new skill or enhance your existing ones. You'll spend roughly two to four hours each week completing two engaging lessons in an enjoyable, interactive learning environment. Expert instructors develop and lead every course, and you'll be able to interact with them and with fellow students in online discussion areas. Upon completing a course with a passing score, you'll get an award of completion.

Fee: 

$99.00


Registration Closes On
Wednesday, January 31, 2018 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)