Wednesday, September 16, 2015

7 Essential Excel Tricks Every Office Worker Should Know - #infographic

infographic - 7 essential Excel tricks every office worker needs to know

Becoming an Excel power user is crucial in this day and age as the software is so commonly used within office and IT business companies – providing an easy and effective way of compiling data.

According to a report published this year, 78 percent of middle-skill jobs required the employee to have digital literacy skills meaning that anyone who might not be completely up with how to use the required software and tools may lose out on getting the job. 67 percent of those jobs demanded specific expertise in Excel and Word software.

For any office workers looking for career progression, then keeping on top of all things digital is extremely important. Thankfully, the latest infographic from Best STL Microsoft Training has looked at seven of the most important tips and tricks you need to know if you’re going to use Excel to its fullest.

Have a look at the infographic below and go forth as an Excel know how.

by Irfan Ahmad via Digital Information World

Indiana Jones and the Lost SVG Map Editor

Maps are great devices for telling stories.

Game of Thrones titles

Game of Thrones famously uses a map in the title sequence to help set the epic tone of their universe. Casablanca sets up its opening scenes with a map centered on Paris that traces a thick black line south to Morocco.

Forty year later in ‘Raiders of the Lost Ark’, Steven Spielberg was using a similar trick to help us track Indiana Jones’ Boeing seaplane on a map below.

Raiders of the Lost Ark ride line on the map.

Maps can be powerful on the web too, letting us tie important ideas and numbers to specific geographical areas. This could be anything including:

  • Sales
  • Subscribers/viewers
  • Paid Members
  • Regional Offices

But where do you start with creating maps? Screen capturing Google Earth isn’t going to cut it. You could draw a map from scratch, but coastlines are finicky, time-consuming things to create.

Using AMCharts to Make for SVG Maps

AMCharts offers a bunch of really cool JavaScript charting tools, including pie charts, line graphs and bar graphs. But they also have a rather nifty map creation tool in beta called Pixel Map Generator.

Pixel Map Generator

The tool is easy to get started with. Controls at the bottom of the app let you zoom, position and frame the map to your liking, so if you only need a small area, that’s fine. A dropdown lets you select individual countries.

A toolbar on the left lets you add routes, re-color elements, annotate and label your map. Pulling together the basic components of a useful map takes minutes.

Map tools

I think the really cool part are the export options. PNG, HTML (JS) or SVG. That last option is the one I like. Typically SVG written by graphics editors can be very messy and unwieldy. AMChart seems to write clean, well-structured SVG files. You can save that file and embed it straight into your next site/web app.

But you can also do more.

You could open this SVG map directly in Adobe Illustrator, but I wouldn’t advise it – the file will get rewritten and you’d lose a lot of its elegance.

[author_more]

[/author_more]

A more interesting idea is to copy the SVG code and paste it straight into a Codepen HTML panel. Even if you know zero about SVG markup, you’ll recognise it as a ‘HTML-like file’ that you can start manipulating and styling with CSS.

Here’s one I prepared earlier.

See the Pen dYGxPE by SitePoint (@SitePoint) on CodePen.

Like HTML, you can add classes and IDs to elements and then target those elements with CSS - even transforms, animations and transitions.

That’s a lot of design freedom to play with and AMCharts does all the hard map-drawing bits.

Continue reading %Indiana Jones and the Lost SVG Map Editor%


by Alex Walker via SitePoint

Registering a Business Globally with Estonia’s E-residency

global business

I’ve lived in three countries in my life, and I travel on a regular basis. I wouldn’t go as far as to say that we should have global open borders, but there are ways that the life of the new breed of global entrepreneurs could be easier.

One of those is registering a business. Registering a business outside of your country of residence has historically been reserved for those who have big businesses or those up to no good (or both). I would guess that many of you reading this live in one country, have perhaps lived in (or have strong connections to) another, and work for clients in others—paid in a variety of currencies.

A Game Changer from Estonia

Enter Estonia’s e-Residency program, an intriguing idea with big aims.

e-Residency offers to every world citizen a government-issued digital identity and the opportunity to run a trusted company online, unleashing the world’s entrepreneurial potential.

I think it’s a fantastic concept, and I love that many smaller countries around the world have decided to try these sorts of ideas. They have nothing to lose, so are trying ideas that larger or older countries either wouldn’t or couldn’t ever try.

One of the main advantages of Estonia’s program is that Estonia is an EU member, which opens your business to the EU trading zone and gives you access to bank accounts and financial tools (e.g. PayPal) in Euros—a globally recognized currency.

I’m a British citizen, but lived in Australia for seven years (where my business is currently registered), and I’ve been living in Germany for the past year. Much of my contract and freelance work is undertaken with clients outside of Germany, and I remain uncertain what my best approach is.

To me, and many like me, Estonia’s e-Residency program seems a dream come true, and I was keen to give it a try. I was aware of the program already, and then met some of its representatives at an event in Finland who encouraged me to sign up on the spot. I wanted to research more first (and write this article), but the fact it was even possible was amazing.

This Is Not Citizenship

As an e-Resident of Estonia, your rights are purely for business. So for anyone looking for a loophole to EU citizenship, this isn’t it. You get no extra rights to entry that you’re not entitled to already.

Continue reading %Registering a Business Globally with Estonia’s E-residency%


by Chris Ward via SitePoint

How to Use SSL/TLS with Node.js

Using HTTPS is becoming more and more prevalent, therefore we should know how to implement SSL/TLS in our Node.js applications - either for accessing HTTPS resources or for providing resources with encryption. What does HTTPS actually mean? What does it imply? Are there any constraints and restrictions? We will try to find an answer for all of these questions.

Additionally, we should not only try to protect our clients by providing HTTPS, but we should also demand encrypted connections from the servers we are talking to. We will see that possibilities exist to activate the SSL/TLS layer even if it wouldn’t be enabled by default. Let’s start with a short review of HTTPS’s current state.

HTTPS Everywhere

On February the 17th 2015 the HTTP/2 protocol was approved by the IESG to be published as a proposed standard. This was a major milestone. Now we can all upgrade our servers to use HTTP/2. One of the most important aspects is the backwards compatibility with HTTP 1.1 and negotiation mechanism to choose a different protocol. Although the standard does not specify mandatory encryption, most browsers will only support HTTP/2 over TLS. This gives HTTPS another boost. Finally HTTPS everywhere!

What does our stack actually look like? From the perspective of a website running in the browser (application level) we have roughly the following layers to reach the IP level:

  1. Client Browser
  2. HTTP
  3. SSL/TLS
  4. TCP
  5. IP

HTTPS is nothing more than the HTTP protocol on top of SSL/TLS. Hence all the rules of HTTP still have to apply. What does this additional layer actually give us? There are multiple advantages. We get authentication by having keys and certificates. Also a certain kind of privacy and confidentiality is guaranteed, as the connection is encrypted in an asymmetric manner. Last but not least data integrity is also preserved, i.e. that transmitted data cannot be changed during transit.

One of the most common myths is that using SSL/TLS requires too many resources and slows down the server. This is certainly not true anymore. We also do not need any specialized hardware with cryptography units. Even for Google, the SSL/TLS layer accounts for less than 1% of the CPU load. Furthermore the network overhead of HTTPS as compared to HTTP is below 2%. All in all it would not make sense to forgo HTTPS for having a little bit of overhead.

Continue reading %How to Use SSL/TLS with Node.js%


by Florian Rappl via SitePoint

WordPress Hybrid Client: WordPress Powered iOS/Android Apps

WordPress Hybrid Client

WordPress Hybrid Client (WPHC) is an Open Source project available on GitHub that lets you easily create iOS and Android versions of your WordPress website for free.

WPHC is based on the Open Source hybrid stack Ionic SDK, Cordova, and Crosswalk .

WPHC on devices

Features

  • Push notifications
  • Bookmarks (offline mode)
  • Google Analytics support
  • Automatic content updates
  • Social buttons
  • Accessibility (post font size)
  • Multi languages (English, French, Chinese)
  • Infinite scroll
  • Syntax highlighter for tech blogs
  • Image cache
  • App rate

Built with WPHC

Here are a few examples of projects built using WPHC:

Continue reading %WordPress Hybrid Client: WordPress Powered iOS/Android Apps%


by Julien Renaux via SitePoint

Syncing CSS Animations with HTML5 Audio

CSS and HTML have opened a rich playing field for adding multimedia content to your web page, web app, and e-book projects. One innovative way of combining these two technologies is adding sound effects to your CSS animations using <audio> elements and triggering them with a little bit of JavaScript.

Although sound on the web isn’t universally welcome, there are cases when it can enrich the user experience without being an unnecessary annoyance. Examples are artist and gaming websites or content for children. Sound can even be useful in certain cases to visitors with disabilities.

The most important part of the sound animation process is adjusting your CSS animation to the audio to achieve an accurate in-sync audio-visual experience. In this article I’ll go through the steps of syncing animation keyframes to audio timing data using an interesting example of a beating stylized heart.

See the Pen CSS Animation with Sound: Heartbeat by SitePoint (@SitePoint) on CodePen.

Constructing the Heart

The first ingredient we need is a heart we want to animate. We will construct one using CSS pseudo-elements. Having it constructed in HTML rather than using an image, even if only through pseudo-elements, gives us the opportunity to animate various CSS properties to create a more interesting animation.

We can often find more than one way to build a shape this way, but if we plan to animate it it’s worth thinking about geometry and how different structural choices affect movement and simplify the keyframes code.

In this case the simplest technique is to use two vertical rectangles rounded on top, rotated, and positioned to overlap to form a heart shape. Their size is set using percentages and they’re absolutely positioned with a bit of geometry consideration so it’s easy to scale the original shape by changing the container size. The rectangles are rotated 45 degrees clockwise and counterclockwise to form the left and right parts of the heart.

Constructing the Heart

[code language="css"]
.heart::before,
.heart::after {
background-color: red;
content: "";
height: 80%;
left: 25%;
position: absolute;
top: 2%;
transform: translateZ(0) rotate(-45deg);
width: 50%;
}

.heart::after {
transform: translateZ(0) rotate(45deg);
}
[/code]

Rounded sides are set with two radii values to get an elliptic rather than circular curve, and therefore a more natural heart shape. Because rectangle side lengths have a 5/8 ratio, the ellipsis radii calculate to 50%/37.5% to round off only the corners that don’t overlap.

[code language="css"]
.heart::before,
.heart::after {
border-radius: 50% 50% 0 0 / 37.5% 37.5% 0 0;
}
[/code]

Now what remains is to adjust the transform-origin point for the rectangles so the points line up at the center of the square area where the rectangles do overlap. The same look can be achieved by adjusting the absolute position declarations instead of using the transform-origin approach. But that would later complicate the keyframes code because it would force us to control the position in more detail instead of relying on the transform scale function to do the work for us.

The transform-origin point should be calculated with regards to the coordinate system before any transforms are applied (because transforms can affect the coordinate system, for example, the rotate() function rotates the coordinate system along with the element it is applied to). Again the sides length ratio dictates the position of that point: it is easy to see that the X position is at 50%, at the center of the rectangles, but the Y position is calculated at 68.75% of the rectangle height measured from the top (55*100%/80=68.75%). Going with the specific symmetry approach pays off here too, as both rectangles share the same transform-origin point position.

[code language="css"]
.heart::before,
.heart::after {
transform-origin: 50% 68.75% 0;
}
[/code]

And now we have a beautiful symmetric heart shape. We can add an inset box-shadow, different for each rectangle, to make it all plump and 3D.

[code language="css"]
.heart::before {
box-shadow: -8px -14px 10px 0 black inset;
}

.heart::after {
box-shadow: -15px 10px 14px 0 black inset;
}
[/code]

The Sound of the Heart

To introduce audio into the page, we use the <audio> element with the path to the audio file and without the controls attribute because we don’t want the internal browser audio player to appear (read more in Using HTML5 audio and video on MDN).

[code language="html"]
<audio id="heartbeat" src="heartbeat.mp3" preload="auto">
Your browser does not support the <code>audio</code> element.
</audio>
[/code]

Instead of the controls, we use JavaScript to manipulate the playback. This example uses buttons to start and reset the track, but with a little bit more work we could do without the buttons and start and reset the audio when the heart element is clicked or hovered.

Our sound is the sound of a heartbeat repeated four times and it will serve as the sound our CSS animation will follow.

Flex that Muscle

To make our heart tick, we need to change its shape from original, resting heart, to the state when the muscle is flexed. To flex the heart we scale it down a bit and change its shape with border-radius.

CSS Heart Relaxed and Flexed

Here is how the flexed styles would read if we needed them static, outside of the animation:

Continue reading %Syncing CSS Animations with HTML5 Audio%


by Mihaela Jurkovic via SitePoint

Watch: Getting Started with Grunt

Getting started with GruntJS aims to help simplify some of the concepts that people sometimes have trouble comprehending. Throughout this screencast, I will provide an in depth explanation on the core components of Grunt and take you through the process of configuring a gruntfile from start to completion so that you can truly understand how GruntJS works.

Code sample for this screencast is available on GitHub.

Loading the player...

Continue reading %Watch: Getting Started with Grunt%


by Thomas Greco via SitePoint