Topics Search

Newest Tutorials


How to Add Up a Column or Row With Shortcut keys

In this Quick Tip video I will show you how to increase your productivity by quickly adding up a column or row of data using shortcut keys. Microsoft's Excel for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a basic spreadsheet. She covers how to format cells, enter data, autofill, basic formulas and absolute referencing which will get you started quickly.

Explore REST APIs in OpenCart 2.0: Part Two

Tutorial preview or category icon
In this series, we're discussing the REST APIs in OpenCart. In the first part, we went through the setup of API user credentials from the back-end. In this part, we'll extend it and go through the rest of the examples, showing how to set shipping, payment and customer related data in the cart. Finally, we'll conclude the article by placing an order!

Connect Excel Pivot to a Power BI Desktop

With DAX Studio you can write DAX Querry against a SSAS Tabular, a Power Pivot Model or an instance of Power BI Desktop. Some time ago I opened DAX Studio for doing some querying in DAX against a Power BI Desktop instance.

Device.js: Conditional CSS Scripts

Device.js makes it easy to write conditional CSS and/or JavaScript based on device operating system, orientation, and type, the script updates thesection with the appropriate classes based on the device’s characteristics.

Block programs from loading untrusted fonts

Microsoft implemented a new security feature in Windows 10's November update build that added an option to the operating system to block the loading of untrusted fonts. The use of fonts has always been problematic in the Windows operating system from a security point of view as bugs in font-handling code could give attackers high-level privileges.

JavaScript Unit Test Code Coverage Using NodeJS

The main tools we will be using to pull this off are Karma and Istanbul. The test we write will be using Jasmine. If you don’t use Visual Studio, you should still be able to adapt these instructions to your own environment. I’ve found getting Istanbul setup kind of tricky at times. Since everything I’m going to show you here is pure Node.JS, you can ignore the Visual Studio parts.

WordPress: Is the New Desktop App for You?

Tutorial preview or category icon
Now and then, Jetpack by Automattic is dug out, and new features are added. While you can think whatever you want about Jetpack, you cannot deny that some features are very useful. A brand-new feature is the WordPress desktop app, which can be used for every WordPress website that has Jetpack activated. Today, we’ll take a look at this app together, and decide if and which advantages it offers.

Angular 2: Conditionally add styles to an element

Learn how to conditionally add styles to a DOM element in Angular 2. Here we're going through a couple of ways to conditionally apply some styles to a DOM element in Angular 2. A rather unconventional way would be to return the styling property as a string and then to directly set it on the desired element...

Activate Your Windows 10 License via Microsoft Chat Support

Microsoft still includes product activation in Windows 10 to prevent piracy. Windows 10 includes a new convenient chat option for product activation. If you upgrade from an activated Windows 7 or from Windows 8.1, Windows 10 will automatically activate. If you’re transferring a Windows 10 license to a new computer and have an Internet connection, you can use chat support to activate it.

Action Cable and WebSockets: An in-Depth Tutorial

One of the highly anticipated feature of Rails 5 is the official solution for integrating web socket communication with Rails, dubbed Action Cable. HTTP has been around for quiet a while and, obviously, is the most ubiquitous protocol for communication between the browser and the server. In a typical browser HTTP request, the browser asks the server for a single HTML, Javascript, or CSS document. Afterwards, the connection is closed and if the browser needs additional resources, it is the job of the browser to initiate the conversation again.

Generating PDFs from html and snappy in CakePHP 3

Tutorial preview or category icon
In previous tutorial, we have learned how to generate PDFs from html and snappy. In this tutorial, we will use the same approach, but apply it in CakePHP 3 framework. This tactic will enable the CakePHP controllers of your application to generate PDFs with a few lines of code.

How to get first and last character of String

You can get the first and last character of a String using charAt() method in Java. This method accepts an integer index and returns the corresponding character from String. Since Java String is backed by an array, their index is also zero-based, which means the first character resides at index zero and the last character is at index, length-1, where length is the number of characters in the String. You can get the length of String by calling the length() method.

Docker Compose Environment Variable Binding Examples

Docker Compose Environment Variable Binding Examples - Java, Node.Js, PHP, Python, And Ruby On Rails. The platform however provides core (optional) enhancements to Docker Compose supporting advanced plug-ins with lifecycle stages to handle service discovery use cases. It also supports cross-image environment variable bindings, automatic container IP retrieval and injection, and additional parameters like mem_min, publish_all, cluster_size, host, and registry_id. The service discovery framework takes care of re-configuring the load balancers and other application components when a cluster is scaled in/out or when the containers are stopped/started.

How to customize the properties of your Windows taskbar

Microsoft made some great improvements in the taskbar with Windows 7, making it much more versatile and useful than the taskbar in previous Windows versions. Although there weren't nearly as many changes between Windows 7 and Windows 8.1, because they got it so nearly right the first time, there are a few things that have changed in Windows 8.1 and there are even more in Windows 10. One of the major improvements in the taskbar is in the way it can be customized. Since most people work more productively when their tools are arranged according to their own preferences...

Adding Social Sharing in a Node.js Single-Page Application

Beyond search, other web crawlers are important to your site’s visibility—namely rich social-sharing robots that rely on meta tags are still blind to JavaScript. In this tutorial, we will build an alternate route and rendering module for your Express and Node.js server that you can use with most SPA frameworks and that will enable your site to have rich sharing on Twitter, Facebook and Pinterest.

Foundation 6: The New Flex Grid

Arguably one of the best parts of Foundation is the grid system. This system is the backbone of Foundation’s responsive design and gives you the flexibility to build anything from a simple two-column layout to a multi-level deep, intricate behemoth. The grid is based on a responsive float system, with rows, columns, offsets, clearing (the standard elements you see across several frameworks). It’s worked great and overall is a great way to get up and running quickly with your designs, catering to the various device sizes and adapting your UI accordingly.

Populate (Bind) Repeater control using Stored Procedure

In this article I will explain with an example, how to populate (bind) Repeater control using Stored Procedure in ASP.Net using C# and VB.Net. Repeater will be populated using Stored Procedure in SQL Server database and will be displayed as HTML table on the page.

Try deep linking, a powerful way to customize Windows 10's Start menu

Pin all kinds of specific app content to Windows 10's Start menu, not just an app's home screen. You haven’t customized the bejesus out of Windows 10’s Start menu unless you’ve done deep linking. Sure, you’ve rearranged the left side of Windows 10’s Start menu, gotten your tiles just the way you like them on the right, and even added some website shortcuts to the mix. But with deep linking you can pin specific pages from within a Windows Store app to your Start menu.

How to Quickly Insert Blocks of Text in Microsoft Word with AutoText

We all have a few large chunks of text we have to type regularly–like your address, long names or phrases, or even tables and images you use often. The AutoText feature in Word allows you to store these chunks of text and quickly insert them with a few keystrokes, so you can waste less time typing. The AutoText feature has been part of Office for a long time, but is now part of Quick Parts, which was added to Office 2007. In addition to AutoText entries, the Quick Parts feature allows you to insert document properties (such as title and author) and fields (such as dates and page numbers).

How to Install Redmine 3 with Nginx on Ubuntu

Redmine is an open source project management and issue tracking tool based on the Ruby on Rails Framework. It is web-based, so you can use it from any client platform that provides a web browser. It is well suited for multi-language teams as it contains translations for 42 languages. You can track multiple projects in one installation, it has an integrated support for news, document management, file management, a support wiki. You can connect it with other applications by LDAP authentication and the REST API. This tutorial covers the Redmine 3 installation with Nginx as the web server and MySQL as the database on Ubuntu 15.10 (64 Bit) operating system.