Microsoft 365 – ADVANCED EXCEL
Typology: Online Course
Duration: 7 hours
LanguagesItalian
OBJECTIVES:
55 Video to gain advanced Excel skills for data analysis, complex formulas, pivot tables, task automation and more, optimizing productivity and improving business efficiency.
Mini-video training pills that explain step by step the various features and use cases with audio, video and animations.
CONTENTS
Using financial functions:
- How to calculate the installment and rate of a loan
- How to calculate the depreciation of an asset
- How to make an amortization plan
Create and edit charts:
- How to insert and edit a chart
- How to insert a histogram
- How to insert a line chart
- How to insert a pie chart
- How to create a chart with different types of data
- How to insert scatter and bubble charts
- How to insert a hierarchical chart
- How to insert waterfall, funnel and radar charts
- How to insert map and 3D charts
- How to insert sparklines
Analyze the data:
- How to create an outline and view subtotals
- How to handle duplicate rows
- How to use the UNIQUE function
- How to create a summary of data from sheets and workbooks
- How to make a formula give a certain result
- How to analyze the effects of one or two variables on a formula
- How to analyze groups of values with scenarios
- How to create a forecast sheet
- How to import data
Create tables and pivot tables:
- How to insert an Excel table
- How to create a pivot table
- How to filter and sort data in a pivot table
- How to group data in a pivot table
- How to create a pivot chart
- Exercise 1-1
- Exercise 1-2
- Exercise 1-3
- Exercise 1-4
- Exercise 2-1
- Exercise 2-2
- Exercise 2-3
Create and assign macros:
- How to create a macro
- How to assign a macro to a custom command
- How to insert buttons and other controls on worksheets
Check and protect your data:
- How to allow you to enter only certain types of data in cells
- How to protect sheets and folders even with a password
- How to protect folders locally and in the cloud
Further Reading:
- Introduction to Macros
- Security – Scenario Presentation and Macro Recording
- Running a Macro
- Saving Macros to Personal Macro Folder
- Management of a saved Macro
- Scenario presentation
- Configuration of the Module with Controls
- End of Controls Configuration + Function If
- Macro for saving data
Exercises:
- Scenario presentation
- Data Import and Table Formatting
- Data Model and Pivot Table setup
- Setting Data in the Pivot
- Pivot Table Formatting and Properties
- Filters in the PivotTable
Produced by: Piazza Copernico
Content edited by: Different
Teacher: Frank Iacovelli
COURSE CODE: OFFICE365 _ excel_advanced
