BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//hacksw/handcal//NONSGML v1.0//EN
BEGIN:VEVENT
UID:91ada9ea7c3ed7e9c068b08e9c18f2d1https://www.prioritymanagement.com.au
DTSTAMP:20240328T192833
DTSTART:TZID=20210414T093000
DTEND:TZID=20210415T123000
SUMMARY:Microsoft Excel - Intermediate (Virtual)
DESCRIPTION:[vc_row][vc_column width="1/1"][vc_column_text]
Excel is a spreadsheet application packaged with the Microsoft Office suite. It is a very powerful and flexible tool for organising and analysing data. Excel’s functionality and popularity have made it an essential component on computers in countless organisations, businesses, and other institutions throughout the world.
Excel is comprehensive enough to meet the needs of beginners and experienced users. With Excel you can do a wide range of tasks, from building basic spread sheets, to performing advanced data analysis. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want.
Because of its layout and widespread availability, it is often used as a tool to create and maintain a list. More seasoned users use it to store database records, create charts or graphs. A lot of organisations use Excel to manage their budgets, business planning, customer records, business intelligence, analysis of sales data, customer data, performance dashboard, etc.
Outcomes
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Upon completion of this course, students should be able to use advanced techniques to manage, manipulate and analyse complete data.
[/vc_column_text][vc_tabs][vc_tab title="Units" tab_id="1578020048-1-744290-96a92dde-9368"][vc_column_text]BRIEF REVISION OF EXCEL FOUNDATIONS
• Basic formulae
• Conditional Formatting
• Hiding & Displaying
CHARTS
• Secondary Axis
• Chart Tools
FORMULAS & FUNCTIONS
• Creating/copying formulas
• Relative/Absolute cell referencing
• Using Insert Function button
• Using nested functions
• Using TODAY /DAY/MONTH/YEAR/NOW
• Using SUMIF/RANDBETWEEN
• Using COUNT/MAX/MIN/AVERAGE
• Using CONCATENATE/TRIM
• Using VLOOKUP
• Using IF
MANIPULATING DATA
• Inserting/Deleting rows & columns
• Resizing rows & columns
• Freeze panes
• Inserting Comments
• Printing comments
• Using the Series function
• Creating Custom Lists
• Creating a chart with a secondary axis
NAMED RANGES
• Naming a range or cell
• Rules for naming cells and ranges
• Named ranges within formula
• Creating named ranges automatically based
on cell values
• Deleting named cells/ranges
• Filters & Lists
DATABASE & LIST MANAGEMENT
• Sorting data by multiple columns
• Creating/removing Subtotals
• Using Auto-filter
• Using Advanced filter[/vc_column_text][/vc_tab][vc_tab title="Audience" tab_id="1578020048-2-494290-96a92dde-9368"][vc_column_text]Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.[/vc_column_text][/vc_tab][vc_tab title="Format" tab_id="1578020247795-2-84290-96a92dde-9368"][vc_column_text]
- 1-day workshop or customise a program to suit your organisation’s specific needs.
Company specific courses are available for organisations that have a group of employees who need training. These closed courses are ideal where tailoring of the standard course content is required. They typically provide cost benefits, particularly where 3 or more workshops are scheduled.[/vc_column_text][/vc_tab][vc_tab title="What's Included" tab_id="1578020281851-3-54290-96a92dde-9368"][vc_column_text]
- Comprehensive Learning Guide
[/vc_column_text][/vc_tab][/vc_tabs][/vc_column][/vc_row]
END:VEVENT
END:VCALENDAR