This course is offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class.  Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a computer or laptop with Internet connection, with computer audio or a computer and a phone.

This indispensable course will equip you with the proper tools needed to further your knowledge of databases. The participants learn the different types of queries. They will learn to import and export data from and to other applications. The participants will learn to use the Macro Builder, Expression Builder and Code Builder to further the functionality of controls. They will learn how to safeguard the data.

This is an online course delivered via Zoom. 

BEGINNING EXCEL 2016

Create/save worksheets/workbooks, use formulas/functions, manipulate cells/columns/rows, use Help, search/replace data, proofing, format text/numbers, align cell contents, apply styles/themes/conditional formatting, templates, preview/print, page layout, headers/footers, and apply borders/colors. Prerequisite: Solid understanding and usage of Windows 10.                                     

DATES: SEP 29 – OCT 8, 2020

Unless otherwise noted, all of the Community Education and BTC classes are offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class. Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a current email address, a computer or laptop with Internet connection, computer audio or phone.

This course is offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class.  Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a computer or laptop with Internet connection, with computer audio or a computer and a phone.

This indispensable 2-part course will equip participants with the proper tools needed to manage projects. The participants will learn to organize projects into phases and outline the tasks within each phase. They will learn to set durations to tasks and assign resources, as in; people, materials and cost. The participants will learn to prioritize the flow of projects. They will learn to track the status of tasks and assess if projects are falling behind its trajectory.

This course is offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class.  Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a computer or laptop with Internet connection, with computer audio or a computer and a phone.

This indispensable course will equip participants with the proper tools needed to manage projects. The participants will learn to track progress. They will learn to make adjustments to projects. They will learn to create reports of progress, cost and assignments. The participants will learn to create visual reports using graphs to make timeline comparisons. They will learn to create visual reports into Excel and Visio. They will learn to manage many projects within a master project.

INTERMEDIATE EXCEL 2016                                                             

Learn logical/date/time/text/array/database/specialized functions, graphical objects, sort/filter/query/outline/subtotal data, create/modify/format tables and charts, advanced conditional formatting, pivot tables/charts, and filter with timelines/slicers. Prerequisite: Beginning Excel 2016.   

DATES: OCT 13 – 22, 2020

Unless otherwise noted, all of the Community Education and BTC classes are offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class. Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a current email address, a computer or laptop with Internet connection, computer audio or phone.

BEGINNING WORD 2016

Create/open/view/edit/save/print/navigate documents, format text/paragraphs, page numbering/spacing/headers/footers, tabs, add styles, create/format tables. Prerequisite: Solid understanding and usage of Windows 10.         

DATES: OCT 27 – NOV 5, 2020

Unless otherwise noted, all of the Community Education and BTC classes are offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class. Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a current email address, a computer or laptop with Internet connection, computer audio or phone.

This course is offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class.  Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a computer or laptop with Internet connection, with computer audio or a computer and a phone.

This program is in high demand. It facilitates large datasets from multiple file types to come into one visual – enabling the user to get results with a simple drag and drop. This indispensable course will equip the participants with the proper tools to create multiple data analysis reports with useful illustrations.

The participants will be able to create measures to get key performance indexes of their organization’s products and services. They will be able to create matrixes to compare data in time segments, as in month over month and year over year.

This course is offered online via Zoom. Prior to the class starting, the instructor will email all the registrants a link to sign-in to their Zoom class.  Zoom is a free, interactive online platform, you do not have to have a Zoom account to attend a class being offered through Zoom. You will need a computer or laptop with Internet connection, with computer audio or a computer and a phone.

This level is intended to introduce the participants on the features on the new ribbons -

• PowerView, Power Query and PowerPivot
• Using the powerful features of BI to import large data sets 
• Create Data Modeling in BI 
• Remembering the Steps for Future use of Data Set 
• Data Shaping | Manipulating of Large Data Sets 
• Mapping Data | Graphing Data 
• Introduction to DAX 
• Eliminate Vlookup with Data Modeling 
• GetPivotData Reports