Topics Search

Show Symbols in Drop Down Lists

Drop down lists take a range of cells as input and show it as a list. There is not much you can do with how your list looks in the drop down. For example, you can not give a background color or change font color, font type, font size, etc.

How to Lock Cells

Sometimes you may want to lock cells in Excel so that other people can’t make changes to it. It could be to avoid tampering of critical data or prevent people from making changes in the formulas.

How to import Access web app data into an Excel workbook for reporting

This two-step process enables you to import Access web app data into Excel, where you can filter, graph, and analyze it to produce meaningful reports. In this article, I'll show you how to import Access web app data into an Excel workbook where you can then filter, graph, analyze, report, and more. Importing is an easy two-step process, but it's not particularly intuitive. You must first enable a connection for the database. Then, you create the connection in Excel, which allows you to import the data. If you skip the first step, the subsequent import will fail.

Improve your Spreadsheet Experience with these Excel Options

There is no one size that fits all. When it comes to Excel, the default settings work fine in most of the cases. But if need be, you can easily customize many of the Excel Options. In this blog post, I will show you how to use Excel Options to customize your workbooks and get a better spreadsheet experience.

How to Create an Easy Rippled Reflection

One way to create even more drama in an interesting landscape is by adding a digital flood! Not only does it create an aesthetically pleasing symmetry, but it uses one of the classic techniques of photo manipulation, creating a reflection. In this tutorial we will create the effect a reflective water surface complete with rippled distortions.

How to Create an Architectural Drawing From a Photo

Architects are highly skilled professionals who create extraordinary technical drawings of buildings and interior designs. And you can achieve that same professional blueprint look with a Photoshop Action.

Getting Started With Cassandra: Using CQL API and CQLSH

In this first part, I will cover how the Cassandra data model is laid out in brief and perform basic operations using CQLSH. For this tutorial series, I am assuming that readers would be able to install Cassandra by themselves on their respective machines depending on the operating system.

How To Create a Milestone Chart

Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy. And, a milestone chart is a perfect way to track a project in a simple way.

How To Turn On Game Mode

There are tens of ways out there to optimize Windows 10 for gaming. In fact, one can find many free as well as paid software to improve the gaming performance of a Windows PC.

AngularJS Tutorial: Introduction to AngularJS Scopes

By adding the ng-app directive to some HTML tag we specify that an AngularJS will be created and in the process of application creation Angular creates the so-called root scope. Some other directives such as ng-controller create a child scope. To visualize scopes one can use a Google Chrome extension called Batarang. The picture below shows the root scope for the AngularJS application and the child scope created by HelloController, which contains a single variable myModel.

Fix: Printer queue stuck when deleting

The printer queues documents before they’re printed. However, print jobs within the queue can get stuck. When that happens, some users might try manually canceling the document listed in their printer’s print queue. But then Windows might still not delete the selected print job. This is how you can fix a stuck printer job that isn’t deleting within the queue.

How to Increase the Transparency of Windows 10 Start Menu and Taskbar

Windows 10 allows limited control over the transparency of the Taskbar, Action Center, and Start menu. You can make it transparent or solid in Settings. It is a bit transparent by default, but you might want to add a higher level. Here’s a look at how to increase the transparency by hacking the Registry.

How to Setup IP Failover on Ubuntu with KeepAlived

Keepalived is used for IP failover between two servers. Its facilities for load balancing and high-availability to Linux-based infrastructures. It worked on VRRP (Virtual Router Redundancy Protocol) protocol. In this tutorial, we have configured IP failover between two Linux systems running as a load balancer for load balancing and high-availability infrastructures.

Install and configure Jenkins on Ubuntu 16.04

Jenkins is an automation server written in Java, as a fork of the Hudson project. It helps to automate part of the software development process, with aids like continuous integration, but also by further empowering teams to implement the technical part of a Continuous Delivery. Jenkins supports many SCM (Source Control Management) software systems including Git, SVN, and Mercurial and provides hundreds of plugins to automate projects. This tutorial explains how to install and use Jenkins on Ubuntu 16.04 using Apache as server.

How To Create a Single Weight Line Art Logo

In today’s Adobe Illustrator tutorial we’re going to look at creating a stylish single weight line art logo. Even though the entire design is made just using lines, there’s a range of Illustrator tools and techniques we’ll use throughout this tutorial that you can incorporate into your arsenal. This style of illustration is pretty popular with badge style logo designs, particularly those with an outdoors theme with landscape scenes, so that’s the type of design I’ll be making in this guide.

3D Shadows to Add Depth to Text Effect

In this Adobe Photoshop tutorial, we will create a small piece of text and use the Pen Tool to create exact selections and create small custom shadows to transform our gradient text into a 3D ribbon that wraps in and over itself. It’s a cool effect that you’ve just got to see and try for yourself. I hope you enjoy the video!

Excel COUNTIF Formula

In this tutorial we will learn how to work with the Excel’s COUNTIF formula. The Excel COUNTIF formula counts the number of cells inside a range that match the given criteria. The rule of formula; COUNTIF(first as range, second as criteria). In this example we can use COUNTIF to return the number of occurrences for Tom.

Creating a Pareto Chart

In this tutorial, I will show you how to create: A Simple Pareto Chart in Excel. A Dynamic Pareto Chart in Excel. Creating a Pareto Chart in Excel is very easy. All the trickery is hidden in how you arrange the data.

Design Simple Sale banner

You have seen lot of sale banner on many e-commerce websites. The sale / discount banner is the main attarction of any ecommerce website. It attracts user to click on banner and redirect to landing page. Today in this Photoshop Tutorial, You will learn to design simple sale banner.

How to Open Multiple Images in One Document

Photoshop isn’t just a photography app; it’s a powerful design tool. Opening a single image is easy, but what happens if you want to put together a poster with multiple different images? Let’s look at a few of the ways you can open more than one image in a single document.