Microsoft 365 – INTERMEDIATE EXCEL
Typology: Online Course
Duration: 3 ½ hours
LanguagesItalian
OBJECTIVES:
30 Video to explore topics such as auto-sum functions, date and time calculations, sorting and filtering lists, handling text, and using logical and search functions. Gain advanced skills to manipulate data, obtain precise results, and optimize efficiency in your daily work with Excel.
Mini-video training pills that explain step by step the various features and use cases with audio, video and animations.
CONTENTS
Use the autosum functions:
- How to calculate the sum and the average
- How to count cells
- How to get the maximum value and minimum value
- How to use autosum functions with conditions
Making calculations with dates and times:
- How to calculate the time between two dates
- How to calculate the time between two times
- How to do calculations with dates, hours and minutes
Sort and filter lists:
- How to sort the lists
- How to sort by custom lists and options
- How to use the DATA SORT functions
- How to filter the lists
- How to filter by specifying complex criteria
- How to use the FILTER function
Manage text:
- How to extract parts of text
- How to divide the text of a series into separate columns
- How to merge and process text
Use logic functions:
- How to use the IF and PLUS functions
- How to use the And and O functions
- How to use the IFERROR and IFNOTDISP functions
Use the search and reference functions:
- How to use the VLOOKUP and HORIZ LOOK functions
- How to use the INDEX and COMPARE functions
- How to use the OFFSET function
Produced by: Piazza Copernico
Content edited by: Different
Teacher: Frank Iacovelli
COURSE CODE: OFFICE365 _ excel_intermediate
