This hands-on class will prepare you to link workbooks to manage larger data sets, employ advanced formatting techniques on tables and charts, create custom filters to target specific data for analysis and allow multiple users to work on a spreadsheet while protecting critical data from deletion.
Students will learn to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Taking a class for work? Access exclusive perks and savings for free.
Learn More »
Students will learn to enhance your presentations using more advanced PowerPoint features.
In this half-day session, you will learn how to format paragraphs precisely, edit text with spell check and search-and-replace, and insert professional-looking images and illustrations to strengthen your message.
You will learn how to apply, define, redefine and import styles, which let you make global formatting changes instantly. You will learn how to use section formatting to set headers and footers with page numbers and build multiple column layouts. You will also learn how to automate text entry with AutoCorrect and AutoTex
This Excel 2007/2010 Advanced course will provide you with experience using Excel's powerful data analysis and presentation tools, advanced functions, conditional cell formatting, and macros to automate your work. The classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010, so that you will leave prepared to use the advanced features of
This 1 day course provides students with the knowledge and skills to use advanced features in creating and analyzing databases. Students will learn how to sort and manage data in lists; filter and query data; apply lookup and database functions. Students will also learn how to analyze and evaluate the information in databases by creating pivot table and pivot charts.
This one-day course empowers information workers the knowledge and skills to incorporate multimedia elements into Microsoft PowerPoint presentations.
Students will have proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Microsoft Outlook to update d
Excel VBA (Visual Basic for Applications) lets you develop full-featured spreadsheet applications using a visual-style editor. You can create user controls, set properties, sort rows and columns, and update data on the fly - all from inside your scripted application. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel
This one-day instructor-ledcourse provides students with an overview of the features and functions of Microsoft Excel 2010.
The CourseHorse Techie Holiday Gift Card can be used on any of the thousands of tech classes on CourseHorse, comes in any denomination, and never expires.
This one-day instructor-led course provides students with an overview of the features and functions of Microsoft Outlook 2010.
This three-day, instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both co
Students will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database.