BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//WhyExcel - ECPv4.6.23//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:WhyExcel
X-ORIGINAL-URL:http://whyexcel.com
X-WR-CALDESC:Events for WhyExcel
BEGIN:VEVENT
DTSTART;TZID=UTC+8:20161220T090000
DTEND;TZID=UTC+8:20161220T170000
DTSTAMP:20260429T101651
CREATED:20161130T170132Z
LAST-MODIFIED:20170214T142944Z
UID:683-1482224400-1482253200@whyexcel.com
SUMMARY:Excel for Business Owner (startup)
DESCRIPTION:  OverviewThis 1-day Instructor Led course shows participants on how to create their own templates in meeting their individual business needs. This course covers basic business order-to-cash processes (i.e. receive inquiry from customer\, issue quotation\, receive sales order\, issue invoice and deliver goods\, receive payment)\, client tracking\, and inventory tracking. \n  Who Must AttendBusiness owners or working professionals that want to create template to ease their tasks\, tracking and monitoring.\nOUTCOME\nAt the end of this course you will be able to: \n\nCreate professional looking document from scratch\, such as quotations and invoices\nCreate invoice summary with automatic notification on payment due\nCreate inventory tracking with automatic notification on low quantity\nContinuously serve your loyal clients by knowing their buying history\nCreate dashboard (i.e.: one page report) to see bestselling products\, top clients and monthly invoice amounts\nPREREQUISITES\nTo ensure your success\, we recommend the delegates equip with the following or equivalent knowledge: \n\nA working knowledge of Microsoft Windows\nA working knowledge of Microsoft Excel is a plus\n\nPlease Note: If you attend a course and do not meet the prerequisites you may be asked to switch to appropriate course or to excuse yourself. \n\n DURATION 1 Day (9 am - 5 pm)  METHODOLOGY Face-to-face learning with demonstrations and practical hands-on. \n\nTraining Outline\nDay 1\n1. Excel 101\n\nBasic Terminology\nCreating\, Saving\, Opening\, and Closing Workbooks and Worksheets\nNavigating in Excel – Within a Worksheet and Between Workbooks\nSelecting Cells\, Rows and Columns\, Non-adjacent Cells\nEditing\, Updating\, and Deleting Data\nSheet Background Colour\, Name\, Hiding\, and Unhiding\nActivating the Menus\nAccessing the Toolbars with the Keyboard\nBasic and Common Shortcut Keys\n\n2. Create Inventory List\n\nGolden Rules of Good Data Management\nEntering Data of Number\, Text and Date\nFormat Cells of Bold\, Colour\, Italic\, Font\, Borders\nCreating and Using Cell Styles\n\n3. Create and Format Own Invoice/ Quotation\n\nSetup Page Size\, Header & Footer\, Orientation\, Margins\nUse Formulas to Calculate Total Price\nUse Formulas to Calculate Due Date\n\n4. Create Own Tracking with Conditional Formatting\n\nSet Automatic Highlight on Overdue Invoice\nSet Automatic Highlight on Low Stock\nSet Automatic Highlight on Customer Birthday\n\n5. Create Own Summary on Quotation\, Invoice\, Inventory and Client\n\nSort and Filter on Table\nRemove Duplicate Entries\n\n6. Increase Data Accuracy\n\nMaintain Master Data of Inventory and Client\nUse Dropdown to Select Product and Client\nRetrieve Additional Details from Master Data via Lookup Function\nAutomatic Generate Running Number for Quotation and Invoice\n\n7. Create Dashboard to View Business Performance\n\nTop Clients\nBestselling Products\nMonthly Revenue\n\n\n  Hardware & Software\nA laptop is required for this course (PCs not provided)\nExcel 2007 or later is installed\n\n\nInterested to Register? \nLet's have one of our friendly consultants to guide you through the registration process. Register\nLooking for Something Unique or In-house Training? \nLet's have one of our friendly consultants talk to you... Request for Quotation\n
URL:http://whyexcel.com/event/excel-for-business-owner-2016-12-20/
LOCATION:SetiaWalk\, Puchong\, Selangor\, Malaysia
CATEGORIES:Training
ORGANIZER;CN="WhyExcel%20PLT":MAILTO:ask@WhyExcel.com
END:VEVENT
END:VCALENDAR