

Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Transfers to other open sessions of the same course are available. Series bundles are not eligible for partial drops or refunds. You'll master the art of conditional formatting to highlight duplicate entries, become adept at importing external data using Excel's built-in Power Query tool, learn how use Excel's consolidation function to efficiently summarize data from multiple sources, and so much more.
#OTC MICROSOFT EXCEL CLASS HOW TO#
You'll discover a variety of advanced techniques for PivotTables, and see how to work with the additional analysis tools provided by Excel add-ins. In this course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if data analysis. Maximize your investment in Microsoft Excel 2016 by mastering advanced features that most users don't even know exist. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. These programs are used to handle common. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitive tasks. This course bundle will introduce you to Microsoft Word 2019, Microsoft Excel 2019, and Microsoft PowerPoint 2019. In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. Classroom locations frequently change as the college seeks to most efficiently utilize all facilities.
#OTC MICROSOFT EXCEL CLASS INSTALL#
This is a free install for personal devices PC and Mac. What is Office 365 Office 365 includes the 2016 version of Word, Excel, PowerPoint, Outlook and OneNote. This schedule automatically refreshes every 5 minutes. Office 365 Information Consult the following Microsoft Office 365 FAQs for information about installation and deactivation. Within each schedule, closed sections are indicated in red. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. The complete Ozarks Technical Community College class schedules of course offerings are available online through the links below. In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. Each course within the Excel Series will build upon the last, giving you expert knowledge in navigating and using the software.
