Infographic

Photo Editors

Piktochart is a web-based infographic application which allows users without intensive experience as graphic designers to easily create professional-grade infographics using themed templates.

PhotoScape is a graphics editing program, developed by MOOII Tech, Korea. The basic concept of PhotoScape is 'easy and fun', allowing users to easily edit photographs taken from their digital cameras or even mobile phones.
Photobucket is an American image hosting and video hosting website, web services suite, and online community dedicated to preserving and sharing the entire photo and video lifecycle. 

RESOURCES
https://en.wikipedia.org/wiki/Piktochart
https://en.wikipedia.org/wiki/Photobucket
https://en.wikipedia.org/wiki/PhotoScape

Basic Principles of Graphics and Layout

Proximity

Proximity means grouping elements together so that you guide the viewer/reader to different parts of the message. Notice below in the template on the left, taken from Apple’s Pages, related elements are grouped together, as opposed to the linear arrangement of amateur designs as shown on the right

Alignment

Another important design principle is aligning elements in a visual and readable arrangement. Most amateur designers start off by aligning everything in the center of the page, but that’s not the only way. Again with the “scattered” looking design, we can see the alignment of elements that helps keep the design balanced. The top group of text is left-aligned, and three larger text elements are vertically aligned.

Repetition

Like the use of repetitious hooks in a song, repeating elements in a graphic design can be visually appealing. In the two examples below, a numbered list is used, but there’s also the repetition of the blue circles that make a bolder statement.

Contrast

Contrast between design elements can make a presentation stand out and get noticed. Take for example this original template from the personal graphic design site, Canva.com. The elements of the design are grouped together, with strong alignment and repetition of  of the arrows and bullet points. But for some purposes, the original design could be a little flat.

White Space

Depending on the presentation, the use of white space can be very powerful in design. It’s useful when you want to make a direct message, to stand out above the clutter found in many graphic designs. In this Canva business card template, the empty space helps bring clarity to the message.

Resources:

http://www.makeuseof.com/tag/5-basic-principles-graphic-design-take-granted-everyday/

How to use hyperlinks

In PowerPoint, you can use hyperlinks to link to resources that are not online. To create a quick way to refer to another slide in your presentation, you can create a hyperlink to that slide. If you need to access a file stored on your computer, you can create a hyperlink to it. Additionally, PowerPoint allows you to format pictures and shapes as hyperlinks.

To insert a hyperlink to another slide:

1.      Right-click the selected text or image, then click Hyperlink.

2.      The Insert Hyperlink dialog box will appear.

3.      On the left side of the dialog box, click Place in this Document.

4.      A list of the other slides in your presentation will appear. Click the name of the slide you want to link to.

5.      Click OK. The text or image will now be a hyperlink to the slide you selected.

Resources: http://www.gcflearnfree.org/powerpoint2013/hyperlinks-and-action-buttons/2/

Excel Formulas

EXCEL FORMULAS

1. SUM

Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)

2. COUNT

Formula: =COUNT(A1:A10)

3. COUNTA

Formula: =COUNTA(A1:A10)

4. LEN

Formula: =LEN(A1)

5. TRIM

Formula: =TRIM(A1)

6. RIGHT, LEFT, MID

Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).

(Note: In all of these formulas, wherever it says “text” you can use a cell reference as well)

7. VLOOKUP

Formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

8. IF Statements

Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)

9. SUMIF, COUNTIF, AVERAGEIF

Formulas: =SUMIF(range, criteria, sum_range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average_range)

10. Manually enter Excel formulas:

Long Lists: =SUM(B4:B13)

11.  Click the Insert Function button

=COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

12  Select a function from a group (Formulas tab)

=TODAY() Inserts today’s date.

13. The Recently Used button

=AVERAGE(B4:B13) adds the list, divides by the number of values, then provides the average.

14.  Auto functions under the AutoSum button

=MAX(B4:B13) returns the highest value in the list.

=MIN(B4:B13) returns the lowest value in the list.

15. =DAYS

Formula: =DAYS(A30,A29)

16. =NETWORKDAYS

Formula: =NETWORKDAYS(A33,A34)

17. =TRIM

Formula: =TRIM(A39)

18. =CONCATENATE

Formula: For dates enter: =CONCATENATE(E33,” “,F33,”, “,G33)

Formula: For phone numbers enter: =CONCATENATE(E37,”-“,F37,”-“,G37)

19. =DATEVALUE

Formula: =DATEVALUE(H33)

20. Count cells not equal to x or y

Formulas: COUNTIFS. SUMPRODUCT

COUNTIFSSUMPRODUCT

 Resources:

https://exceljet.net/formulas

https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ECFDC708-9162-49E8-B993-C311F47CA173