Learn the foundational skills necessary to create and edit professional-looking spreadsheets. Topics include an introduction to Excel, constructing cell data, using formulas, functions, formatting worksheets, viewing and printing workbooks, charts, graphics; and analyzing, organizing and sharing workbooks.
Building upon skills learned in the Excel 2013 Level 1 course, students will learn to prepare and navigate workbooks, enhance charts, use tables and analysis tools, and explore ways to share this information with internal and external customers.
Microsoft Excel Level 3 Advanced
In this practical and information-packed course, you’ll see how to maximize this program’s functions and capabilities. Learn how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You’ll discover advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You’ll learn how to use Excel’s consolidation function to efficiently summarize data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Available for online independent study with our online educational partner ed2go. For more information or to register, visit ed2go.com/kc
Learn the fundamental skills necessary to create and format business documents such as letters, forms, and newsletters. Topics included creating a new document, manipulating text, formatting content, working with tabs, formatting documents, printing, using tables, working with illustrations, creating mass mailing documents, and sharing documents.
Learn the intermediate skills to create and format business documents such as online forms, personalized mailings, or cite reference sources. Topics include sharing and maintaining documents, formatting content, tracking and reviewing documents, merging documents, and using forms and macros. Course content provides a review of core skills as well as discussion of more advanced features.
Learn the PowerPoint® skills necessary to create and manage presentations. Topics include creating a presentation, working with text, working with illustrations and other media, charts and tables, and enhancing, reviewing, and delivering presentations.
This course teaches students how Outlook is structured and how to maximize its features for effective communication and collaboration. Topics include managing e-mail, using the calendar, working with contacts, using tasks and notes, and organizing information.
This course teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries, and more while applying intermediate skills to streamline data entry, ensure data integrity, automate tasks, and analyze data. Students will explore the Expression Builder to create expressions and insert identifiers as property settings, use form controls to locate information and restrict data entry.
Microsoft Project is a powerful tool that allows users to track the progress of their projects. Microsoft Project has features to help users manage time, budgets and resources as well as schedule and track project tasks. Students will use advanced functions to customize a project plan. Topics include using drawing tools, setting options, workgroup functions, Project Central, sharing data among programs, multi-project management, cost management, tracking results, and resource and task management.
TEXTBOOK: There is no required Textbook for this course, student printed materials will be provided in class.