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  
CECM409  –  Intermediate Excel

Build upon the foundational knowledge presented in the Introduction to Excel course and start down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. You will learn 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 auto calculate
    • 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

Additional Info:

Date(s) Meeting Day(s) Time Location    
10/26/2023 - 11/16/2023 R 8:30 AM - 10:30 AM Live Online Fee: $149.00 Share

Prerequisites: It is strongly suggested to take Introduction to Excel prior to enrolling in the Intermediate course. Many students (even those well-versed in Excel) feel behind jumping right to the Intermediate level.

 

CECM410  –  Advanced Excel

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. You will learn 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

Additional Info:

Date(s) Meeting Day(s) Time Location    
11/30/2023 - 12/21/2023 R 8:30 AM - 10:30 AM Live Online Fee: $149.00 Share

 

 

CECM408  –  Introduction to Excel

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. 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

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.