Skip Navigation
Close Window
CECM410/Workshop/30 - Advanced Excel 2016
|
Credits
0.00
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.
Teaching Mode:
Teaching Mode
View Book Information
Registration Type
Continuing Education
Fees
Noncredit Course Fee
$149.00
(
Fee Group
All)
Instructors
TBD
Duration
7/14/2020 - 7/14/2020
Schedule
T 8:30 AM - 4:30 PM; Distance Learn - Web, , Room
Credit Types
Con-Ed State Aidable Con-Ed Contract NSA Con-Ed Non-State Aid
Class
14
Seats
| 14
Remaining
Primary population and other student populations allowed to register for this course:
Primary Population
# Others Allowed
# Others Registered
Campus
Tompkins Cortland Community College
14
0
Program
Continuing Educ
14
0
College
Professional Develop
14
0
Class Level
Non-Degree
14
0
Population
Continuing Education
14
0