Due to COVID-19, it is possible that classes may be held virtually should restrictions be in place during the date(s) of training

Search & Register for Workshops

Search for Workshops using keywords, titles or Class ID. To show all courses offered select "Show All Courses" from option list and select Go!



 

Additional Online Opportunities

In addition to the course listed below, Biz offers numerous opportunities to earn CEUs and learn skills online.

Ed2go: Monthly, convenient programs with an interactive six-week format that offer an award of completion with passing score.

Career Builder certificate programs: Instructors/mentors are actively involved in your online learning experience, responding to any questions or concerns, as well as encouraging and motivating you to succeed.

Financial assistance is available through private loans, military tuition assistance, and government funding.

Learn more »

Search Results

Search Type: Category; Search Terms: Online Workshops; Location: all;     Clear Search Results
You are viewing page 1 of 1
Course  
CECM138  –  Microsoft Word: Creating Macros and Forms

Microsoft Word: Creating Macros and Forms Learn how to create simple macros in Word. If you have tasks in Microsoft Word that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. Word provides a way that you can create standardized documents rather easily, allowing users to enter only the information that changes from one document to the next. These are called forms and they consist of a protected document template that has special fields inserted within the template

Additional Info:

Date(s) Meeting Day(s) Time Location    
6/22/2021 T 9:00 AM - 11:00 AM OnlineDLW Fee: $49.00 Share

 

 

CECM153  –  Microsoft Excel: Creating Macros, Pivot Tables and Charts

Microsoft Excel: Creating Macros, Pivot Tables and Charts Learn how to create simple macros in Excel. If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. Need to manipulate, analyze, summarize and generate multiple reports from large sets of data? Learn how to create Pivot Tables and Charts

Additional Info:

Date(s) Meeting Day(s) Time Location    
6/8/2021 T 9:00 AM - 11:00 AM OnlineDLW Fee: $49.00 Share

 

 

CECM375  –  Microsoft PowerPoint: Creating a Presentation

Microsoft PowerPoint: Creating a Presentation Learn how to use PowerPoint to create business presentations, but they also can be used for educational or informal purposes. PowerPoint is a powerful tool to use for presentations. It allows you to catch your audience’s attention using visual effects. Learn how to create a Presentation comprised of slides, which may contain text, images, and other media, such as audio clips and movies

Additional Info:

Date(s) Meeting Day(s) Time Location    
7/13/2021 T 9:00 AM - 11:00 AM Distance Learning - Web Fee: $49.00 Share

 

 

CECM408  –  Introduction to Excel 2016

Do you work with numbers and could use an extra hand? Excel is just the extra hand that you need! Through lessons and hands-on labs, you will learn the many shortcuts and tricks Excel has to offer to make quick time of your work. You will learn to:
    • Create, save, and navigate worksheets and workbooks
    • Enter and change data (text and number) and simple formulas
    • Use the sum feature, undo/redo, find and replace, and smart lookup
    • Edit your worksheet using ranges, flash fill, copy and paste, clipboard, drag and drop, insert and delete columns and rows, and change column width and row height
    • Format your worksheet with alignment and text wrapping, cell borders, cell shades, cell colors, merge and center cells, hiding and unhide rows and columns, and freeze and unfreeze rows and columns
    • Setup your worksheet for printing with defining print area, adjusting margins, setting page orientation and size, and inserting headers and footers
    • Insert formulas such as relative, absolute, and mixed references, copy formulas, and insert functions
    • Modify your workbook by adding, deleting, copying, renaming, repositioning, and grouping worksheets Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

No currently scheduled courses available, Contact Biz for more information Biz@tompkinscortland.edu.

 

 

CECM409  –  Intermediate Excel 2016

Now that you’ve mastered the basics of putting to Excel to work for you, join us to discover how to visually display your data with graphs, charts, and graphics, and work collaboratively through workbook collaboration. You will learn how to:
    • Create and modify tables and charts
    • Add pictures, shapes, WordArt and SmartArt, and format drawing objects
    • Work collaboratively with others through emailing a workbook, converting worksheets to web pages, inserting hyperlinks, and viewing and editing comments
    • Use functions such as IF, Nested, PMT, FV and autocalculate
    • Understand date and time function, add date and date interval, subtract dates, and calculate time intervals
    • Create a workbook through a template, create and edit a template, and use and customize sparklines Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

No currently scheduled courses available, Contact Biz for more information Biz@tompkinscortland.edu.

 

 

CECM410  –  Advanced Excel 2016

Become an Excel Master! With features such as tracing and fixing errors, conditional formatting, and removing duplicative data, you can put your data to work for you instead of working for your data! You will learn how to:
    • Import external data, convert text to columns, remove duplicate rows of data, link and embed objects, export data and publish your worksheet or workbook to the web
    • Format your numbers with custom number formatting, apply conditional formatting based on rules or specialized conditional formatting, or create your own formatting rules
    • Use, name and manage ranges, and use the VLOOKUP function
    • Create, run, edit, and save Macros
    • Use data analysis tools to trace cell dependents, and trace and fix errors
    • Create, rearrange, and format a PivotTable, filter PivotTables with Slicers, and create a PivotChart
    • Summarize your data with list subtotals, nesting, advanced filters and data validation
    • Analyze your data with Goal Seek, Solver, creating and displaying scenarios, data tables and forecasting future values
    • Continue workgroup collaboration with features such as locking and unlocking cells, protecting a worksheet, tracking changes, encryption, and checking document compatibility and accessibility Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

No currently scheduled courses available, Contact Biz for more information Biz@tompkinscortland.edu.

 

 

You are viewing page 1 of 1

Not finding the course you need? We offer hundreds of online programs, and we often create special programs in response to area needs. Contact Biz at Biz@tompkinscortland.edu for more information.