Desktop Application Training
Keyword: EXEC for all Executrain courses
Microsoft Excel 2010 Basic
After an introduction to spreadsheet terminology and Excel's window components, participants will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Participants will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, participants will create and modify charts, and learn how to manage large workbooks.
Microsoft Excel 2010 Intermediate
This course builds on the skills and concepts taught in Excel 2010: Basic, First Look Edition. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trend-lines and spark-lines, worksheet auditing and protection, file sharing and merging, and workbook templates.
Microsoft Excel 2010 Advanced
This course builds on the skills and concepts taught in Excel 2010: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
Adobe Acrobat X Pro – Level 1
Participants will learn PDF basics and explore the Acrobat interface. They'll learn how to navigate and organize PDF documents. Participants will learn how to create a PDF document from within Acrobat. They will also create PDF documents from within other applications such as word processors or other Adobe Creative Suite applications, and create documents from Web pages. Participants will learn to modify PDF content by rearranging, editing, and formatting existing text and by adding headers, footers, watermarks, and backgrounds. They'll learn how to multimedia content, including audio, video, and flash files. They'll add bookmarks and links, and improve accessibility in a document. Participants will learn to manage security issues by using password encryption and digital signatures. They'll explore document review techniques, including the use of comments, markups, and automated reviews, such as Page View Sharing and Collaborate Live.
Microsoft Office Project 2007
Microsoft Office Project 2007 enables you to create and manage your projects in a standalone desktop environment. In this Microsoft Project 2007 Training class, you will create a project plan containing tasks, organize these tasks in a work breakdown structure containing task relationships, create and assign resources, and finalize the project to implement the project plan. You will also learn to use Microsoft Office Project 2007 to exchange project plan data with other applications, update project plans, create visual reports, and reuse project plan information.