|
Intermediate Excel 201
Discovering the Underlying Power of Excel ~ This workshop assumes that you have either taken the basic Excel workshop or that you are familiar with the basic Excel functions. Here we broaden your knowledge of Excel and teach you new skills that help you work smarter and more quickly using the powerful functions that come with this program. Topics Covered: Creating and Enhancing Charts and Graphs, Cell Styles and Themes, Understanding Cell Values, Auto Sorting and Filters, Text-to-Columns, Concatenation and Special Pasting, Naming Ranges, and Pasting Special Functions. Comes with 34-page manual/workbook. |
Workbook
Exercises
|
Advanced Excel 301
Finding Answers ~ This advanced Excel workshop will show you the way to find answers in data and to communicate those answers to others in such a way that it is interesting, meaningful, and significant. We will also explore how you can quickly and easily develop summaries of large and complex spreadsheets in a matter of seconds. Topics Covered: Conditional Logic, Using If Statements, Conditional Formatting, Data Analysis, Setting up Data and Formulas, Data Tables, Scenario Manager, Goal Seeking, and Pivot Tables. Comes with 28-page manual/workbook. |
Workbook
Exercises
|
Advanced Excel 401
Automating Excel with Macros ~ The final workshop of the series teaches you how to record, read and write macros in Visual Basic (VBA), the types of functions that lend themselves to automation, and how to edit and troubleshoot VBA code. Every effort has been made to keep the workshop simple and easy to understand so that you can begin to automate your routine Excel functions and procedures competently and productively. Topics Covered: Creating VBA Sub Procedure Macros by Recording, Examining and Testing Macros, Understanding VBA Code, Reading and Writing Macros, Debugging Your Macro, Creating and Reading Comments in VBA Code, and Practicing with VBA Macros. Comes with 28-page manual/workbook. |
Workbook
Exercises
|
|
Microsoft Visio is a diagramming program designed to assist users in the creation and illustration of ideas, processes, and systems. It is an easy-to-use tool that helps users visualize, explore, and communicate complex information. With Visio you can easily create flow charts, process diagrams, organization charts, floor plans, maps, brain storming diagrams, charts and graphs. This is a hands-on workshop during which you will learn the fundamentals of diagram creation and actually create diagrams based on your own departmental processes. It comes with a detailed workbook which will serve as an ongoing reference for creating diagrams in future.
|
Workbook
|
|
The addition of data into a diagram makes it more more meaningful and appealing and helps explain the significance of what is being described by the diagram. It is also a way of detecting where problems are occurring so as to alert those responsible to anomalies in the system. This workshop will show you how to import data and display it in many different formats, using lines, colors, icons and measurement tools to help the recipients of your diagram quickly and easily get the global and detailed picture of what your diagram is communicating.
|
Workbook
|
|
Discover your creative potential with this powerful photo editing program available to you in Paint.net. This free, easy-to-use, downloadable program can transform your photos and provide a fun and productive outlet for your creative skills. Bring along your own photos and edit them during class exercises.
|
Workbook
|
|
Learn to create brochures, leaflets, booklets, calendars, etc. with this easy-to-use desktop publishing program. This is a hands-on class in which you will actually create sample media as you explore the range of possible media and publications available in this program. Includes 30-page manual/workbook.
|
Workbook
|
|
Create, combine, and control Adobe PDF documents for easy, more secure distribution, collaboration, and organization. Acrobat 10.0 is versatile, easy-to-use and powerful. Learn and practice a wide range of functions and features in this interactive, hands-on workshop. |
Workbookl
|
|
Adobe LiveCycle Designer enables you to create, distribute and track sophisticated, interactive forms, and quickly collect and review data, providing you with complete control over every phase of data collection and analysis. This workshop is a sequel to the Adobe Acrobat workshop described above.
|
Workbook
|
|
Sometimes seeing columns of figures on a spreadsheet doesn’t convey the essence of a situation or the trend or what’s really going on, and in these circumstances we need to be shown graphically what the figures mean. This is the job of charts and graphs.
In this two and a half hour workshop we will be taking you on a tour of the basics of creating a basic Excel chart through when to use each of the 73 types of charts in the Excel repertoire. We will go through each of the chart tools and show you how to enhance charts and fine-tune them so that they convey the right message for the right people.
|
|
Unleashing the Power of PowerPoint
Attend one or all of the workshops in this four-part series and learn how to design and format slides for maximum appeal. Discover how to use PowerPoint tools, graphics, video and sound, to grab attention and hold interest.
|
|
This workshop is for people who have limited experience with PowerPoint or want a firm grounding in the fundamentals. It covers developing a concept, making an outline in MS Word & importing it, plus editing the slides. It also covers the menu & toolbars, task panes, and differing views. If you want to get it right from the very beginning, this workshop is for you! |
Slides
Workbook
|
|
Learn to format your master slides and other techniques to visually enhance your presentation. Also covered are inserting and editing elements such as tables, charts, diagrams, sound, video, and animation. Experience using PowerPoint is necessary. Attendance at the previous session (Getting Started) is helpful but is not required. |
Slides
Workbook
|
|
Learn the do’s and don’ts of presentation effectiveness and how to impress your audience with a well-timed balance of speech and visual communication. This workshop will help you prepare for and conduct great presentations from organizing, preparing, rehearsing, and delivering your presentation. Also covered are printing handouts and speaker notes, exporting your presentation to other applications and publishing it on the web.
|
|
|
Learn to create well-designed, professional research posters. This workshop will give you a head start in designing and creating great looking posters that attract attention and accentuate the highlights of your research project. Save yourself time and effort by learning the shortcuts to creating killer posters. |
|
|
