Outlook & Excel M365

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 12th, 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

Importing and Exporting – Import and export rules, importing eml-files intoOutlook, importing multiple contacts from a vCard file, exporting multiple contacts, exporting to or importing from Excel
Customizing Outlook – Settings for junk mail, specifying preferred senders, Using, and customizing AutoCorrect, automating commands, Creating Quick Steps, Managing Quick Steps, Customizing the Ribbon and the Quick Access Toolbar, Creating and using custom contact groups, adding fields to a view, Creating a custom view
Course Agenda for Excel M365

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


Details

Date:

Price: Free