Microsoft has equipped the latest versions of Excel with some amazing “Power” features. In this hands-on Advanced Excel 2016 course taught by Rich Malloy at Norwalk Community College, students will learn how to use the most important of these industrial-strength tools: specifically, Power Query (also known as Get & Transform), Power Pivot, and Power View.
The course includes a review of Excel’s database features such as pivot tables, the VLOOKUP function, and the INDEX/MATCH combination. Students will also learn how to use Excel’s new formatted tables and slicers and how to take advantage of macros and the Visual Basic for Applications programming language.
The six-session course will be held on Wednesday evenings from 6 pm to 9 pm. The first session is scheduled to start on April 10. Tuition is just $349. Go to www.norwalk.edu to sign up (use CRN number 5210), or visit the campus (directions).
The next session of my 1-Hour Website mini-course will be on Wednesday evening, September 26. WordPress.com is the fastest and least expensive way to get a professional looking website up and running. No programming language is involved. Join thousands of photographers, bloggers and small businesses creating new WordPress sites each day. In this hands-on course, you will learn how to get a site up quickly, how to refine it with the right design, how to add new content quickly, and how to format pictures for the best impact. 
Students will learn the essentials for planning and designing databases, building and modifying tables and forms, defining table relationships, producing reports, working with queries in Access and integrating with Microsoft Word and Excel. During this six-week class, each student will create a complete database application for managing contacts.