Excel 2016 - Advanced
Adding the Developer Tab in Excel 2016. 1. Click on the File tab of the ribbon to open the file menu. 2. Click on Options in the menu to open the Excel
Excel 2016 Advanced - Quick Reference Guide
Then select the desired formatting options from the PivotTable. Options group and the PivotTable Styles group. PivotCharts. Create a PivotChart: Click any cell
Chapter 2 - Setting Excel Options
All of Microsoft Excel's settings are located in the Excel Options The Advanced settings control a wide range of options many of which will be familiar ...
Microsoft Office 2016 - Excel 2016 Niveau 3 (Avancé)
Microsoft® Office Excel® 2016 Niveau 3 (Avance) version d'Excel intègre de nouvelles fonctionnalités et options de ... Excel 2016 Level 3 (Advanced).
Excel advanced (2ed)
8 mai 2021 The goal is to improve the advanced skills in basic Excel users in order ... ECDL Advanced Spreadsheet Software (BCS ITQ L3) - Excel 2016.
Advanced Excel 2016 - Pivot Tables
Once you have the options as you want them click OK. Click Cancel to go back to the spreadsheet. 6. A new pane will open on the right side of the screen for
PolicyViz
2016/O365 so a quick tour through the basic graph layout options seems appropriate. in the Advanced Data Visualizations with Excel 2016 Hands-On.xlsx.
Excel 2016 Shortcuts
In Windows this can be found under Options > Advanced > Editing Options. 3. Disable Error Checking. Open Excel settings/preferences. Click off "background.
Manuel de ladministrateur - XProtect Advanced VMS 2016 R3
16 août 2007 XProtect Advanced VMS 2016 R3 - Manuel de l'administrateur. Table des matières ... Installer votre système - option Serveur unique .
Excel advanced (2ed)
The course is aimed to analyze the main advanced features of Excel including ECDL Advanced Spreadsheet Software (BCS ITQ L3) - Excel 2016 version (ISBN ...
Excel advanced (2ed)
Lecturer: Elmi Giovetti
Language
English
Course description and objectives
The course
is aimed to analyze the main advanced features of Excel, including complex functions, what-if analysis, pivot tables and macros, with specific examples and exercises that can be immediately applied to one"s study and work. The goal is to improve the advanced skills in basic Excel users, in order to give them the tools for an effective and qualified approach to both academic and professional activities. Attention: The contents of this course largely follow what is covered in the curricular courses of Computer Science , Computer Skills and Computer Skills for Economics. The course is also valuable as preparation for the ECDL AdvancedSpreadsheet certification.
At the end of the course participants will be able to:Effectively organize data into a spreadsheet
Analyze data using complex functions and tools
Manage external data into Excel
Manage Excel charts in an advanced manner
Apply advanced formatting to the worksheet
Audience
The course is open to all Bocconi students. In particular, it is targeted at: Undergraduate students who have successfully passed Computer science, Computer skills orComputer skills for economics exam, and
who aim to review and improve their skills and get the ECDL AdvancedSpreadsheet (Excel) certification
Undergraduate students who have passed with some difficulty Computer science, Computer skills or Computer skills for economics exam, and who want to become more nimble using Excel"s advanced features Graduate students who have not attended their undergraduate studies at Bocconi and thus have not taken Computer science, Computer skills or Computer skills for economics exam unibocconi.eu All those who need to manage and process data in a professional manner for their academic or professional activitiesPrerequisites
To have achieved the ECDL
standard certification (ECDL Core or New ECDL) or have equivalent skills. In particular, it is required to know:How to enter data in Excel
How to manage worksheets
How to build simple functions
How to create charts
How to format data
Duration
20 hours
Teaching mode
The course will be held in distance learning mode. It will be possible to follow the live streaming (Live Session) of each lesson accessing through Blackboard to the corresponding virtual roomCalendar
Lecture Date Time
1 Wed 14/04/2021 18.40 - 20.10
2 Sat 17/04/2021 09.30 - 11.00
3 Sat 17/04/2021 11.20 - 12.50
4 Wed 21/04/2021 18.40 - 20.10
5 Sat 24/04/2021 09.30 - 11.00
6 Sat 24/04/2021 11.20 - 12.50
7 Wed 28/04/2021 18.40 - 20.10
8 Wed 05/05/2021 18.40 - 20.10
unibocconi.eu9 Sat 08/05/2021 09.30 - 11.00
10 Sat 08/05/2021 11.20 - 12.50
Syllabus of the course
Lecture Topics
Book and Syllabus
reference s1 Introducing data management with
ExcelRevision of some basic elements of
Excel Basic formulas and functions (percentage calculation, SUM, AVERAGE, MIN, MAX)Correct use of absolute and relative references
Basic conditional formatting
Exercises
Book Sections:
1, 2, 7, 14
Syllabus 3.0
categories: 1 - 22 Conditional data processing
Logical values and tests
IF function
Managing multiple conditions
Logic functions (AND, OR) and nested
IFsAdvanced conditional formatting with formulas
Exercises
Book Sections:
2, 7, 14
Syllabus 3.0
categories: 1 - 23 Organizing data
Charts creation and formatting
Advanced charts (mixed on two axis)
Worksheets management
Format as Table
Sorting and filtering tools
Subtotal
Exercises
Book Sections:
2, 8, 11, 12, 15
Syllabus 3.0
categories: 1 - 3 - 4 unibocconi.euLecture Topics
Book and Syllabus
reference s4 Advanced functions
Mathematical functions
Statistical functions
Database functions
Working with references on different
worksheetsManaging custom lists
Exercises
Book Sections:
7, 12, 14
Syllabus 3.0
categories: 2 - 45 Analyzing data and customizing formats
Analyze data with Pivot tables
Managing Pivot tables options and
calculationsDate and time format and related functions
Create custom number formats
Exercises
Book Sections:
7, 13, 14
Syllabus 3.0
categories: 2 - 46 Creating simple tools with Excel
Text functions
Lookup and reference functions
Data validation
Security and protection options
Exercises
Book Sections:
3, 14 , 18Syllabus 3.0
categories: 2 - 5 - 77 What-if analysis
Financial functions
Create and manage Scenarios and Summaries
Define and use cells names
Other What-if analysis tools
Exercises
Book Sections:
5, 9, 14
, 16Syllabus 3.0
categories: 2 - 4 - 68 Data gathering and sharing
Managing external data
Advanced copy and paste options
Auditing tools
Reviewing tools
Creating and managing Templates
Exercises
Book Sections:
4, 6, 10, 18, 19
Syllabus 3.0
categories: 5 - 6 - 7 unibocconi.euLecture Topics
Book and Syllabus
reference s9 Automations in Excel
Introducing Excel macros
Macro recording
VBA basic editing of recorded macros
Macro triggering
Ribbon customization
Exercises
Book Sections:
1, 2, 17Syllabus 3.0
categories: 610 General review and final test
Suggested bibliography
ECDL Advanced Spreadsheet Software (BCS ITQ L3) - Excel 2016 version (ISBN: 9780857411990), CiA Training Ltd, 2016 M. Ballerini, A. Clerici, M. Debernardi, D. Del Corno, M. De Pra, ExcelWorkbook (
third edition , Egea, 2021Software
Microsoft Office Excel
2019/365
Available seats
This activity is limited to 60 participants. Registrations cannot be carried out once this number has been reached or after closing of the registration period. unibocconi.euSpreadsheet paths
This course can be intended as part of a wider path:quotesdbs_dbs14.pdfusesText_20[PDF] excel erp francais methode
[PDF] excel etudiant
[PDF] exchange rate pdf
[PDF] excursii 2015 paralela 45
[PDF] exemplaire d'un contrat de travail
[PDF] exemplaire de demande d'emploi pdf
[PDF] exemplaire de demande d'emploi word
[PDF] exemplaire de lettre de motivation pour une demande d'emploi
[PDF] exemplaire de lettre de motivation pour une demande d'emploi pdf
[PDF] exemple appréciation bulletin scolaire
[PDF] exemple appréciation copie
[PDF] exemple appreciation prof
[PDF] exemple baze de date access
[PDF] exemple bibliographie