BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20210713T200000Z
DTEND:20210713T110000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Intermediate Excel
DESCRIPTION:Suitable for anyone with a working knowledge of Microsoft Office Excel. Learn how to use more advanced tools\, shortcuts and applications to develop your performance and support your business.\n\n\n\nCourse will be held on Tues 13th July & Mon 19th July (both (9:00am-12:00pm)\n\nAttendance on both dates is required to complete the course. \n\n\n\nKey content:\n\n\n Excel 2003 v 2007 v 2010 (and later)\n Quick Access Toolbar\n Named Ranges\n Data Validation (using Named Ranges)\n Absolute Values ('Locking' the cell reference)\n Data Transfer between worksheets and\n spreadsheets\n Conditional Formatting\n Formula Auditing\n IF Statements and Formulas\n VLOOKUPS\n Inserting Charts\n Sub-totals\n Pivot Tables\n Paste Options\n Date and Time Functions\n Placing Existing Data into a 'table'\n Themes\n Adapting the view of the Spreadsheet\n Inserting 'screenshots'\n SmartArt Graphics\n What-If Analysis\n Macros\n\n\n\nJoining instructions:\n\nJoining instructions and invoice for payment will be sent directly from Doncaster College. The online training session will be delivered via Microsoft Teams. \n\n\n\nOther information:\n\nThis is a 1 day course delivered as 2 x half day sessions (13th & 19th July 2021). You will automatically be booked onto sessions 2 after booking the first session.\n\n\n\nMembership at the Chamber enables you to attend discounted training sessions as well a whole host of other services. For more details or to speak to one of the team about membership please click here.
X-ALT-DESC;FMTTYPE=text/html:Suitable for anyone with a working knowledge of Microsoft Office Excel. Learn how to use more advanced tools\, shortcuts and applications to develop your performance and support your business.
\n
\nCourse will be held on Tues 13th July &\; Mon 19th July (both (9:00am-12:00pm)
\nAttendance on both dates is required to complete the course. \;
\n
\nKey content:\n\n\n - Excel 2003 v 2007 v 2010 (and later)
\n - Quick Access Toolbar
\n - Named Ranges
\n - Data Validation (using Named Ranges)
\n - Absolute Values (&lsquo\;Locking&rsquo\; the cell reference)
\n - Data Transfer between worksheets and
\n - spreadsheets
\n - Conditional Formatting
\n - Formula Auditing
\n - IF Statements and Formulas
\n - VLOOKUPS
\n - Inserting Charts
\n - Sub-totals
\n - Pivot Tables
\n - Paste Options
\n - Date and Time Functions
\n - Placing Existing Data into a &lsquo\;table&rsquo\;
\n - Themes
\n - Adapting the view of the Spreadsheet
\n - Inserting &lsquo\;screenshots&rsquo\;
\n - SmartArt Graphics
\n - What-If Analysis
\n - Macros
\n
\n
\nJoining instructions:
\nJoining instructions and invoice for payment will be sent directly from Doncaster College. The online training session will be delivered via Microsoft Teams. \;
\n
\nOther information:
\nThis is a 1 day course delivered as 2 x half day sessions (13th &\; 19th July 2021). \;You will automatically be booked onto sessions 2 after booking the first session.
\n
\nMembership at the Chamber enables you to attend discounted training sessions as well a whole host of other services. For more details or to speak to one of the team about membership please \;click here.
LOCATION:Online
UID:e.3320.2982
SEQUENCE:3
DTSTAMP:20260429T194809Z
URL:https://business.doncaster-chamber.co.uk/events/details/intermediate-excel-2982
END:VEVENT
END:VCALENDAR