-
.png)
Excel - Intermediate Level
Date and Time
Wednesday Mar 29, 2023
9:30 AM - 5:00 PM ISTLocation
Live Instructor-Led Webinar
Fees/Admission
Chamber Members 195 euro
Non-Members 225 euro
*Fingal Chamber members must log in to be eligible for member-only rates and options.
For details on how to access the Member Information Centre, please click here.Website
.png)
Description
Course Information
1-Day Intermediate Excel CourseOverviewThe Intermediate Excel 2019/365 course builds on the techniques and concepts presented in the Excel 2019/365 Introduction course. It focuses on how to create and use advanced formulas, analyze data, organize worksheet data with tables and enhance workbooks.Course PrerequisitesThis Intermediate course assumes the user has completed or has an understanding of the topics covered in the Excel 2019/365 Introduction course, including:Using basic formulas and functions in a worksheetEditing and formatting Excel dataPrinting and saving Excel filesObjectivesBy the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and basic PivotTables, working with tables and enhancing workbooks.Course ContentLesson 1: Creating Advanced FormulasApply Range NamesUse Specialised FunctionsLink to Data in Multiple WorkbooksLesson 2: Analysing Data with Logical and Lookup FunctionsUse Text FunctionsUse Logical FunctionsUse Lookup FunctionsUse Date FunctionsUse Financial FunctionsLesson 3: Organising Worksheet Data with TablesCreate and FormatTablesModify TablesUse Table ReferencesLesson 4: Analysing Data with PivotTablesCreate a Basic PivotTableLesson 5: Enhancing WorkbooksCustomise WorkbooksApply Condtional FormattingProtect FilesCourse PrerequisitesThis Intermediate course assumes the user has completed or has an understanding of the topics covered in the Excel 2019/365 Introduction course, including:Using basic formulas and functions in a worksheetEditing and formatting Excel dataPrinting and saving Excel files
.png&p[title]=Excel+-+Intermediate+Level){kind=link}