The Outlook & Excel M365 is a combined workshop.
Facilitated by Zoran Jokic, Partner & Founder of Training First Consulting. To learn more about Zoran click here.
Begins Monday, April 26th, 6:00 pm – 9:00 pm, 12 consecutive weeks on Mondays. This will be an online workshop and a login code will be provided once participants are registered.
*Open to Lebanese Chamber members and their employees at no cost. Each course is valued at approx. $4,000 per person. Not a member but want to participate? Join as a member here.
Course Agenda for Outlook
Filtering and Searching – Filtering emails, Searching for emails using And, Or and Not operators, Creating a search folder
Managing Email using Rules – Creating a new rule, Using And, Or and Not operators in rules, Deleting a rule, Using the Rules Wizard
Archiving Email – Archiving individual messages, Archiving multiple messages, Using Auto Archive, Controlling Auto Archive settings, Specifying or changing the Auto Archive folder
Working with Calendars – Creating additional calendars, viewing calendars side-by-side or overlaid, Printing options for the calendars, Adding a second time zone
Sharing – Allowing sharing of mail and calendars, setting permissions, setting permissions for specific access, viewing folders and tasks for which you have been granted permission
Mastering Key Excel Concepts – Creating formulas using absolute, relative and mixed referencing, Naming cells and cell ranges, Using names in formulas, Editing named cells and ranges using the Name Manager
Tips and Techniques for Entering Core Excel Functions – Using different strategies to quickly enter core Excel functions including SUM, AVERAGE, MIN and MAX, counting cells containing numeric or text values, and more
Using IF and VLOOKUP Functions to Display Conditional Results – Using the powerful IF function to output conditional results, creating nested IF statements, creating formulas using SUMIF and COUNTIF, Using the VLOOKUP function to look up data vertically in a list or database, Dealing with VLOOKUP errors
Applying Conditional Formatting – Highlighting cells using built-in conditional formats, Clearing conditional formatting
Protecting and Formatting Worksheets and Workbooks – Protecting worksheets and workbooks, using cell styles and themes to speed up formatting in multiple worksheets
Linking Worksheets and Workbooks – Using link cells in formulas to link worksheets and workbooks, Managing, and updating links between workbooks, Importing linked and unlinked Excel data into Microsoft Word
Summarizing Cells or Ranges from Multiple Sheets – Understanding 3D references, inserting formulas that extract totals from multiple sheets using 3D references, Considerations when inserting, moving and deleting sheets
Manipulating and Extracting List or Database Data – Identifying the parts of an Excel list or database, Best practices for setting up lists or databases correctly in Excel, inserting records on a worksheet or adding records using a data form, Sorting records using the Sort feature with multiple sort keys
Converting Data Sets to Tables – Why you should be using Excel tables, converting lists to tables in 3 different, ways, Creating formulas in tables
Creating Drop-Down Lists Using Validations – Applying validations, creating drop-down lists to make data entry easier and more accurate
Visualizing Data using Charts and Sparklines – Inserting charts on a spreadsheet or on a new Excel sheet, applying chart formats to improve the appearance of your charts, Changing the chart type
Summarizing Data using Pivot Tables – Creating pivot tables to summarize Excel list or database data, Rearranging fields in a pivot table, applying formatting to pivot tables and fields, filtering a pivot table, Creating a pivot chart