Using Excel data, students will generate and format charts and will also create pivot tables to summarize list or database data. Students will learn strategies to manage list or database data using filtering, sorting, subtotalling and validations. ![]() Links will be created and managed between worksheets, workbooks and other programs. During this instructor-led class, students will learn to enter common functions with a focus on Excel best practices and then move on to popular functions and tools including IF, SUMIF, COUNTIF, VLOOKUP, conditional formatting, linking, data management, pivot tables and basic macros. This Intermediate / Advanced Excel course is designed for users who want to move to the next level and focus on core competencies in Excel. VIEW MICROSOFT EXCEL: INTRODUCTION COURSE OUTLINE > Microsoft Excel: Intermediate / Advanced Students will learn best practices to print worksheets and workbooks, set up and filter data and create simple charts quickly and easily. Various strategies will be used to edit, format and manage worksheets and workbooks. Students will learn to enter and edit different types of data and to enter formulas using operators and functions. This instructor-led Excel course, designed for beginners, is the best course to learn core skills to work effectively with this popular spreadsheet program. Microsoft Excel Courses by Level Microsoft Excel: Introduction Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction Microsoft Excel: Introduction to Visualizing Data with Charts Microsoft Excel: Introduction to Power Pivot and Data Models Microsoft Excel: Introduction to Power Query to Get and Transform Data Microsoft Excel: New Features and Functions in Excel 365 Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools All of our Excel courses include a full course manual with tips, tricks and shortcuts as well as sample and exercise files. We offer over 12 days of Excel training and we are constantly adding new content. Find the best Excel course for your needs. Hands-on Excel training is offered at the introduction, intermediate and advanced levels for 2013, 2016, 2019, 2021 and 365 users. ![]() Our live instructor-led Microsoft Excel courses are held online in virtual classroom format or in-person in downtown Toronto, Ontario, Canada. ![]() The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.Find the Best Excel Course for Your Needs Instructor-led Classroom Courses in Toronto or Online Virtual Classroom Training Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. In signing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. If you take up a place on a College course, at the start of the course you will be asked to sign an enrolment form. Modern Slavery and Human Trafficking Statementĭistance Learning courses have flexible start dates and applications will be considered at all points of the year.įor non-Scottish residents – the College will confirm fees payable for your chosen course on booking and these may differ from the advertised fee.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |