Apply trace dependents, precedents and trace errors options.Analyze data using the Data Analysis Tools: Anova, Solver and Histograms.Analyze data using the What-If analysis functions: Goal Seek, Scenario Manager, Data Tables.Create and summarize data with Pivot Tables and Pivot Charts and use of slicer.Analyze data using the Subtotalling tool.Apply protection to workbooks, worksheets and ranges.Demonstrate the use of sorting, filtering and editing lists.Demonstrate creating, modifying and formatting charts.Apply Relative, Absolute and Mixed cell references.Demonstrate formatting and improving the appearance of a worksheet.Demonstrate entering, editing, saving and modifying data in a worksheet.Create, save, open, close and print workbooks.Identify the MS Excel user interface components.Upon successful completion of this course, the student will be able to:
Please check back next term, subscribe to receive email updates orĬontact us with your comments or questions. Prerequisite(s)ĬOMP 1002 or equivalent knowledge of MS Windows and File Management plus Grade 12 Math or Business Math or equivalent. By the end of this course, successful participants will be expert end users of MS Excel. This course is required in the Applied Data Analytics Certificate (ADAC) and the Applied Computer Applications (ACA) Associate Certificate from BCIT Computing Part-time Studies. Topics include: creating, editing, formatting and saving a worksheet, sorting, filtering, slicers, applying formulae, functions, importing and exporting data, and consolidating data in multiple worksheets. Students learn to use MS Excel Ribbon interface with contextual tabs, Quick Access Toolbar and how to make use of templates, styles, pivot tables, what if analysis tools and macros via lectures, lab exercises and assignments outside of class. This instructor lead, hands-on course focuses on best practices used to create meaningful workbooks and how to master the techniques and time saving shortcuts for the daily use of MS Excel.
Those with no prior spreadsheet experience will acquire expert level applied skills in the latest version of MS Excel. Microsoft Excel is a powerful tool that can be used to analyse, communicate and manage information. If you don't see what you want here contact us and we can provide private courses tailored to your business.You need to enable JavaScript in your browser to be able to fully use this page. M Training offers a full range of 5 Star Rated Microsoft 365 courses from Intro to Excel to Power BI. Would highly recommend it to new managers." The trainer's knowledge was excellent and with it being a 1 day course the time spent on each topic area was just enough, the level of details was pitched just right.
0 kommentar(er)
