Press "Enter" to skip to content

IMG Web Solutions Posts

How to Guide on using Microsoft Excel

Microsoft Excel is another excellent software program that people should learn how to use because it is used in most workplace jobs in today’s society.  Excel was primarily designed to provide worksheets that are simply made of columns and rows.  It also has a great feature of calculating simple to more difficult mathematical calculations.  You can create spreadsheets and lists for your company or for yourself if you are using it at home. 

The Excel spreadsheet has columns that are labeled with the letter A, B, C, D, all the way to Z.  The cells in the first row is A1, B1, C1, etc.  In Microsoft Excel, you can add two different cells together, for example, A1 + B1.  There is a formula bar that shows what is in the selected cell.   MS Excel workbook is a group of worksheets. 

You can move from cell to cell in Microsoft Excel.  The buttons to use on your computer laptop is your arrow keys.  You can move left, right, up and down.  The Enter Key moves to the next cell below the current cell.  You can use the Tab key to move the cell one space to the right. Another good feature is selecting one individual cells column, or row with one click of a button.  If you want to select one individual cell, just click on the cell only.  When you want to select one row of cells, select the row number.  Finally, when you desire to choose one or more columns of cells, select the column letter.   

Many healthcare environments rely on Microsoft Excel for their staff. Physicians who are certified in ACLS online often use Excel to organize their algorithms and materials. United Medical Education helps student doctors use Excel to enhance their learning experience while earning ACLS recertification online.

As well as the conventional uses for Microsoft Excel it can also be used for many other things that you may not have realized including art and even gaming! For a select few the spreadsheets are being used for digital art by using the ‘autoshape’ button. The reason it was used initially is because it is a lot cheaper than forking out for expensive digital art software.  Stop motion animation is another use for Excel and has been used behind the scenes for many years. You can break down videos into individual frames and recreate them in a mosaic pattern for magical results.

If gaming is more your thing then Excel can be used to recreate games or your own from scratch. Already people are using the Excel tools to recreate and play Tetris, Pacman and lots of other games including the well-known Candy Crush!  If Sudoku is more your thing then why not try downloading an excel file that not only allows you to play the game when you need a break from work but can also help you to solve the puzzles? The software doesn’t stop there though. You may already be aware of the Excel flight simulator that was created back in 1997. Imagine how the simulation could be developed further? Excel ticks all the boxes when it comes to work, rest and play and has so much more to offer than being a way to mail merge documents, set schedules and solve mathematical equations.

Comments closed

Guide to using PowerPoint

Have you always wondered how to prepare great presentation slides?  The answer is Microsoft PowerPoint, which is an extremely popular computer software tool to use.  PowerPoint gives you the ultimate control to create gorgeous fonts, beautiful graphics, clip art, charts, cool graphics, animation and crisp sound to make your creative visual presentation stand out in school projects or while presenting creative visual pictures, videos, and engaging content to eager crowds while giving a speech presentation at a well-known university or prestigious company.

In order to create effectively and a powerful presentation, you must create a story, which is a beginning, middle and end to keep your presentation flowing smoothly.  Also, it is recommended to present only one key message per slide.  You do not want to confuse the audience and lose their concentration.  Use elements that tie to your message or adds content.  Try to use graphics that strongly supports your ideas and messages to your audience members, after all, there’s no point in creating a slide about mathematics with graphics of physical education.  Also, keep a consistent design with your colors, graphics and font styles as this further draws in your audience and helps them to relate to the content of the slides.

Whether you are using PowerPoint to create a slideshow to present a school project, sell a product or make a point you have a variety of tools to choose from.  It helps to first familiarize yourself with the different tools if you have not already done so. If you are thinking of using PowerPoint on a regular basis it helps to also learn the shortcut keys so that you can create presentations faster as you learn your way around it. Using the visual tools in PowerPoint to captivate your audience makes it easier to keep them entertained as well as getting your message across whatever that may be.  By using the PowerPoint presentation as a story teller you can stop and start or automate the whole slide show to allow as much or as little audience interaction as you need. A great example is to use as a question and answer slide to ask a question, get the opinion of your audience and then reveal the answer. This could be used to shock people with facts and figures.

The most important concept before starting a Microsoft PowerPoint presentation is to think first and create key questions that you can answer.  Some questions that you should ask yourself is: What do you want to learn from this presentation?  Who are the audience?  What do you want your audience to learn?  Where will your presentation take place and what time?

Powerpoint is now regularly used in a variety of industries, especially in the healthcare field. Most classroom training and learning for ACLS online certification is done using Powerpoint slides. If you’d like to see examples of this you’re welcome to visit the site of United Medical Education.

These questions will help you to formulate a clear idea or thesis and will allow you to find evidence to support your main idea. Lastly, colors are important to get your audience’s attention.  Yellow is used to quickly get the audience’s attention, the color red will cause excitement or emotions to rise and white will show honesty in the speaker.  Once you have your layout and have answers to each of your own questions you will be able to create a PowerPoint presentation fit for the purpose and audience.

Comments closed

How to Guide on Using MS Word

Microsoft Word is a great software application that can be used both on Macintosh computers and Windows computers.  It is a popular software because it is simple to use and it gives you the choice to create all different types of documents including letters, greeting cards, invoices, brochures, calendars and web pages.  It is a word processing program that you can use on your laptop computer, tablet, or your smart mobile cell phone.  The first question is how do I create a new document?  It is simple.   After you download the recent MS Word application to your Mac or Windows computer, in the Start Menu, click on the Microsoft Word application.  It will open up and give you the option to choose a new blank document or a document template that has already been created.  If you want to start a new document, click on the new blank document icon.  If you want to choose a document template, choose the template that you want and click on the document template of your choose to begin.

Most people are interested in learning just the basic features of MS Word.  MS Word can be used for term papers, outlines, or writing a book or novel.  Microsoft Word allows you to move around a document.  In your desktop or your Start Menu, choose the Microsoft Word icon.  Then click on either the Office button or File button.  Choose Open on your computer and choose the document that you wish to open.  Double click with your mouse to open it.  There is a flashing cursor that will indicate where you are typing. When you create a new document, the cursor will be at the start of your document so that you can begin typing. As you type, the cursor will move with each letter that you type.  Lastly, you can move your document by using the arrow keys on the bottom of your computer laptop.  I can show you how to create a bulleted list.   First, you open up Microsoft Word.  Then, you open up the bulleted icon on top of the document.  A bullet icon will appear under your text.  Type your bulleted list.  When you press Enter, another bullet will appear.  You can stop the bullet icons by clicking on the bulleted list.  You also have the option to print a document and save a document as well.   Printing a document is easy.  You need to have a printer in order to see your documents on paper.   Make sure that you complete your document first.  Then, click File at the top left-hand corner of the document.  Select the Print menu.  Choose how many pages you have.  Then click the print icon.   The document will start printing.  Lastly, you should save a document.   First, click on File.  Select the Save button.  Choose the file that you want to save.  Then, it will prompt you where you want to save the document.  You can save it on the desktop or on your flash drive.  Then, press Save to make the changes.    

Word is the primary tool used to help create the learning materials related to PALS online recertification. Because of the flexibility of Word, physicians and nurses can easily edit and update the training materials as needed. This is why Word has become the industry standard in learning both online and in the classroom.

If you want to take things to the next level you can change your font size and print type to make certain parts stand out. Select the box with the font descriptions from the top toolbar and a list of different fonts will be shown for you to try. Highlight the text you wish to change and use the drop down menu to select the correct font. To change the size use the drop box next to the font changer. You can also embolden, italic or underline your text by using the B, I and U buttons.

To change the color of the text use the ‘A’ with the red underneath to decide what color you wish your font to be. You can also highlight important parts by using the highlighter located to the left of the text color changer.

If you want to add a picture to your document you can add one that you already have in your files by selecting the ‘insert’ tab or choose a clip art picture, chart, and shapes. To complete your document you can also add headers, footers and page numbers by using the same insert tab. There’s so much more to Word than just typing up a letter. Play around with the different features to make it easier to use in the future. When you are done you can create a new document to go back to the original settings to start your new document so don’t worry, playing around will not affect the original set up.

Comments closed

Guide to Using Visual Studio

Visual studio is only a Windows software application.  Apple Macintosh computer users cannot use the visual studio software.  There is an IDE guide, which stands for the interactive development environment.  Its purpose is to write, debug and test code in order to increase your work productivity.  It is important to sign into your Microsoft Office account to access Visual studio.  After you sign in, you will be able to keep your multiple devices at the same frequency.  It allows you to connect to the online Visual studio on your Windows computer.

This software will help computer programmers who have tasks such as creating algorithms, analysis, along with testing, debugging, and keeping the written source code in top working order.  When you begin working on Visual Studio, you should open a visual studio solution.   It is important to know that the name of the solution is App1.  When you want to open a file, double-click on one of the files and choose Open on the menu.  Also, it is important to know that code files display different features and text editors that are used for programming.  It is important for beautiful website codes for your online website.   Then, you use the Build Solution to put together your code.  You can check to see if your code has no bugs or viruses.  It is important to debug the code by selecting the Debug menu and clicking on Starting Debugging.

Another simple project to try is one that allows you to build a program to load pictures from your files to display in a specific window. You will use simple drag controls to do so and then set the properties. Once the properties are set you can use preset containers to get them to the right size.  To do this you will first need to create a new project. The next step is to add anything you need extra such as check boxes if you need to create a form. You can also portion your controls using the layout function and so much more.

Thanks to IntelliSense you are able to learn about the codes you use to create your programs as well as keep a track on parameters without having to enter numerous keystrokes. Once you start typing a code you will notice that a list of possibilities come up for you to choose from. You can continue to type to narrow down until you have the code you want. Once you have selected the code you are able to insert it easily by using the TAB or spacebar keys. You can also select the item you want and type in a period. This will cause the period to come after the item and offers you an additional list to choose an item to insert. You can also get quick information as to what it does before inserting it into your code.

Always remember that the left-hand icon represents the member type. If you want to look for icons further down you can do so by using the page up and down buttons to scroll and select.

Comments closed