The advanced level of MS Excel training gives students mastery and insight when it comes to spreadsheet usage, allowing graduates to become key assets in any office environment. With a flexible approach to undertaking studies, via our center or at home, students can choose one location or a combination of both to complement their learning. All training is provided online with a user-friendly system that tracks student progress and provides suggestions for performing assignments and tasks. This program consists of seven modules with fifty-six topics designed for ease of use, and it also comes with a one-year license- allowing for ease of reference for months to come. Accreditation from the CPD is included in the admission fee, with the option of certification through Certiport Global for an additional cost. Objective: By receiving MS Excel advanced certification, accredited by the CPD, students gain mastery in Excel and a competitive edge in career development. Overview Working with Pivot Tables and Conditionals Introduction to pivot tables, charts and conditionals; Pivot table creation and modification; Managing pivot charts; Working with conditional functions; Condition nesting; NOT, OR and AND conditionals; Workbooks and Importing Manage data across a wide array of formats; Formulas and consolidation; Double entry; Properties of workbooks; Data import management; Digital signatures; Advanced Functions Familiarization with advanced Excel working tools; Creating hyperlinks; File conversion; Themes, dates and templates; Text functions; Error detection; Course Length Get in touch by telephone or email for course information. While access to all course materials will be available for one year, students are advised to take their CPD accredited certification within three months. Course Requirements MS Excel Intermediate Certification is recommended before taking the Advanced training.. Results and Benefits MS Excel Advanced certificate accredited by the CPD; Optional Certiport examinations available (not included in entry package); Flexible and remote study; Increased desirability to potential employers; Competence and confidence with MS Excel; Increased processing speed with MS Excel; Demonstrable familiarity with the software;

Register for Course

Don't See your Course?

Create a free course listing on Tech.London

Submit a Course


Get London tech news, jobs, and a preview of upcoming events straight to your inbox each week for free.