Excel spreadsheet providing list of reminders / future tasks / to-do items (Video 1 of 3)

Excel spreadsheet providing list of reminders / future tasks / to-do items (Video 1 of 3)

Spreadsheet available for download at: http://legaltree.ca/node/1945 Excel spreadsheet that provides quick and easy creation of reminders that can then be managed on a dynamic list that highlights past due items. Useful for anybody who wants to keep a to-do list of tasks to be completed at various future dates. See video at http://youtu.be/874ts1FfaRE explaining improvements to the spreadsheet. See video at https://youtu.be/ZS03N0Ck29A for explanation of further improvements to the spreadsheet (search tool to narrow down the file list) added in February 2018. MORE FLEXIBLE PROJECT MANAGER SPREADSHEET If you would like a more flexible spreadsheet that allows you to rename columns see: https://youtu.be/wEge5na2how ACCOUNTING SPREADSHEET: Another spreadsheet by the same author = Double entry accounting spreadsheet (ledgers, income statement and balance sheet): https://www.youtube.com/watch?v=6Gl7lj9LFN8

Task Manager - Free Excel Template

Task Manager - Free Excel Template

As the name indicates, the purpose of the Task Manager Excel template is to assist in remembering tasks that need to be done. Download: http://indzara.com/2013/04/task-manager-excel-template/ This could be used by anyone who needs to keep track of tasks (one-time or recurring) and avoid forgetting them in a busy daily life. The template handles 5 different types of tasks: One-time, Daily, Weekdays, Weekly and Monthly. It allows easy printing of your schedule with tasks and pending tasks. To download the template, please visit http://indzara.com/2013/04/task-manager-excel-template/ Simple and Effective Excel Templates: http://www.indzara.com/ Free Excel Templates: http://www.indzara.com/free-excel-templates/ Premium Excel Templates: http://www.indzara.com/shop/ Project Management Templates: http://www.indzara.com/project-management-excel-templates/ Inventory Management Templates: http://www.indzara.com/inventory-management-excel-templates/ Free Excel Course: http://www.indzara.com/useful-excel-for-beginners/ Social: Subscribe to YouTube: http://www.youtube.com/user/theindzara?sub_confirmation=1 Facebook: https://www.facebook.com/theindzara YouTube: https://www.youtube.com/user/theindzara LinkedIn: https://www.linkedin.com/company/indzara Twitter: https://www.youtube.com/user/theindzara

Task Manager (Advanced) Excel Template - v2 - Demo

Task Manager (Advanced) Excel Template - v2 - Demo

http://indzara.com/product/task-manager-advanced/ This Excel template is designed to help create and manage tasks easily. This can be used by project managers who handle multiple tasks and manage multiple team members. This can also be used by individuals to manage personal tasks. REQUIREMENTS Microsoft Excel for Windows (2010 or above) Microsoft Excel for Mac (2011 or above) FEATURES Handles 100 active tasks at a time Create one-time or recurring tasks (12 choices of task types) Easily choose weekdays for each recurring task Handles 1 year of task occurrences at a time Handles 1200 task occurrences (If you have a task that repeats weekly for 4 weeks, it is 1 task but 4 task occurrences) Option to assign each task occurrence to one resource Allows up to 25 resources in total View/update status of each occurrence Customize and manage your own (up to 7) status values Instant view of pending tasks Simple calendar view of tasks in any week Task occurrence status shown with color formatting Dashboard with summary statistics Simple and Effective Excel Templates: http://www.indzara.com/ Free Excel Templates: http://www.indzara.com/free-excel-templates/ Premium Excel Templates: http://www.indzara.com/shop/ Project Management Templates: http://www.indzara.com/project-management-excel-templates/ Inventory Management Templates: http://www.indzara.com/inventory-management-excel-templates/ Free Excel Course: http://www.indzara.com/useful-excel-for-beginners/ Social: Subscribe to YouTube: http://www.youtube.com/user/theindzara?sub_confirmation=1 Facebook: https://www.facebook.com/theindzara YouTube: https://www.youtube.com/user/theindzara LinkedIn: https://www.linkedin.com/company/indzara Twitter: https://www.youtube.com/user/theindzara

How to create notifications or reminders in Excel

How to create notifications or reminders in Excel

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.com You can create reminders or notifications in MS Excel using 3 methods quickly and easily: 1. Use the IF function to display a message 2. Use conditional formatting 3. Use Excel VBA All the 3 methods are described in the training video. You can view more details here: http://www.familycomputerclub.com/how-to-create-reminders-notifications-in-excel-automatically.html Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V If you are from India you can get this book here: http://amzn.to/2jzJGqU

Microsoft Office Project 2013 Tutorial: Creating a Recurring Task | K Alliance

Microsoft Office Project 2013 Tutorial: Creating a Recurring Task | K Alliance

Learn how to create a recurring task in this Microsoft Office Project 2013 training video. Contact K Alliance for more info. ‪http://www.kalliance.com/‬ - 1.800.330.9111 Featured Instructor - Sheri Tingle Course Duration: 7 Hours 42 Minutes Link to Course: http://www.kalliance.com/desktop/microsoft/office/project/2013/ Course Catalog: http://www.kalliance.com/catalog/ Request Your 7 Day Trial: http://www.kalliance.com/trial/ Twitter: ‪https://twitter.com/#!/K_Alliance ‬Facebook: ‪https://www.facebook.com/KAllianceTraining Microsoft Office Project 2013: New Features table of contents: 1.1 Splitting a Task for Interrupted Work Time 1.2 Viewing Project Cost Totals 1.3 Importing Outlook Tasks 1.4 Creating a Custom Report 1.5 Formatting with the Gantt Chart Wizard 1.6 Creating a New Project from a Template 1.7 Creating a New Project from Scratch 1.8 Creating Milestones 1.9 Making Changes to Task Entries 1.10 Creating a Recurring Task

Excel Magic Trick 907: How To Make Excel Calendar (4 Examples)

Excel Magic Trick 907: How To Make Excel Calendar (4 Examples)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to create Dynamic Excel Calendar that changes based on a date types into a cell or the current date from the TODAY function using a non-array formula: 1. Excel Calendar using Formulas and Conditional Formatting for Excel 2003 based on date typed into cell 2. Excel Calendar using Formulas and Conditional Formatting for Excel 2007 or 2010 based on date typed into cell 3. Excel Calendar using Formulas based on date typed into cell 4. Excel Calendar using Defined Name Formulas based on TODAY function 5. See the functions: COLUMNS, ROWS, WEEKDAY, EOMONTH, MONTH and IF 6. All examples are non-array formulas. How to make a calendar in Excel 2010, 2007, 2003

Excel Multi-Staff Scheduler - Recurring Appointments Tutorial

Excel Multi-Staff Scheduler - Recurring Appointments Tutorial

Free Demo Version Here: http://bit.ly/MSS-Demo You can also view a complete tutorial of this application here: https://multi-staff-tutorial.smartmember.com/ Please email me for purchase or any questions Randy@Excel-4-Business.com

Recurring Tasks in SharePoint - 1/2

Recurring Tasks in SharePoint - 1/2

Create SharePoint list for recurring tasks: http://kalmstrom.com/Tips/SharePoint-Online-Course/Recurring-Tasks.htm

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like "Monday" 3. TEXT Function to get Month spelled out, like "January" 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. Last Day in Month: DATE, YEAR, DAY, MONTH functions 8. First Day Next Month: EOMONTH function 9. First Day Next Month: DATE, YEAR, DAY, MONTH Functions 10. Vest Date: EDATE function 11. List of First Day in Month: EOMONTH 12. WORKDAY function -- find workday in future given a certain number of days. 13. WEEKDAY function 14. Last Monday: DATE, YEAR, MONTH, DAY and WEEKDAY functions 15. Formula for Days Between Two Dates 16. Formula for Days Between Two Dates, Inclusive 17. Net Working Days with NETWORKINGDAYS Function

Excel spreadsheet for tracking tasks (shared workbook)

Excel spreadsheet for tracking tasks (shared workbook)

This video provides instructions on use of a spreadsheet, available for download at http://www.legaltree.ca/node/1932. The spreadsheet is designed to allow delegation of task, for example by lawyers to a legal assistant. It allows creation of tasks which are put on a task list and reordering of tasks according to priority. Assistants then move the tasks to a "completed tasks" section of the spreadsheet as the tasks are completed. The spreadsheet should be saved as a shared workbook so it can be simultaneously accessed by many users on a network e.g. lawyers adding tasks and assistants completing them. See http://www.legaltree.ca/node/1932 for more info. See further video explaining new features of updated spreadsheet: https://youtu.be/_CPw4dUH3K0 https://youtu.be/_CPw4dUH3K0 Another spreadsheet by the same author = Double entry accounting spreadsheet (ledgers, income statement and balance sheet): https://www.youtube.com/watch?v=6Gl7lj9LFN8

Top Videos -  loading... Change country
Load 10 more videos