Office Applications   

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Spreadsheets are essential in today's workplace. Discover the fundamentals that will help you succeed. Explore the Excel Interface, Distinguish between various mouse pointers, employ efficient worksheet navigation, enter labels/values, edit and format a worksheet and even get an introduction to formulas.

Large excel spreadsheets can quickly become difficult to translate. Learn to communicate information visually with the use of Excel Charts. Explore and fine-tune your chart elements with ease. Learn to manage workbooks, exploration of special formatting, advanced page layout and printing features. Also get an introduction to Excel functions to prepare you for Excel III & IV.

Large excel spreadsheets can quickly become difficult to translate. Learn to communicate information visually with the use of Excel Charts. Explore and fine-tune your chart elements with ease. Learn to manage workbooks, exploration of special formatting, advanced page layout and printing features. Also get an introduction to Excel functions to prepare you for Excel III & IV.

Learn to create date and text filters for viewing information more efficiently. Learn how to use subtotals, a powerful analyzing tool, and more for filling/copying data more efficiently. This class also serves as a formal introduction to formulas and functions, so you will walk away knowing how to create formulas and copy them correctly using relative and absolute referencing. Use statistical functions (Sum, Average, Min and Max) and logical functions (If, And, Or) and paste special options.

Learn to create date and text filters for viewing information more efficiently. Learn how to use subtotals, a powerful analyzing tool, and more for filling/copying data more efficiently. This class also serves as a formal introduction to formulas and functions, so you will walk away knowing how to create formulas and copy them correctly using relative and absolute referencing. Use statistical functions (Sum, Average, Min and Max) and logical functions (If, And, Or) and paste special options.

Review basic building-block functions and a few critical keyboard shortcuts that will speed up working with Excel data. Perform advanced searching and data retrieval with Lookup Functions, tabulate and sort data with counting and statistical functions, formulate data with text and math functions, and even work with financial data using advanced formulas. Practical examples that will help you transition to using these formulas and functions in real-world scenarios will be provided.

Review basic building-block functions and a few critical keyboard shortcuts that will speed up working with Excel data. Perform advanced searching and data retrieval with Lookup Functions, tabulate and sort data with counting and statistical functions, formulate data with text and math functions, and even work with financial data using advanced formulas. Practical examples that will help you transition to using these formulas and functions in real-world scenarios will be provided.

Learn even more advanced way to use Excel Pivot table reports! Find out how to use the PMT Function, Create What-If Data Table, Solve a Problem with Goal Seek, Use Solver to Resolve Problems, Create Lookup Functions, Create PivotTables and PivotCharts, and Use the PivotTable Field List.

Learn even more advanced way to use Excel Pivot table reports! Find out how to use the PMT Function, Create What-If Data Table, Solve a Problem with Goal Seek, Use Solver to Resolve Problems, Create Lookup Functions, Create PivotTables and PivotCharts, and Use the PivotTable Field List.

Get started with Microsoft PowerPoint and learn the fundamental skills for creating high-impact slide decks. You will master essential elements, including adding and formatting text, images, video, audio, and charts. Discover how to use animation and hyperlinks to engage your audience. Finally, learn how to properly save and distribute your presentations for easy sharing across the web or other media.

Dive deeper into the program's rich feature set to enhance your presentations and boost audience engagement. This course focuses on achieving Professional Design by utilizing Slide Masters for global consistency, mastering Visual Elements such as advanced text options, custom charts, pictures, and SmartArt, and adding Motion & Media through Custom Animations and integrated sound/movie clips for maximum impact. Furthermore, you will learn to build Interactivity by creating a non-linear presentation with Action Buttons for dynamic navigation.

Learn to create, format, and manage documents with confidence. This course covers core skills: text editing and movement, advanced text formatting (size, font, appearance), professional layout controls (margins, tabs, alignment), and productivity tools like the integrated spell/grammar check and thesaurus. You will also learn to work with multiple documents and efficiently save, retrieve, and organize your files.

Learn advanced techniques to create professional, visually rich documents and boost your productivity. This course covers everything from Headers and Footers to timesaving formatting tricks. You will master setting custom margins, tabs, indents, and spacing, and learn to effectively work with complex elements like Tables, Pictures, Shapes, and Hyperlinks. Transform your documents with professional design insight.