Functions and Conditional Formatting in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum value How the If, VLOOKUP and SUBTOTAL functions work in a sale report
Loading view.
Technical Skills Workshops
- Events
- Technical Skills Workshops
Charts in Microsoft Excel
OnlineHow to insert a chartChart and layout style Switching rows and columns How to change the chart type
Data-Cleaning in Microsoft Excel
OnlineHow to insert and delete cells Modifying Columns and Rows Formatting Cells Data Filtering and Validation
Transforming Data in Microsoft Excel
OnlineIntro to Formulas Learn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
PivotTables in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum value How the If, VLOOKUP and SUBTOTAL functions work in a sale report
Power Pivot in Microsoft Excel
OnlineHow to insert a chart Chart and layout style Switching rows and columns How to change the chart type
Google Sheets Workshop
OnlineGetting StartedBuilding your Spreadsheet Sort, Filter and Data Validation Formulas and Functions Chart and Pivotable
Google Docs Workshop
OnlineHow to create a new DocumentText Basics Tables and Bulleted lists Formatting Pictures
Employment Technology Webinar & Job Application Email
OnlineHow to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Getting Started with Microsoft Word
OnlineHow to create a new Document Tables & Bulleted lists Adding Pictures & Shapes
Mailings Option in Microsoft Word
OnlineHow to combine excel and word to create labels, letters & envelopes