Excel 2016 - Part 2

Excel 2016 — Part 2

COURSE SCHED­ULE

Excel 2016 — Part 2
Length Days: 1

Length Hours: 8


PRE­REQ­UI­SITES

To ensure suc­cess, stu­dents should have com­pleted Microsoft® Office Excel® 2016: Part 1 or have the equiv­a­lent knowl­edge and experience.

TAR­GET AUDIENCE

This course is designed for stu­dents who already have foun­da­tional knowl­edge and skills in Excel 2016 and who wish to begin tak­ing advan­tage of some of the higher-​level func­tion­al­ity in Excel to ana­lyze and present data.


COURSE OBJECTIVES

Upon suc­cess­ful com­ple­tion of this course, you will be able to lever­age the power of data analy­sis and pre­sen­ta­tion in order to make informed, intel­li­gent orga­ni­za­tional deci­sions. You will: Work with Func­tions Work with Lists Ana­lyze Data Visu­al­ize Data with Charts. Cre­ate advanced for­mu­las. Ana­lyze Data with Piv­ot­Ta­bles and PivotCharts.


COURSE OUT­LINE

1WORK­ING WITH FUNCTIONS

Topic A: Work with Ranges Topic B: Use Spe­cial­ized Func­tions Topic C: Work with Log­i­cal Func­tions Topic D: Work with Date & Time Func­tions Topic E: Work with Text Functions

2WORK­ING WITH LISTS

Topic A: Sort Data Topic B: Fil­ter Data Topic C: Query Data with Data­base Func­tions Topic D: Out­line and Subto­tal Data

3ANA­LYZ­ING DATA

Topic A: Cre­ate and Mod­ify Tables Topic B: Apply Inter­me­di­ate Con­di­tional For­mat­ting Topic C: Apply Advanced Con­di­tional Formatting

4VISU­AL­IZ­ING DATA WITH CHARTS

Topic A: Cre­ate Charts Topic B: Mod­ify and For­mat Charts Topic C: Use Advanced Chart Features

5ANA­LYZ­ING DATA WITH PIV­OT­TA­BLES AND PIVOTCHARTS

Topic A: Cre­ate a Piv­ot­Table Topic B: Ana­lyze Piv­ot­Table Data Topic C: Present Data with Piv­otCharts Topic D: Fil­ter Data by Using Time­lines and Slicers


Actual course out­line may vary depend­ing on offer­ing cen­ter. Con­tact your sales rep­re­sen­ta­tive for more information.

Short Descrip­tion

This course builds upon the knowl­edge pre­sented in the Microsoft® Office Excel® 2016: Part 1 course and helps start stu­dents down the road to cre­at­ing advanced work­books & work­sheets that can help deepen their understanding.

Con­tact Us

ITBC­group.…

25 Amhurst Road…

Lon­don , UK , E5 8HH

Cell: +07495497301

Maadi , Cairo, Egypt

Cell: 01001531899 | 01017080808

www​.itbcg​.net | info@​tbcg.​net

logo

إذا كان لديك رؤية مستقبلية، فاصنعها بنفسك