813-261-6018 ext. 702
sperera@mylearningalliance.com
Follow Us:
Category

MS Office Applications Training

Microsoft® Outlook (Level 1)

/
Posted By
/
Comments0
Read More

Description: This course includes quick-start information on configuring of an e-mail account, receiving e-mail, managing e-mail messages, and getting help; a complete overview of the ribbon interface; and an introduction to the calendar, contacts, tasks, notes, and journal folders.

Microsoft®-Outlook-Level-1

Microsoft® Excel (Level 3)

/
Posted By
/
Comments0
Read More

Description: This Advanced level is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, goal seek, Solver, PowerPivot, and advanced functions. Highlights of the course include a solid introduction to creating PivotTables with PowerPivot, coverage of advanced financial functions, hands-on practice with VLOOKUP, and extensive coverage of PivotTables and PivotCharts.

Microsoft®-Excel-Level-3

Microsoft® Excel (Level 2)

/
Posted By
/
Comments0
Read More

Description: Intermediate level is intended to help everyday users of Excel become more proficient by expanding their knowledge of functions, formulas, and new Excel features. Participants will learn how to properly reference cells, use mathematical operators, and how to check their formulas for errors. This class also covers how to browse, insert, and use functions to perform complex mathematical operations. Students will learn how to use the IF function, use nested functions to perform multiple operations, and define and use range names. Finally, array formulas will be discussed.

Microsoft®-Excel-Level-2

Microsoft® Excel (Level 1)

/
Posted By
/
Comments0
Read More

Description: This Foundation level is intended to help all novice computer users learn about workbooks, worksheets, file types, and how to navigate around a spreadsheet. The Help feature is also covered in detail. The class covers the basics of the Quick Access Toolbar and the basics of the Home, Insert, Page Layout, Formulas, Data, and Review tabs. Finally you will be introduced to creating worksheet labels, printing, using features like AutoSum and AutoFill, and how to perform the ubiquitous Cut/Copy/Paste operations. Students will also be given a gentle introduction to using formulae, using Paste Special, dealing with advanced paste operations, perform Find and Replace operations, and how to check their spelling.

Microsoft®-Excel-Level-1

Microsoft® Access (Level 3)

/
Posted By
/
Comments0
Read More

Description: Upon successful completion of this course, students will be able to: Organize data: creating and working with tables, constructing table layout, work with charts and graphs, create customized charts, work with organization charts, and customize diagrams. Implementing Audio Visual Effects: incorporate movies and animated GIFs, insert sound effects, and create voice narrations. Special Features and Custom Animation: create photo albums and implement animation. Executing your Presentation: Reviewing your presentation, finishing touches, and delivery options.

Microsoft®-Access-Level-3

Microsoft® Access (Level 2)

/
Posted By
/
Comments0
Read More

Description: Students will learn about advanced file tasks: using computer within access, database management, saving files, exporting files, and linking files. Working with tables: customizing tables, formatting tables, controlling table data entry, and managing table data entry. Working with forms: basic form controls, advanced form controls, formatting your form, formatting controls, and formatting records. Working with reports: organizing report data, formatting reports, and common report tasks. Working with queries: basic queries, multiple table queries, advanced queries, and management (action) queries.

Microsoft®-Access-Level-2