MicroAssist Newsletter | September 2011

The E-Learning Council will host its first happy hour at Beale Street Tavern on Historic East 6th Street on Wednesday, August 31st. Check out the E-Learning Council's website for more details!


E-Learning Symposium 2011 Houston

Time is almost up to get your Early Bird tickets to E-Learning Symposium 2011 Houston!
E-Learning Symposium 2011 is an interactive conference designed to help professionals and key decision makers learn how to execute E-Learning programs within their organizations. This event is essential for professionals who manage and design web-based education programs in healthcare, government, higher education, energy, and corportate settings. E-Learning Symposium 2011  brings Industry experts from Texas and beyond to share their knowledge on of-the-moment topics, processes, and technology within the E-Learning world.

Voting Underway for the Top 10 Most Influential E-Learning Blogs

E-Learning Council is looking for the Top 10 Most Influential E-Learning Blogs. Vote for your favorite bloggers and receive a discount code for the E-Learning Symposium 2011 Houston. 
E-Learning Council’s mission is to advance E-Learning through a community that provides leadership, best practices and resources in a collaborative environment. The E-Learning community is fortunate to have dedicated thought leaders who help us in achieving this mission.
You can find E-Learning blogs covering everything from learning theories to content design, survey data to industry trends, and metadata to LMSs. The E-Learning Council wants to find who inspires and influences you, your colleagues and compatriots in E-Learning. Voting for the most influential bloggers will run through September 2nd. On Tuesday, September 6th, we will announce the Top 10 Most Influential E-Learning Blogs.
Visit http://www.elearningcouncil.com/content/vote-top-10-e-learning-thought-leaders to nominate your favorite blog!

Visual Thinking Workshops

MicroAssist is excited to welcome back Allison Crow of Crow Hill Conversations to our classroom! Her workshops at E-Learning Symposium were so popular that we've opened another session August 3rd! The morning will cover the basics of Visual Thinking, and the afternoon will delve deeper into involved learning and push and pull visual thinking methods.
Join Allison for a workshop on the value of using visuals to clarify ideas, ignite inspiration and ambidextrous thinking, to tell stories, and to capture attention and emotion for enhanced learning. Pick up the pen and start learning to get visual thoughts on paper. Learn the Visual Thinking Alphabet and other shortcuts to doodling well, as well as methods to launch your graphic note taking/presenting skills. Students will also discuss application and using visuals in sharing online.
Students are encouraged to bring their iPad, favorite stylus (Allison recommends the BOXWAVE or POGO), and the Notes+ app, but an iPad is by no means required!
Allison's second session will teach students to engage their audience with graphics, how to begin taking sketch notes, and how to create a visual template. Students will also cover the Push method of presenting content and Pull visual thinking methods to engage audiences.
Check out her E-Learning Symposium presentation, then register for the workshop on September 28th!  

The journey from Instructor Led Training (ILT) to Web-Based Training (WBT) is fraught with challenges, but it is undoubtedly a journey worth making. We at MicroAssist would like to serve as your guide. Join us for Part Four of Great Voyages: ILT to WBT, and have lunch on us while Linda Warren takes you through the essentials of moving from "Sage on the Stage" to "Guide on the Side".
Part Three: The Lingua Franca
September 21, 2011 • Houston, Texas
Microsoft South Central District Office
  • Best practices for presenting text online
  • Tips on facilitation of online reading
  • Comparison of reading online and in print
  • Screen design
November will see Part Four: Flying Colors and December the final installment: Land Ho! The Final Steps - Usability & Accessibility. To see more of Linda's work, visit the E-Learning section of our website.

MicroAssist's New Half-Day Classes

Looking to brush up on your skills, but don't want to devote an entire work day to instruction? Are you already familiar with the basics of Microsoft Office, but want to learn some more advanced, practical skills? Come try our half-day classes!
If you have a basic level of familiarity with the program, or have already completed an introductory course, you'll be ready to jump in to these classes.
After just a few short hours of instruction, you'll be heading back to work, ready to implement your new skills.
For more information on these courses, give us a call at 512-794-8440 or fill out our pricing request form. When you're ready to register, download our registration form. Don't see a topic you need listed? Email us at training@microassist.com.

Excel Pivot Tables

  • Fundamentals; creating and customizing a Pivot Table
  • Controlling the view
  • Calculations
  • Visualizations
Sept. 22, 2011 • 8:30 a.m. - 12:30 p.m.
Oct. 6, 2011 • 8:30 a.m. - 12:30 p.m.

Advanced Queries

  • Creating a query; wizards, criteria, properties, calculated fields, totals and summaries
  • Query joins
  • Parameter queries
  • Action queries
Sept. 27, 2011 • 8:30 a.m. - 11:30 a.m.
Oct. 17, 2011 • 8:30 a.m. - 11:30 a.m. 

Sorting and Filtering Data in Excel

  • Creating tables; formatting and modifying tables, calculating data
  • Advanced sorting and filtering; advanced filter, subtotals
Sept. 19, 2011 • 1:30 p.m. - 4:30 p.m.
Oct. 10, 2011 • 8:30 a.m. - 11:30 a.m.

Advanced Functions in Excel

  • Date, text, statistical and logical/information functions
  • Array Formulas
Sept. 19, 2011 • 8:30 a.m. - 11:30 a.m.
Oct. 10, 2011 • 1:30 p.m. - 4:30 p.m.


Crystal Reports Tip: Add a Watermark to Your Report

Watermarks are an excellent way to ensure continued security for your reports. To add a watermark, first copy the image you would like to use to the Page Header section. Select Go to Report > Section Expert. Select the Page Header under Sections, then check Underlay Following Sections on the Common tab. Click OK, and your report will be watermarked!
If you would like the watermark to appear on the first page of the report only, add it to the Report Header section instead of the Page Header section. Make sure the watermark is light enough to read the report!