Biblioteca CUN Search for 'an:156027'

Excel 2016 Intermediate

By Edward McCrae.
Intellezy Business , This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. 002-16-2

]]> Place hold on Excel 2016 Intermediate

Excel 2016 Beginner

By Edward McCrae.
Intellezy Business , Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. 002-16-1

]]> Place hold on Excel 2016 Beginner

Excel 2016 Advanced

By Edward McCrae.
Intellezy Business , This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. 002-16-3

]]> Place hold on Excel 2016 Advanced

Excel 2013 Advanced

By Edward McCrae.
Intellezy Business , This course will teach students advanced concepts and formulas in Microsoft Excel 2013. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. 002-13-3

]]> Place hold on Excel 2013 Advanced

Access 2016 Beginner

By Edward McCrae.
Intellezy Business , This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course. 001-16-1

]]> Place hold on Access 2016 Beginner

Project 2016 Beginner

By Edward McCrae.
Intellezy Business , Microsoft Project is a project management software program that is designed to assist a project manager in developing a plan, assigning resources to tasks, tracking progress, managing the budget, and analyzing workloads. This course is designed specifically to teach students the fundamentals of working with Microsoft Project. Students will learn to work with task, resource, and other views, and work with tables. Students will then create a new project plan, set plan properties, create and customize a plan calendar. Additionally, the student will add tasks, create recurring task, import tasks from Excel and Outlook, create a work breakdown structure, link tasks and create dependencies, and modify task properties. Then students will create resources, work with a resource pool, modify resource calendars, and assign resources. Finally, students will prepare a project plan for finalization. 005-16-1

]]> Place hold on Project 2016 Beginner

Outlook 2013 Beginner

By Edward McCrae.
Intellezy Business , This course is designed to teach students the basics of Microsoft Outlook 2013 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures. 003-13-1

]]> Place hold on Outlook 2013 Beginner

Project 2013 Beginner

]]> Place hold on Project 2013 Beginner

Visio 2016 Beginner

By Edward McCrae.
Intellezy Business , This course teaches the basic functions and features of Visio Professional 2016. The primary focus is to get acquainted with creating the different diagrams using the stencils and templates. You will learn how to draw basic shapes and compound lines and arrange objects. You will also learn how to create diagrams, work with text, and apply formatting. Finally, you will create organization charts and brainstorming diagrams, set shape properties, and work with pages. 008-16-1

]]> Place hold on Visio 2016 Beginner

Project 2016 Advanced

By Edward McCrae.
Intellezy Business , "This course covers the features within Microsoft Project 2016 that every project manager needs to know. Students will learn how to update tasks, split tasks, reschedule project work, move a project and set new baselines. In addition, students will learn to use the variance table, display progress lines, edit and create custom tables, create custom views, and sort and filter project information. Students will work with Project reports, create custom reports, and work with visual reports. Finally, students will set default options, save a project template, use the content organizer, compare Project versions and work with Subprojects." 005-16-3

]]> Place hold on Project 2016 Advanced

Access 2019 Advanced

By Edward McCrae.
Intellezy Business , Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. 001-19-3

]]> Place hold on Access 2019 Advanced

Excel 2013 Intermediate

By Edward McCrae.
Intellezy Business , This course is designed to be the intermediate level of Excel 2013. Students will learn intermediate functions and formulas, be introduced to and work with PivotTables and Tables, work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment. 002-13-2

]]> Place hold on Excel 2013 Intermediate

Publisher 2016 Beginner

By Edward McCrae.
Intellezy Business , This course is designed to help students become comfortable with the tools of Microsoft Publisher, a desktop publishing application, and allow them to create professional-looking flyers, posters, catalogs, newsletters, and more. The course will focus on structuring documents, modifying text, working with shapes and images, and formatting and finalizing documents. 043-16-1

]]> Place hold on Publisher 2016 Beginner

Access 2016 Advanced

By Edward McCrae.
Intellezy Business , "Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events." 001-16-3

]]> Place hold on Access 2016 Advanced

OneNote 2016 - A Complete Guide Beginner

By Edward McCrae.
Intellezy Business , This course is an introduction to, and in-depth look at the OneNote 2016 program. During the course, students will learn how OneNote can help them to organize their notes more efficiently, and allow them to access their content from anywhere. Students will also learn how to share the contents of their OneNote notebooks with others, and collaborate.Â 032-16-1

]]> Place hold on OneNote 2016 - A Complete Guide Beginner

Outlook 2013 Advanced

By Edward McCrae.
Intellezy Business , In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2013. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review advanced calendar and task usage, rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data. 003-13-2

]]> Place hold on Outlook 2013 Advanced

Access 365 Advanced

By Edward McCrae.
Intellezy Business , Access 365 Advanced will further build upon the topics covered in the Access 365 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create backups, create and modify Navigation Forms, set startup options, split a database, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), convert macros to VBA, and use Table Events. 001-365-3

]]> Place hold on Access 365 Advanced