Videos uploaded by user “Amir Parmar”
Convert Microsoft Word document to Ebook
In this video learn how-to convert a Word file in Ebook format using free Calibre format. Link for Calibre software: http://calibre-ebook.com/ Here is a video on Page numbering for Books, list of table & list of figures: https://www.youtube.com/watch?v=LQoLmvV5M9o Tutorial on Table of Contents https://www.youtube.com/watch?v=7Nx6UCJyv2A&list=PLcmYWY91gQNeGHXKZG7Vvw8pW9p2MsIuU&index=7
Views: 35669 Amir Parmar
Add individual images to Mail Merge
Learn to add images in Mail Merge, different for each person or same image for a group of people. Here is a link to an article that provides another way to make it faster to work with images. http://onmerge.com/articleIncludePicture.html If you wanted to send out Emails with Variable images, this method might not work. You might want to look into 2 addons listed below. http://www.mapilab.com/outlook/mail_merge/ http://www.onmerge.com/OnMergeImages.html for Mac users, read this and see if it helps Hi, I also found there is something to do with Expose in System Preferences that activates the f9. I was able to test something else on a Mac with Word 2008. The Option + F9 did not work, so i went to TOOLS - Keyboard Shortcuts. On the left change to show ALL shortcuts, on the Right scroll down to the V section and look for ViewALLFields. This button has the shortcut Option + F9 assigned to it. I changed that to Option + F5. I was than able to use this shortcut key. Thanks for the feedback. And here is a tip that the person replied with I was able to get it to work, though I did use different fields { IF { INCLUDEPICTURE "{ IF TRUE "{ MERGEFIELD imagepath }" }" } { INCLUDEPICTURE "{ IF TRUE "{ MERGEFIELD imagepath }" }" } } and also instead of '//' you have to use ':'
Views: 161606 Amir Parmar
Microsoft Access 2007/2010 Add Password to Database
In this video learn to add password to whole database and check out this link to learn about how to add password to a Form or Report: http://support.microsoft.com/kb/179371
Views: 34429 Amir Parmar
Microsoft Word Mail Merge Envelope (Word 2013/2016)
In this tutorial learn to create Envelopes using Mail Merge feature of Microsoft Word. These steps can be used in Word 2013/2016/2010 & 2007.
Views: 96944 Amir Parmar
Microsoft Access pt 9 (Cascade Combo Box)
In this video learn to create Cascading Combo Box by which when you choose a Country, it will only list the State/Province from that Country. And upon choosing the State/Province the Cities from that state only. To Download sample file go to http://simpletek.ca/files/access-2013/
Views: 148250 Amir Parmar
Microsoft Access 2007 2010 2013 pt 7.a (Auto-complete Form fields)
In this video learn how-to fill up fields in forms automatically. For example when you pick a Product, it fills in the Price of the product in the appropriate field.
Views: 135781 Amir Parmar
Microsoft Word - Create Form (Office 2007/2010/2013/2016)
In this video learn to create forms using Control buttons in Microsoft Word. Create forms with fields to fill in details, a date picker, a picture placeholder and also combo or list box for users to pick from a list. Also learn about templates. Here is the link part 2 for auto-updating Header once the Form is protected. https://www.youtube.com/watch?v=WUHfQ1Ln_3Q Tutorial on "Create Online Forms" https://www.youtube.com/watch?v=Yz76iqKNMfc
Views: 735091 Amir Parmar
Microsoft Word - Update Header in Protected Forms
In this video learn howto update your Header in a From that is Password Protected by using SyleRef feature of Microsoft Word. Full Microsoft Word - Form Tutorial https://www.youtube.com/watch?v=M01PujJqMV8
Views: 7701 Amir Parmar
Create Labels in Microsoft Access
Create Labels using Microsoft Access
Views: 17271 Amir Parmar
Microsoft Access pt 11 - Forms with Tabs, Report buttons on Forms
This is follow up video from part 10. In this video learn to create a Form with multiple table in various tabs of Forms. And learn to add Buttons in Forms to open Reports. Link to Sample zip file http://simpletek.ca/files/access-2013/
Views: 35947 Amir Parmar
Exam Prep Microsoft Outlook 2010/2013/2016
In this tutorial video learn about exam question/answers for Microsoft Outlook 2013/2010. The ideas presented here and in the 3 MS Outlook tutorials can also prepare you for the Microsoft Exam 77-423. Please see Exam objectives and prepare accordingly. https://www.microsoft.com/learning/en-in/exam-77-423.aspx
Views: 179049 Amir Parmar
Exam Prep Microsoft Excel 2007/2010 pt 2
Macros, Data Validations, Password Protect Sheet.
Views: 110128 Amir Parmar
Microsoft Project 2007 Pt 1 (Tasks)
Learn to use Microsoft Project 2007, add Project Start Date, add calendar work exceptions & work time. Learn to add tasks, duration, notes, attachments. Create Milestones & Summary tasks. Link all tasks together. Learn about different types of Tasks, Task dependency & Constraint types.
Views: 317143 Amir Parmar
Microsoft Access 2007 2010 part 3 (Query & Reports)
Learn about Simple Query and Reports in Microsoft Access
Views: 272980 Amir Parmar
Microsoft Access 2007 2010 2013 pt 8 (Find/Search Record Macro, Email Macro, Print Macro)
In this video learn to create Macro for Finding Record, Printing, Emailing Reports and Searching. After creating the Macro, learn to assign them to Form Buttons. Link for sample file and notes http://simpletek.ca/tutorials/access2007/
Views: 165244 Amir Parmar
Microsoft Word Mail Merge Email Messages (Word 2013/2016)
In this tutorial learn how-to send Email messages using Microsoft Word Mail Merge and use Microsoft Outlook to send the message.
Views: 56992 Amir Parmar
Introduction to Microsoft One Note 2010
Learn the basics of One Note. Use One Note as a journal, to-do list, save websites, recipes, project details, meetings etc.
Views: 117783 Amir Parmar
Microsoft Project 2010/2013 pt 2 (Resources)
Continuing from Part 1, in this video learn about adding Constraints to a task and deadline. Learn about adding Resources to your project and applying them to a task. Add Work, Material and Fixed Cost Resources. Change working hour of a Resource. Learn how to change $/Hr of a Resource if their rate changes during the project.
Views: 121418 Amir Parmar
Microsoft Outlook 2013/2016 part 2 (Email, Contacts, Calendar, Tasks, Notes)
In this video learn to create Follow up for emails. Write Emails, Create Individual & Group Contact. Add Calendar appointments and meetings; setting Reminders, Recurrence & Invite People to your meetings. Add Tasks, assign it to people and create Notes.
Views: 41733 Amir Parmar
Microsoft Project 2007 Pt 3 (Resource Levelling & Reports)
In this video learn to check for over allocation of resources and how-to fix the problem by using the Leveling too and split task button. Set Baseline. Print Gant Chart, add Cost and Title to the chart. Create/Print Reports. Email project file.
Views: 62870 Amir Parmar
Microsoft Project 2010/2013 pt 5 (Master Project & Macro)
In this video learn about Master Project, which allows you to manage multiple sub-projects from one Master project file and with 1 Resource pool. And also learn to Record & Run Macros.
Views: 46028 Amir Parmar
Microsoft Word 2013/2016 pt 7 (Table of Contents, Bibliography, Endnote, Index)
In this tutorial learn to add Table of Contents.Use PageBreaks to add Chapter breaks. Add Citations in your research paper and add Bibliography at the end of the document. Add EndNote and FootNote. And lastly learn about adding Index for your paper/book.
Views: 46416 Amir Parmar
Exam Prep PowerPoint 2016/2013/2010 (Short version)
This is a shorter version of another tutorial that I did for PowerPoint 2016/2013/2010 exam prep. Link to Longer version https://www.youtube.com/watch?v=Cmnnbz7Mv4c
Views: 58237 Amir Parmar
Exam Prep Word 2016/2013/2010
A quick review of important exam questions for employment based test and MOS certifications. For MOS please see exam objective for 77-418 (office 2013) and 77-881 (Office 2010) If you want to know more about any of the questions, go to the playlist link below and watch the detail video on that topic. Playlist of all Word 2013/2016 individual videos, also has the mail merge video: https://www.youtube.com/playlist?list=PLcmYWY91gQNeGHXKZG7Vvw8pW9p2MsIuU
Views: 388565 Amir Parmar
Microsoft Access 2013/2016 pt 1 (Tables)
Learn to use Microsoft Access 2013/2016, introduction to designing tables and entering records. Create Lookups, add Date and Telephone Input Masks. And basic introduction to using Calculated fields in Table.
Views: 90853 Amir Parmar
Create Online Forms
In this tutorial learn to create Online Forms via Google Drive and Microsoft OneDrive for free. Create/Share documents in Hotmail OneDrive & Google Drive https://www.youtube.com/watch?v=lLcMCluO_7E Google Drive, create files, send fax, backup files https://www.youtube.com/watch?v=xi4uNKBx77E
Views: 33189 Amir Parmar
Microsoft Word - Create Flyer
In this tutorial learn to create Flyers in Microsoft Word and convert them to PDF. Also learn to edit PDF in Word 2013.
Views: 84539 Amir Parmar
Mail Merge Letter (Word 2013/2016)
In this tutorial learn to create Mail Merge Letters in Microsoft Word 2013/2016. The steps shown here also apply to Word 2007 & 2010.
Views: 203105 Amir Parmar
Microsoft Access pt 10 - Invoice with Payment & Dlookup
In this video learn to create an Invoice with Payments & Balance. Also learn to use Dlookup. This video applies to all versions of Access. Link to sample file that included the sample database and notes: http://simpletek.ca/files/access-2013/
Views: 70392 Amir Parmar
Microsoft Access 2007 2010 part 2 (Table Filter, Sort & Forms)
Learn more about tables, filter, sort and also learn how-to create Forms and modify form Layout
Views: 293612 Amir Parmar
Microsoft Project 2007 Pt  2 (Resources)
Create Resource list and assign them to Tasks. Change individual Resource Hours & charges if they change mid project. Understand different types of Resources and learn to add Fixed Cost to Tasks. PowerPoint Notes can be downloaded from here (you may need to scroll down): http://simpletek.ca/files/
Views: 91486 Amir Parmar
Microsoft Access 2007 2010 part 4 (Relational Database)
In this video get an introduction to Relational Database with Table, Forms, query and Report
Views: 179141 Amir Parmar
Introduction to Microsoft One Note 2013
Learn to use Microsoft Office OneNote 2013. Basic setup. Use OneNote to track project, homework, save Recipes from internet. Learn to add sections, page, use page templates. Insert Picture, table, excel spreadsheet, symbol, equations, links, video, audio. translate words to other languages. Sync with SkyDrive. Share/Export notes with other. Email notes.
Views: 75973 Amir Parmar
Microsoft Project 2010/2013 pt 1 (Tasks)
Learn the basics of Microsoft Project 2010: Add Project Information like Start Date and Working Days/Time & Holiday Exceptions in Calendar. Add/Delete Tasks, Add Summary Task, Add Milestones, Add Recurring Tasks. Understand Task Types & Task Dependency. Also learn to add Lag or Lead time to a task. More info on Elapsed Duration (1ed) http://office.microsoft.com/en-ca/project-help/task-settings-that-affect-how-tasks-are-scheduled-HA001055204.aspx
Views: 385059 Amir Parmar
Microsoft Access 2007 2010 2013 pt 7 (Parameter query with Form; Macro & Append/Update/Delete Query)
First learn about "Make Table" query, Update query, Delete query & how-to use Marcros. And also create a Parameter query and accept input from a FORM rather than having the prompt box. Create a Parameter query and accept input from a FORM @ 14:00
Views: 65105 Amir Parmar
Microsoft Excel 2013/2016 pt 7 (IF, SumIF, SumIFS, COUNTIF, AVERAGEIF, VLOOKUP)
Link to sample file: http://simpletek.ca/files/excel-2013-files/ In this tutorial learn to use IF function followed by SumIF, SumIFS. Use Count Function and a variation of it called CountIF; in the same manner understand AverageIF. And lastly we will look at Vlookup function.
Views: 109391 Amir Parmar
Microsoft Project 2007 Pt 5 (Master Project)
In this video learn to link separate project files into one Master project with one Resource pool to share resources across projects.
Views: 23617 Amir Parmar
Create Form in Tables using Microsoft Word
Use tables to create Form fields in Microsoft Word. Also learn to Restrict Editing with password and add StyleRef to auto fill data in Header. Original Form Tutorial https://www.youtube.com/watch?v=M01PujJqMV8 Link to "Create Online Forms" tutorial https://www.youtube.com/watch?v=Yz76iqKNMfc If you are having issues with using Option button, go to the link below and scroll down to Resolution for Symptom 1 and use the FixIt software fix. support.microsoft.com/kb/3025036
Views: 52972 Amir Parmar
Microsoft Excel (Goal Seek, Scenarios, Solver)
In this video learn to use Goal Seek, Scenario Manager and Solver features of Microsoft Excel 2013. This also applies to Excel 2007 & 2010. Click on the link to download the sample file: http://simpletek.ca/files/excel-2013-files/
Views: 93727 Amir Parmar
Microsoft Word 2007/2010/2013 Exam Q & A pt 2
Part 2 covers the rest of the Tab/Ribbons under Insert (Chart, Table formula, Hyperlink, Bookmark, WordArt, symbols, equations), Page Layout (Themes, Breaks, Page Setup, Columns), References (table of contents, Citations, Bibliography, Mailings (Envelopes, Labels, Mail Merge), Review (Insert Comment, track changes, restrict editing) View & macros.
Views: 98802 Amir Parmar
Microsoft Outlook 2013/2016 part 3 (Read Receipts, Voting option, Rules, Quick Steps,
In this video learn how to set Read and Delivery Receipts for emails, Delay Delivery of Emails and set Reply email back to someone else. Create Voting emails to get feedback. Create Folders for emails. set Rules to get things done automatically. Create Quick steps for repeat jobs and Create Templates.
Views: 15683 Amir Parmar
Microsoft Excel 2007 2010 pt 6 (Concatenate, CountIf, Vlookup, Macros...)
Download link to example file http://simpletek.ca/files/ In this video learn about Concatenate, Countif, Vlookup functions. Also learn to convert "Text to Column", how-to print Titles on all pages, create/use Macros and password protect your sheet.
Views: 36585 Amir Parmar
Microsoft Outlook 2010 pt 2 (Create Email, Poll, Contacts, Groups, Rules, Folders)
Create Contacts and Groups in Outlook 2010. Create new email messages, add attachments, change signatures, request delivery/read receipt, followup, Create Voting Poll, Insert Hyperlink. Learn to create folders and move messages to those folders. Create Rules to manage incoming emails.
Views: 15626 Amir Parmar
Microsoft Access 2013/2016 pt 4 (Table Relationship)
Click to download sample file http://simpletek.ca/files/access-2013/ In this tutorial learn about table relationship , turning on Referential Integrity and allowing update and deletes to take place between tables. Create Query, Form and Report using Fields from 2 tables.
Views: 91234 Amir Parmar
Microsoft Project 2010/2013 pt 4 (Advanced Formatting & Views)
In this video learn to format Tasks, Gant Chart. Create Custom Views of Gant Chart, Calendar or tables. Create Custom fields with calculation and copy it to the Global template to use in future project files.
Views: 75705 Amir Parmar
Microsoft Excel Financial Functions
In this video learn to use built-in Excel Financial Functions. Learn to use Present Value (PV), Future Value (FV), PMT, IPMT, PPMT, NPER, RATE and RRI functions. Link to sample file: http://simpletek.ca/files/excel-2013-files/
Views: 100572 Amir Parmar
Microsoft Word 2013/2016 pt 4 (Styles, Find/Replace, Page Layout,margins, orientation, columns)
In this tutorial learn to Edit and Create Styles. Use the Find and Replace buttons and learn to find only Formats (like Bold) and replace with (Not bold). Use Page Layout to change Margins, Orientation and add Columns to your paragraphs.
Views: 32465 Amir Parmar
Microsoft PowerPoint 2010 pt 3 (Insert Sound, Video, YouTube, Custom Show, save as Video)
In this video learn to add sound to play across slides, add videos on your computer to a slide and also adding (embed) a YouTube video in a slide. Create Custom show to run your PowerPoint in a certain order. And save your PowerPoint as Video. Embed code for YouTube, click on link below as YouTube would not let me put the code here. (code works as of March 14, 2013) https://docs.google.com/file/d/0BxohSubsMM49VERRc1RqMHJDcVU/edit?usp=sharing To read more about the Embed code options go to link below: https://developers.google.com/youtube/player_parameters
Views: 43692 Amir Parmar
Microsoft Access 2013/2016 pt 2 (table pt 2)
Continuing from Part 1, learn about Default Value, Validation Rule/Text, IIF calculated fieds. Learn to filter/sort records, freeze columns, find/replace words in records.
Views: 33604 Amir Parmar
Microsoft Access 2013/2016 pt 3 (Query, Forms, Reports)
Link to sample database used in this tutorial http://simpletek.ca/files/access-2013/ In this tutorial learn the basics idea of Query, Forms & Reports. Learn to create simple query using Parameters and wildcards. Create Forms to enter Records, add Navigation Button & option buttons on forms. Create Reports for entire Table or based on a query.
Views: 243787 Amir Parmar