Master Microsoft Excel Macros and VBA in 6 Simple Projects Microsoft Excel 103 - Advanced Level Excel Microsoft Excel 102 - Intermediate Level Excel Microsoft Excel 101 - An Introduction to Excel This function is particularly useful for worksheets that show financial figures (black = positive, red = negative), test results (results change color based on their value), or any time you want to highlight data that falls within a certain value.This Microsoft Excel course combines 4 different courses. You can have data formatted based on conditions that you specify.Using the Conditional Formatting function.Repeating headings at the top of each printout page.Understanding and using ABSOLUTE cell addresses.Understanding BEDMAS (Proper Order of Operations).– Using the Fill Handle to quick-copy data and formulas – How to create your own custom fill lists (for your most often-used column and row headings) – How to use and manipulate the pre-programmed lists (days of the week months of the year) The FILL HANDLE performs two tasks, depending on the contents of the original cell: it COPIES the contents of the cell (ie, an equation or text) or COMPLETES A SEQUENCE (ie, days of the week months of the year).The FILE tab – what’s on it how to use it.How to customize it for faster, more efficient use.The skills that you learn in this course can also be used with Excel 2010 and Excel 2013.Ĭlick here to see if you have the skills to bypass Level 1 (CORE) What we cover: ![]() We also offer this course on-site, anywhere in Ontario – including the Greater Toronto Area (GTA). After taking our 1-day Excel 2016 training course you will be able to create workable spreadsheets that convey concise, up-to-the-minute data and look good doing it. 1-day Microsoft Excel 2016 – Level 1 (CORE) training course
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |