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:20200324T093000Z
DTEND:20200324T123000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:MS Excel Intermediate – ONLINE
DESCRIPTION:This online course is suitable for those with a busy schedule and is adaptable to the challenges of every lifestyle. Participants can attend the live course at the times outlined below and will have access to the recorded courses for 6 months after completion.\n\nA trainer will be on hand after each module to answer trainee questions and participants will have access to a dedicated trainer email for queries after the course is completed.\n\nIf you're unable to attend the live courses\, a recorded copy of the course will be provided to you also along with all relevant course files and documents!\n\nCourse Dates\n\n\n Module 1: 24th March 09:30am 11:00am\n Module 2: 24th March 11:30am 12:30pm\n Module 3: 25th March 09:30am 10:30am\n Module 4: 25th March 11:00am 12:00pm\n Module 5: 26th March 09:30am 10:30am\n\n\nSchedule Outline \n\nExcel 1: Microsoft Excel Essentials including Formatting & Tips and Tricks\n\n\n Review of Excel Basics concentrating on quick methods of performing commonly used commands/features including an overview of Speed Keys\n\n\nBasics\n\n\n Customising the 'Quick Access Toolbar'\n Navigating / Selecting / Data Entry / Editing\n Inserting / Deleting / Resizing columns / Hiding and Unhiding columns\n Cut / Copy / Paste and Drag and Drop\n Using the Clipboard Task Pane\n Filling / Flash Fill Basics / Creating a custom list.\n Formatting Font / Alignment / Number / Format Painter\n Orientation / Wrap Text\n Formatting as a table\n Preview and Print\n Conditional Formatting\n Overview of Shortcut Keys\n\n\nExcel 2: Working with Formulas and Functions\n\n\n Writing and understanding basic formulas\n Writing and understanding basic functions\n\n SUM / MIN / MAX / AVERAGE / COUNT / COUNTA / COUNTBLANK\n Copying Formulas Relative vs. Absolute cell addressing\n\n\nExcel 3: Basic Database Functionality and Manipulating Text\n\n\n Freezing Panes / Print Titles\n Sorting and Filtering a list\n Creating and Working with Excel Tables\n Changing Formatting\n Changing display options Total row etc.\n Working with Functions\n Using Slicers in Tables\n Creating calculated fields.\n \n \n \n\n\nExcel 4: Creating and Working with Charts\n\n\n \n \n \n \n \n\n \n \n \n \n \n Creating and editing various chart types\n Column / Bar / Line / Pie\n Moving / Resizing the chart\n Adding / Editing chart elements\n Chart title / Legend / Chart Style / Data Table / Data Labels\n Switch Row / Column\n Manually Formatting a chart\n Change overlap and gap width\n Creating a combined chart\n Displaying data on a secondary axis\n Adding an additional range to a chart once created\n\n\nExcel 5: Working with Multiple Worksheets and Data Consolidation\n\n\n Inserting new worksheets / Renaming\n Navigating between sheets Mouse / Keyboard / Navigation List\n Moving / Copying sheets\n Using 'Group Edit'\n Linking sheets using Formulae\n Breaking Links\n Other sheet options Tab colour / Hiding and Unhiding sheets.\n Data Consolidation By position and By Category / Label\n\n\nWho Should Attend? \n\nThis course is suitable for those who are currently using MS Excel regularly but may not have attended formal training recently or may never have attended the training.\n\nAll participants will be given access to a recording of the webinars by way of an email along with relevant files and user reference guides. The webinars will be available to participants for 6 months following the course.\n\nA Cork Chamber Skillnet / E-Bridge Certificate of Attendance will be awarded to each participant on completion of all courses.\n\n\n\nBOOK NOW
X-ALT-DESC;FMTTYPE=text/html:This online course is suitable for those with a busy schedule and is adaptable to the challenges of every lifestyle. Participants can attend the live course at the times outlined below and will have access to the recorded courses for 6 months after completion.
\n\nA trainer will be on hand after each module to answer trainee questions and participants will have access to a dedicated trainer email for queries after the course is completed.
\n\nIf you&rsquo\;re unable to attend the live courses\, a recorded copy of the course will be provided to you also along with all relevant course files and documents!
\n\nCourse Dates
\n\n\n - Module 1: \;24th March &ndash\; \;09:30am &ndash\; 11:00am
\n - Module 2: \;24th March &ndash\; 11:30am &ndash\; 12:30pm
\n - Module 3: \;25th March &ndash\; 09:30am &ndash\; 10:30am
\n - Module 4: \;25th March &ndash\; 11:00am &ndash\; 12:00pm
\n - Module 5: \;26th March &ndash\; 09:30am &ndash\; 10:30am
\n
\n\nSchedule Outline \; \;
\n\nExcel 1: Microsoft Excel Essentials including Formatting &\; Tips and Tricks
\n\n\n - Review of Excel Basics concentrating on quick methods of performing commonly used commands/features including an overview of Speed Keys
\n
\n\nBasics
\n\n\n - Customising the &lsquo\;Quick Access Toolbar&rsquo\;
\n - Navigating / Selecting / Data Entry / Editing
\n - Inserting / Deleting / Resizing columns / Hiding and Unhiding columns
\n - Cut / Copy / Paste and Drag and Drop
\n - Using the Clipboard Task Pane
\n - Filling / Flash Fill Basics / Creating a custom list.
\n - Formatting &ndash\; Font / Alignment / Number / Format Painter
\n - Orientation / Wrap Text
\n - Formatting as a table
\n - Preview and Print
\n - Conditional Formatting
\n - Overview of Shortcut Keys
\n
\n\nExcel 2: Working with Formulas and Functions
\n\n\n - Writing and understanding basic formulas
\n - Writing and understanding basic functions
\n SUM / MIN / MAX / AVERAGE / COUNT / COUNTA / COUNTBLANK \n - Copying Formulas &ndash\; Relative vs. Absolute cell addressing
\n
\n\nExcel 3: Basic Database Functionality and Manipulating Text
\n\n\n - Freezing Panes / Print Titles
\n - Sorting and Filtering a list
\n - Creating and Working with Excel Tables
\n - Changing Formatting
\n - Changing display options &ndash\; Total row etc.
\n - Working with Functions
\n - Using Slicers in Tables
\n - Creating calculated fields.\n \n
\n
\n\nExcel 4: Creating and Working with Charts
\n\n\n - \n \n
\n - Creating and editing various chart types
\n - Column / Bar / Line / Pie
\n - Moving / Resizing the chart
\n - Adding / Editing chart elements
\n - Chart title / Legend / Chart Style / Data Table / Data Labels
\n - Switch Row / Column
\n - Manually Formatting a chart
\n - Change overlap and gap width
\n - Creating a combined chart
\n - Displaying data on a secondary axis
\n - Adding an additional range to a chart once created
\n
\n\nExcel 5: Working with Multiple Worksheets and Data Consolidation
\n\n\n - Inserting new worksheets / Renaming
\n - Navigating between sheets &ndash\; Mouse / Keyboard / Navigation List
\n - Moving / Copying sheets
\n - Using &lsquo\;Group Edit&rsquo\;
\n - Linking sheets using Formulae
\n - Breaking Links
\n - Other sheet options &ndash\; Tab colour / Hiding and Unhiding sheets.
\n - Data Consolidation &ndash\; By position and By Category / Label
\n
\n\nWho Should Attend? \; \;
\n\nThis course is suitable for those who are currently using MS Excel regularly but may not have attended formal training recently or may never have attended the training.
\n\nAll participants will be given access to a recording of the webinars by way of an email along with relevant files and user reference guides. The webinars will be available to participants for 6 months following the course.
\n\nA Cork Chamber Skillnet / E-Bridge Certificate of Attendance will be awarded to each participant on completion of all courses.
\n
\nBOOK NOW
\n
LOCATION:Online
UID:e.2489.22004
SEQUENCE:3
DTSTAMP:20260428T005458Z
URL:http://corkchamber.chambermaster.com/events/details/ms-excel-intermediate-online-22004
END:VEVENT
END:VCALENDAR