Add the Forecast Sheet function which can deal with a monthly pattern and give a forecast Using the IF Function (multiple IFs are possible) Using Named Ranges in formulas in MS Excel Training Topic B: Advanced Formula Construction Working with Built-in Toolbars in MS Excel Training Topic A: Customizing the Work Area Microsoft Excel – Training Level 3 Advanced SUBTOTAL function creates the formulas automatically Note the SUMIFS Excel function is a new function that can have up to 127 criteriaĮxcel training for formulas in Toronto & Mississauga Ontario SUMIF to sum by specified criteria or label Multiple-condition criteria (Advanced Filter) Training Topic F: Filtering data in Microsoft Excel Setting up Single-level sorting in MS Excel Using graphic objects to enhance worksheets and charts Training Topic D: Using graphic objects in Microsoft Excelįormatting graphic objects – Fill colour & line colour Training Topic B: Modifying charts in Microsoft ExcelĬhart types – Column, Bar, Line, Pie etc.Īdding and deleting chart items such as values & labels Microsoft Excel – Training Level 2 IntermediateĬreating charts in MS Excel (new chart types are available)Ĭomparing chart worksheets with embedded charts Setting up and using a multiple-sheet workbook Using the Print Preview command and & page breaks Using the Fill Series feature (to create a list Like Toronto, Mississauga, Oakville, Burlington, Hamilton etc.) Inserting rows and columns in MS Excel 2016, 2013, 20 Training Topic E: Moving and copying data Training Topic D: Formulas & Functions in Microsoft ExcelĬreating formulas (SUM, COUNT, MAX, AVERAGE, MIN etc)Ĭreating & working with Named Ranges (instead of A1:B45 it can be called PriceList) Navigation and movement techniques – shortcut keys (a time saver) Training Topic C: Entering data and navigating in a worksheetĮntering and correcting data in MS Excel worksheets Various number and date formats and text alignment optionsĬopying and pasting formats (Format Painter) Training Topic B: Formatting a worksheet in Microsoft Excel New Excel functions such as SUMIFS & COUNTIFSĮxcel 2016, 2013, 2010, 2003/2007 comparison of the programs The specifications of the electronic spreadsheet (sheets and how to copy them) Microsoft Excel – Training Level 1 – Fundamentals New in Excel 2013 and Excel 2016 is Flash Fill this fills in columns once you give it a few examples - so if you wanted to separate First and Last name type in a few and Flash Fill does the rest - it can learn as it works. If there is an Excel topic not listed please let us know and we can add it to the agenda (note there are thousands of formulas in Excel and they can be combined if needed)Īlso check MS Excel 2010 training course Toronto, Mississauga, Hamilton Ontario Please select the Microsoft Excel 2016, 2013, 2010, 2007 topics that interest you (the Excel topics can be from different levels)Ĭontact us or call (905) 271 1119 for more information about courses. Learn new features in Excel re formulas & data analysis and save time (for example E xcel CORREL functions shows you coefficient of correlation between 2 data sets) If people are already using Microsoft Excel we can make very rapid progress through many topics. We also customize onsite programs in the Toronto, Mississauga, Oakville, Hamilton, GTA Ontario areas. Listed below are some set topics in MS Excel 2016, 2013, 2010, 2007. MS Excel Training Toronto Mississauga, Hamilton, Ontario & Course Outlines With PowerPivot you can analyze millions of rows Pivot tables can analyze thousands of rows of data in minutes. You can work on your existing Excel formulas in the training, create formulas such as VLOOKUP & HLOOKUP to automate work and save you time and errors. Note that Excel 2016 is included with an Office 365 sub so you get the latest updates and new functions and new chart types straight away - this can save you valuable time. New time saving IFS function helps you input multiple IFs with a simple dialogue box Use the latest functions to save time - in Excel 2016 new functions added are MINIFS and MAXIFS (so you can can get the Max based on certain criteria) Also now with an Office 365 subscription you can install MS Excel on 5 computers (or other device) Our hands-on personal training approach with Microsoft certified, expert instructors. Get learning Excel the way you need! MS Excel Training Toronto Mississauga Hamilton We customize the Excel topics to your specific needs in your office or home - Why waste your time to sit through MS Excel formulas that you already know? Go to Excel Training at Action eBiz to suit your specific needs -work on your own files. Versions MS Excel 2016/2013/2010/2007 by ExceltrainingĪlso Office 365 Excel (which has new functions) Onsite customized training in Toronto, Mississauga, Oakville, Hamilton, GTA Excel Training to suit your specific needs
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |