Excel 2016 - Part 1

Excel 2016 — Part 1

COURSE SCHED­ULE

Excel 2016 — Part 1

Length Days: 1

Length Hours: 8


PREREQUISITES

To ensure suc­cess, stu­dents will need to be famil­iar with using per­sonal com­put­ers and should have expe­ri­ence using a key­board and mouse. Stu­dents should also be com­fort­able work­ing in the Win­dows® 10 envi­ron­ment and be able to use Win­dows 10 to man­age infor­ma­tion on their com­put­ers. Spe­cific tasks the stu­dents should be able to per­form include: open­ing and clos­ing appli­ca­tions, nav­i­gat­ing basic file struc­tures, and man­ag­ing files and folders.

TAR­GET AUDIENCE

This course is intended for stu­dents who wish to gain the foun­da­tional under­stand­ing of Microsoft Office Excel 2016 that is nec­es­sary to cre­ate and work with elec­tronic spreadsheets.


COURSE OBJEC­TIVES

Upon suc­cess­ful com­ple­tion of this course, you will be able to cre­ate and develop Excel work­sheets and work­books in order to work with and ana­lyze the data that is crit­i­cal to the suc­cess of your orga­ni­za­tion. You will: Get started with Microsoft Office Excel 2016. Per­form cal­cu­la­tions. Mod­ify a work­sheet. For­mat a work­sheet. Print work­books. Man­age workbooks.


COURSE OUT­LINE

1GET­TING STARTED WITH MICROSOFT OFFICE EXCEL 2016

Topic A: Nav­i­gate the Excel User Inter­face Topic B: Use Excel Com­mands Topic C: Cre­ate and Save a Basic Work­book Topic D: Enter Cell Data Topic E: Use Excel Help

2PER­FORM­ING CALCULATIONS

Topic A: Cre­ate Work­sheet For­mu­las Topic B: Insert Func­tions Topic C: Reuse For­mu­las and Functions

3MOD­I­FY­ING A WORKSHEET

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows Topic B: Search for and Replace Data Topic C: Use Proof­ing and Research Tools

4FOR­MAT­TING A WORKSHEET

Topic A: Apply Text For­mats Topic B: Apply Num­ber For­mats Topic C: Align Cell Con­tents Topic D: Apply Styles and Themes Topic E: Apply Basic Con­di­tional For­mat­ting Topic F: Cre­ate and Use Templates

5PRINT­ING WORKBOOKS

Topic A: Pre­view and Print a Work­book Topic B: Set Up the Page Lay­out Topic C: Con­fig­ure Head­ers and Footers

6MAN­AG­ING WORKBOOKS

Topic A: Man­age Work­sheets Topic B: Man­age Work­book and Work­sheet Views Topic C: Man­age Work­book Properties


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 aims to pro­vide stu­dents with a foun­da­tion for Excel knowl­edge and skills, which they can build upon to even­tu­ally become an expert in data manipulation.

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

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