Tuesday, November 4, 2025
Home Blog Page 214

How to Write a Custom Function in Microsoft Excel

how to create custom excel function

Microsoft products have always included Visual Basic. You can use it in Microsoft Word, Access, and Excel. One reason this is true is that Bill Gates and some of his friends wrote Visual Basic while Gates was still at Harvard.  Thus, he felt proud of his accomplishment and wanted to keep it. Gates wrote the floating point arithmetic part of the language. You can use it to create custom functions in Excel.

How to Change Android Camera Settings

how to change android camera settings

People hardly need to buy cameras anymore as cell phones come with quite good quality cameras. People who are experts at photography can buy cameras, but the rest of us can use our cell phones. They are far less complicated than advanced cameras.  Lots of people buy fancy cameras and never learn to use all their features. Why should you bother to learn, unless you plan to study photography? Here is how to change some of the settings on the Android camera to improve the photos you take.

 

How Do I Use My iPhone with One Hand Through Reachability

Apple’s latest phones, the iPhone 6 and the iPhone 6 Plus, are on the bigger-screen side of the phone-size spectrum. While devices with bigger screens provide users with many advantages, most will agree that one of the disadvantages of having a large screen is its one-handed usability. One will have a hard time handling and using a phone with a large screen with only one hand. This is a problem with the iPhone 6 and especially the iPhone 6 Plus.

How Do I Force the Play Store to Ask for My Password for Every Purchase?

By default, after you sign in on a device, the Google Play Store only asks for your account password the first time you make a purchase and allows you to make purchases for 30 minutes without re-entering your password. While this feature is helpful when you buy apps in bulk since you do not have to re-type your password every time you buy an app, it could potentially lead to several unauthorized purchases if someone else uses your phone within that 30-minute time frame. Here is how you can prevent this from happening.

Create Citations, Endnotes, and Footnotes in Microsoft Word 2013

how to create a footnote in word

Citations, footnotes, and endnotes are important for academic writing.  Microsoft Word 2013 generates these items for the writer automatically. It can also make a table of figures and an index.  It would take much effort to do this manually, which is what publishers did for many years. Here is how to make a citation, footnote, and an endnote.

How Do I Merge Contacts on My iPhone?

If you have several contact entries in your iPhone’s address book that point to the same person, follow this tutorial to merge them into one entry to keep your contact list organized.

Google Sheets: How to Work with Dates

do date math with google sheets

You can use some basic date functions in Google Sheets to work with dates and use date math. Dates in spreadsheets are numbers, which means you can add and subtract them.  Do not think of them as strings of text such as “10 January 2015.” If you treat dates as strings of text, then using date math would be very complicated as you would have to isolate different parts of the date, convert that to a number, add or subtract from the number, and then convert it back to text. It is much easier to work just with dates as numbers and then use the formatting feature in Google Sheets to display the dates as you want them.

How Do I Activate the Camera Flash for Incoming Calls or Messages on My Samsung Phone?

The flash on your Samsung phone’s camera can be used as a notification indicator. When you have a call or an incoming message, the phone’s camera light blinks a few times. This feature can be helpful, especially when your phone is in silent mode. However, it is turned off by default. Here is how to turn it on.

How to Take Screen Shots and Edit Them with Gimp on Ubuntu

ubuntu take screenshot

With Ubuntu, you can use (-print-screen-) to take a screen shot and then use Gimp to crop it. The problem is that Gimp is not always easy to use. Part of the reason for this is working with a graphics editor is difficult if you have no knowledge of graphic design. Most of us do not, so how do you take a screen shot on Ubuntu and then crop the section you want? Here’s how it is done.

How Do I Take Notes During Calls on My Samsung Phone?

You have probably had moments when you are on your phone and need to jot down important information for later use. While you can write it on a piece of paper (if you have one nearby), using the default memo app that comes with your Samsung phone’s software is a better option. By using the app, the note is attached to the contact, so you will see it on-screen every time you call him or her. Furthermore, you no longer need to carry notes on paper with you or worry about losing them. Learn how to use the note feature during phone calls in this tutorial.

How Do I Add a Page-Based Interface to My Apple Watch App?

A page-based interface in an app is useful for displaying non-hierarchical content. If your iOS app includes a page-based interface, it makes sense to use the same interface in your Apple Watch app. Read on to find out how to do it in Xcode.

How Do I Change an Object’s Attribute Based on Apple Watch’s Screen Resolution?

The Apple Watch comes in two different sizes: 42 mm and 38 mm. With very limited screen space, apps must be designed carefully so that users can use them easily even on such a small screen. Developers who make apps for the watch can make adjustments according to the size and provide users with the best app version. Here is how to do it.

Stay Connected

16,985FansLike
2,458FollowersFollow
61,453SubscribersSubscribe

Latest Articles

Latest Reviews

Latest Comments

error: Content is protected !!