Microsoft Excel 2016 Basics
January 21st – 22nd, 2020 8:00 AM – 12:00 PM, TW
May 13th – 14th, 2020 8:00 AM – 12:00 PM WTh
Explore how to use the powerful tools in Excel 2016 for organizing, visualizing and calculating your data. You will navigate the workspace, enter/edit information, discover simple formulas and functions and insert charts to make basic spreadsheets.
50 Useful Excel Functions & Formulas
January 28th-29th, 2020 1:00 PM – 4:00 PM, TW
Become more effective and efficient in Microsoft Excel 2016! You will discover simple but powerful functions and formulas related to text, statistics, math, dates, information and logic to make you more productive in your work.
Microsoft Excel 2016 Intermediate
February 12th-13th, 2020 8:00 AM – 12:00 PM, W Th
Increase your Excel productivity skills by discovering how to manage multiple workbooks, use named ranges, work with Tables, and create consolidation data. You will use conditional formatting, graphics and determine how to easily collaborate with others. Finally, you will discover key functions and formulas to maximize your efficiency in Excel. Participants must have basic skills with the Microsoft Excel application. Attending the Excel 2016 Basics class is highly recommended.
Excel 2016 Tables & Data Analysis
March 3rd, 2020 8:00 AM – 12:00 PM, T
Discover the power of using Tables in Microsoft Excel 2016. With easy access to filtering, sorting, aggregate functions and more, Tables provide an effective method for displaying and working with your data. Explore the tools available to analyze your data to make better business decisions.
Microsoft Excel 2016 Advanced
March 23rd, 2020 1:00 PM – 5:00 PM, MW
Expand your Excel skills by discovering logical and lookup functions, explore advanced formulas and functions, use importing and exporting, and pivot tables and charts. You will work with sparklines, Quick Analysis tools, plus What-if analysis tools. Finally, you will record and run macros. Participants should have intermediate skills prior to enrollment. Attending Excel 2016 Basics and Intermediate classes are highly recommended.
Excel 2016 Pivot Tables & Dashboards
March 31st – April 2nd, 2020 8:00 AM – 12:00 PM
Discover how Pivot Tables & Charts can provide an easy way to slice and dice your data for quick answers. You will build pivot tables and charts, add slicers, add calculations, create charts for a dashboard and much more!
We would like to make you aware of our school policy regarding tuition. All deposits paid for classes are applied toward your tuition and are non‑refundable unless the class is cancelled by Meridian Technology Center. If you are unable to attend, you will still be charged the deposit or the full cost of the class if it is less than $50. The balance of your tuition (if applicable) is due prior to the first class meeting and is non‑refundable.