SECRETS OF BETTER PHOTOGRAPHY Designed for both film and digital photographers, this course is filled with tips and tricks to help you take better photographs. Learn the basic technology that all cameras use, and receive helpful information on exposure and lighting. Explore strategies for taking excellent photos in all types of situations, including portraiture, landscape, Macro, and still. Real Estate REAL ESTATE INVESTING Learn how to invest in foreclosures, manage a rehab project, and build your team of real estate professionals (title officers, lawyers, accountants, mortgage brokers, appraisers, and more). Explore the effects of higher interest rates and cover alternative strategies for a changing market. By the end of the course, you can be working toward your first (or next) deal. Technology Business/Office Applications ADVANCED MICROSOFT EXCEL 2016 OR 2019 Learn to use scenarios and data tables to quickly perform multiple what-if analyses. Discover a variety of advanced pivot table techniques, like creating calculated fields and calculated items. Use validation to protect the integrity of your worksheets from less expe- rienced users. Become adept at consolidating and importing data and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheets, and find out how to nest one function inside another to accomplish just about anything Excel has to offer. COMPUTER SKILLS FOR THE WORKPLACE Learn the fundamental computer skills needed to succeed in today’s workplace. Discover practical applications for email, word processors, spreadsheets, and databases, gaining a working foundation for the critical computer skills you need to survive in the modern job market. INTRODUCTION TO INDESIGN CC Have you ever seen a terrific-looking brochure or newsletter and wondered how it was created? Chances are the designer used Adobe InDesign CC, the industry-standard desktop publishing software now available through the Creative Cloud. In each lesson, learn an important aspect of InDesign CC and prepare a range of print and online products for a fictional company. ADOBE ILLUSTRATOR CC Learn how to navigate the Illustrator environment by creating graphics with basic shapes, working with colors, swatches, fill and stroke. Organize a project, work with layers and artboards, and discover advanced illustration techniques. INTRODUCTION TO PHOTOSHOP CC Photoshop is the world’s most popular photo-editing program. Artists, photographers, designers, and hobbyists rely on Adobe Photoshop for image creation and editing. Learn how to use Photoshop CC with Access is a database used to store and sort useful information. Gain skill in creating tables, relationships, custom data entry forms, queries, reports, mailing labels, and macros. Learn to merge the data in your Access tables with Microsoft Word form letters. Versions available: Office Professional 2010, 2013, and 2016, or newer. Not suitable for Macintosh users. confidence through step-by-step instructions. INTRODUCTION TO MICROSOFT ACCESS
INTRODUCTION TO MICROSOFT EXCEL Discover shortcuts and tricks for setting up fully-formatted work- sheets. Write simple and more complex mathematical formulas; acquire skills in sorting data; create custom charts, graphs, and work- books; build links between files and endow worksheets with decision- making capabilities. Versions available: MS Excel 2010, 2013, and 2016, or newer. Not suitable for Macintosh users. INTERMEDIATE MICROSOFT EXCEL Work faster and more productively with Excel. Use the Pivot Table and AutoFilter to quickly create reports and analyses. Learn advanced graphing techniques and how to use functions to perform complex math. Prerequisite: Introduction to Microsoft Excel (DPR A84) or equivalent. Versions available: Excel 2010, 2013, and 2016, or newer. Not suitable for Macintosh users. INTRODUCTION TO MICROSOFT OUTLOOK Become more organized and productive. Work with Calendar, Contacts, and Research Library. Find out how to protect, backup, and restore your information. Versions available: 2010 or 2013 or newer. Not suitable for Macintosh users. INTRODUCTION TO MICROSOFT POWERPOINT PowerPoint is one of the best presentation programs on the market. Obtain the skills to create overhead transparencies, 35 mm slides, and electronic slide presentations from facts and figures. Dazzle audiences with multimedia slides, charts, outlines, and graphs. Learn how to add clip art, hypertext links, and special effects to presentations. Versions available: MS Office Professional 2010, 2013, and 2016, or Learn to edit, format, copy, and move text; work on two or more documents simultaneously; change margins and tab settings; auto- matically center, right align, justify and indent text; run grammar and spell check; use the thesaurus; and organize and print documents. Versions available: Office 2010, 2013, and 2016, or newer. Not suitable for Macintosh users. INTERMEDIATE MICROSOFT WORD Become familiar with Word’s formatting and publishing capabilities. Create flyers, newsletters, and other heavily formatted documents. Set up columns and tables within your documents; insert, reposition, and resize graphics; surround your text or graphics with borders. Create dramatic effects by varying the size and appearance of your text. Versions available: Office 2010, 2013, and 2016, or newer. Not suitable for Macintosh users. INTRODUCTION TO QUICKBOOKS newer. Not suitable for Macintosh users. INTRODUCTION TO MICROSOFT WORD Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. Quick- Books is designed for the small- to midsized-business owner who needs a fully functional accounting system that’s easy to use. In 12 lessons, gain hands-on experience as you master the tools to set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports. Versions available: 2015, 2016, 2017, 2018, or newer. Not suitable for Macintosh users. Database INTRODUCTION TO SQL Learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques. Requirements: Any desktop or client/server database management system (DBMS) that supports the execution of Structured Query Language (SQL). Examples include Microsoft Access, SQL Server Personal Edition, SQL Server Desktop Engine (MSDE), MySQL, Sybase, Microsoft SQL Server, or SQL Server Enterprise.
For more information, visit ed2go.com/oakton.all
11
Made with FlippingBook. PDF to flipbook with ease