MSP Foundation & Practitioner Online (e-learning).MSP Foundation & Practitioner (classroom).PRINCE2 Agile Foundation and Practitioner Online (e-learning).PRINCE2 Agile Foundation and Practitioner (Classroom).PRINCE2 Practitioner Online (e-learning).PRINCE2 Foundation and Practitioner Online (e-learning).Introduction to Project Management with MS Project.Talent Management and Succession Planning.▪ Applying, expanding & collapsing an outline ▪ Copying visible data to a new worksheet ▪ Using the ‘Quick Analysis button” to add totals to a table ▪ Converting an Excel table back to a range ▪ Adding automatic totals to an Excel table ▪ Rules for creating tables and lists in Excel

▪ Using Text Functions (Upper, Lower, Proper, Trim, Left, Right and Concatenate) ▪ Use Text to columns to split a single column of data into multiple columns ▪ Creating codes to format numbers and dates ▪ Applying built-in data bars, colour scales and icons sets to numeric data ▪ Managing conditional formatting rules (editing, formatting and clearing) ▪ Applying a comparative conditional formatting rule ▪ Creating, displaying and deleting custom views ▪ Creating data sequences using ‘Flash Fill’ ▪ Copying values & formulas between worksheets ▪ Create sub totals and group & ungroup data ▪ Use criteria ranges to analyse data using the Advanced Filter ▪ Understand the concepts an Excel database and create and modify data tables ▪ Apply conditional formatting and creating custom format ▪ Copy and link information across multiple workbooks ▪ Copy formats and values across multiple worksheets ▪ Create formulas across multiple worksheets On completion of this course, delegates will be able to: They should be able to write formulas using multiplication, addition, subtraction, division and use the basic functions, sum, average, max, min and count. Students who wish to attend this course must have knowledge of Excel and feel comfortable with creating, formatting, and editing spreadsheets. This Microsoft Excel Intermediate course is aimed at people who want to expand their knowledge of Microsoft Excel to work with larger spreadsheets, create formulas across multiple worksheets and workbooks, manage tables of data, and use advanced formatting techniques.

Powerpoint 2013 quick analysis button