Search results for:
No result found! Try with different keywords!
Advertisement

Excel Level 3

Advertisement

Excel Level 3


Excel 2016 Level 3 builds on the concepts and skills of the Level 1 and Level 2 to provide advanced tools for solving real-world problems. Topics include working with multiple worksheets and workbooks, using Lookup functions, sharing and protecting workbooks, automating workbook functionality, creating sparklines and mapping data, and forecasting data.Topics in this course map to the Microsoft Office Specialist exam for Excel
2016. Office 2016/365.

Includes: live in-person instructor-led interactive training, printed manual plus online manual, quick-reference card, access to online training videos, online self-assessment, ongoing support, 6-month free retake, and a certificate of completion with 7.2 CPE credits.

Topics:

-
Consolidate data
-
Links, external references, 3-D references
-
IF, SUMIF, SUMIFS, VLOOKUP, MATCH, INDEX functions
-
NOW, TODAY, MONTH, YEAR functions
-
CONCATENATE, TRIM, UPPER, LOWER, PROPER functions
-
PV, MIN, MAX, COUNT, COUNTA, COUNTBLANK functions
-
Watch and evaluate formulas
-
Data validation
-
Create macros
-
Map data
-
Data tables, goal seek, forecasting, scenarios

Instructor: [Rosemary McCracken]( http://www.cctrva.com/team-view/rosemary-mccracken/)



You may also like the following events from CCT - Commonwealth Computer Training:

Map CCT - Commonwealth Computer Training, 7275 Glen Forest Dr, Ste 200, Richmond, Virginia 23226, Richmond, United States
Report a problem

Are you going to this event?

Advertisement

More Events in Richmond

Explore More Events in Richmond