Monday, July 11, 2016

Smart Auto Typer and Talker

Automate your typing process by creating dedicated shortcuts for the phrases or sentences you are using very frequently with this app.

Irrespective of how fast and accurate you write, there is always room for improvement. In case you want to increase your productivity in the office and get daunting tasks completed in no time, then you should consider an automation tool.

As the name suggests, Smart Auto Typer and Talker is a utility designed to lend you a hand with the typing activities you need to perform on a regular basis.


Simple setup and intuitive interface
Even though it is not overly complicated, the setup entails decompressing the archive and then following the instruction to install the app on your computer. Upon launch, you are welcomed by a minimalistic and clean UI, but that is suitable given the role of the application.
The interface consists of a window that displays the list of shortcuts you created for automating typing or tasks that require talking. In addition to the actual text, you can preview the shortcut, time interval and whether the action is designed for talking or typing from the main window.


Comes with a talker function. but does not let you customize shortcuts
You can create macros or delete the ones you no longer need by accessing the Add or Delete button from the lower area of the UI. You can create a new macro by typing in the desired text and specifying a few details. You should know that the app allows you to use the talker to speak the text, an option that can come in handy when working with videos.
On the other hand, you should know that the app enforces you to use the Control and any other key of your choice to create the macros. It would have been nice if you could set your own hotkey combination so that you can learn the shortcuts faster and be more productive. This is especially important since the app does not come with a Suspend Hotkeys function.
A handy app for automating typing routine tasks
In the eventuality that your line of work entails typing identical information within documents, templates or forms you are managing, then Smart Auto Typer and Talker is a tool that can help you automate and finish tedious activities in no time.

Visit our website:

Save time with Dose for Excel Add-In

“The most popular add-in for Excel users”

Dose for Excel is a powerful, feature-rich add-in for Microsoft Excel, which allows you to quickly perform functions that would otherwise take up much time. The tool integrates with excel and allows you to easily access its features from the command ribbon.

The advantages brought by Dose for Excel are simple and very handy especially for users who often work with Excel. Some features are new to Excel while others are greatly simplified.


The tool is easy to use since it is user friendly, each function or feature has description or (how to use) inside the tool.


Furthermore, you can check all Dose for Excel features here at website with full description and video tutorials.

“A must have for anyone who spends time in Excel”

Worldwide 50,000+ users and 1,200+ organizations use Dosefor Excel.
We truly believe that Dose for Excel is a must in every office. It's guaranteed that more than a few of the tools will be just what you've been looking for to fill the gaps in Excel.


Large collection of Excel editing functions

The advantages brought by Dose for Excel to the spreadsheet editor are simple and very handy especially for users who often work with Excel. Some features are new to Excel while others are greatly simplified.


You can delete custom rows with one mouse click, for instance entire empty lines, rows that contain at least one empty cell or duplicates. Moreover, the tool allows you to remove lines that contain a specific value. The functions are available for current sheet, for the selected sheets or the entire workbook.


The Clear Spaces option allows you to remove leading, trailing, extra spaces or all fields in the sheet.

Cell management made easy

Dose for Excel allows you to merge or split the selected cells, as well as add a background color to each field. The tool also includes data filters, a date picker, as well as a row-to-column converter.


You can easily customize the size of the work area, as well as add or edit comments with the help of the dedicated assistant. For instance, you can display only the comments for the selected cells, display only symbols of the comments or convert them into cells. An additional function is the case changer that allows you to switch words to upper/lower or proper case.


Create backups with one mouse click

Dose for Excel allows you to generate backups with the help of the dedicated function. You can set the tool to automatically backup the data each time you close Excel, or only on demand. The add-in integrates with Excel and creates an individual section in the command ribbon. Moreover, its ease of use makes it convenient for any user.


Visit our website:


Friday, May 13, 2016

Excel test alphanumeric value - VBA




This Excel tutorial explains how to test for an alphanumeric value (step-by-step instructions).

Find the complete steps in the below video link:

 Excel test alphanumeric value - VBA

Excel custom round function - VBA




This video tutorial explains how to create a custom round function (with step-by-step instructions).

Find the complete steps in the below video link:

 Excel custom round function - VBA

Excel Custom average function - VBA




In this video we will look at a program in Excel VBA which creates a User Defined Function that calculates the average of a randomly selected range excluding one or more values that are outliers and shouldn't be averaged.

Find the complete steps in the below video link:

 Excel Custom average function - VBA

Excel Create your first macro - VBA




With Excel VBA you can automate tasks in Excel by writing so called macros. In this video, learn how to create a simple macro which will be executed after clicking on a command button. First, turn on the Developer tab.

Find the complete steps in the below video link:

 Excel Create your first macro - VBA

Excel conditional formatting - highlight values using rules



To view all conditional formatting rules in a workbook, use the Conditional Formatting Rules Manager. You can also use this screen to create, edit and delete rules.

Find the complete steps in the below video link:

 Excel conditional formatting - highlight values using rules

Excel Drop Down List - combo box




Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

Find the complete steps in the below video link:

 Excel Drop Down List - combo box

Excel Create Chart (graph) for your table data



Excel Create Chart (graph) for your table data

Find the complete steps in the below video link:

 Excel Create Chart (graph) for your table data

Excel Hello World messege - VBA create macro




The MsgBox function in Excel VBA can return a result while a simple MsgBox cannot.

Find the complete steps in the below video link:

 Excel Hello World messege - VBA create macro

Excel Swap Values - VBA macro



This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs as we will see later.

Find the complete steps in the below video link:

 Excel Swap Values - VBA macro

Excel Run Code From Module using macro - VBA


As a beginner to Excel VBA, you might find it difficult to decide where to put your VBA code. The Create a Macro chapter illustrates how to run code by clicking on a command button. This example teaches you how to run code from a module.

Find the complete steps in the below video link:

 Excel Run Code From Module using macro - VBA

Excel Macro Recorder - VBA record macro




The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button. The Macro Recorder is also a great help when you don't know how to program a specific task in Excel VBA. Simply open the Visual Basic Editor after recording the task to see how it can be programmed.

Find the complete steps in the below video link:

 Excel Macro Recorder - VBA record macro

Excel Recording in Relative Mode - VBA




By default, Excel records macros in absolute mode. However, sometimes it is useful to record macros in relative mode. This program teaches you how to do this. If you don't know how to record a macro, we highly recommend you to view this video first.

Find the complete steps in the below video link:


 Excel Recording in Relative Mode - VBA

Excel Fibonacci Sequence - How to create sequence




It's easy to create all sorts of sequences in Excel. For example, the Fibonacci sequence.

Find the complete steps in the below video link:

 Excel Fibonacci Sequence - How to create sequence

Excel Custom Lists - How to create custom list




If you create a custom list in Excel, you can easily fill a range with your own list of departments, clients, cities, credit card numbers, etc. This can save time and reduce errors.

Find the complete steps in the below video link:

 Excel Custom Lists - How to create custom list

Excel Comments Insert Hide Edit Show Delete Change User Name - Comments


Excel Comments Insert Hide Edit Show Delete Change User Name - Comments

Find the complete steps in the below video link:

 Excel Comments Insert Hide Edit Show Delete Change User Name - Comments

Excel Copy Paste Skip Blanks - How to Paste only values without blanks




Use the 'Paste Special Skip Blanks' option and Excel will not overwrite existing values with blanks.

Find the complete steps in the below video link:

 Excel Copy Paste Skip Blanks - How to Paste only values without blanks

Excel Union and Intersect - example sum ranges or intersection




This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.

Find the complete steps in the below video link:

 Excel Union and Intersect - example sum ranges or intersection

Excel Names in Formulas - named range and named constant




Create a named range or a named constant and use these names in your formulas. This way you can make your formulas easier to understand.

Find the complete steps in the below video link:

 Excel Names in Formulas - named range and named constant

Excel Dynamic Named Range - how to create Dynamic Named Range




Excel Dynamic Named Range - how to create Dynamic Named Range

A dynamic named range expands automatically when you add a value to the range.

Find the complete steps in the below video link:

 Excel Dynamic Named Range - how to create Dynamic Named Range


Excel Paste Options Special - Values Formulas Formatting Skip Blanks Transpose


Excel Paste Options Special - Values Formulas Formatting Skip Blanks Transpose.

Find the complete steps in the below video link:

 Excel Paste Options Special - Values Formulas Formatting Skip Blanks Transpose

Excel Status Bar - how to add count average max and min in status bar




The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar.

Find the complete steps in the below video link:

 Excel Status Bar - how to add count average max and min in status bar

Excel Quick Operations - how to use paste special for multiply divide subtract add


Use the 'Paste Special Operations' to quickly perform operations on a range of cells in Excel.

Find the complete steps in the below video link:

 Excel Quick Operations - how to use paste special for multiply divide subtract add

Excel Calendar - how to create auto calendar for each year




This example describes how to create a 2016 calendar in Excel (or 2017 calendar, 2018 calendar, etc). If you are in a hurry, simply download the Excel file.

Find the complete steps in the below video link:

Excel Calendar - how to create auto calendar for each year

Excel Zoom - how to zoom using status bar - custom zoom - selection zoom




In most cases, you can use the minus and plus symbols in the status bar to quickly zoom the document. Use the buttons on the View tab to zoom to a specific percentage and to zoom to a selection.

Find the complete steps in the below video link:

 Excel Zoom - how to zoom using status bar - custom zoom - selection zoom

Excel Split worksheet panes - how to split worksheet into 4 panes




Split your worksheet to view multiple distant parts of your worksheet at once.

Find the complete steps in the below video link:

 Excel Split worksheet panes - how to split worksheet into 4 panes

Excel Group Worksheets - how to group similar worksheets to edit at same time


You can group worksheets in Excel if you want to edit multiple worksheets at the same time. Our workbook contains 3 similar worksheets (North, Mid and South) and a blank fourth worksheet.

Find the complete steps in the below video link:

 Excel Group Worksheets - how to group similar worksheets to edit at same time

Excel Consolidate - how to use Consolidate worksheets into one worksheet




You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. Below you can find the workbooks of three districts.

Find the complete steps in the below video link:

 Excel Consolidate - how to use Consolidate worksheets into one worksheet

Excel Spelling - how to use Spelling add to dictionary - autocorrect - ignore - change




Learn how to check the spelling of text in Excel. You can also add words to your custom dictionary or AutoCorrect list.

Find the complete steps in the below video link:


 Excel Spelling - how to use Spelling add to dictionary - autocorrect - ignore - change

Excel Advanced Find Features - how to use advanced find features




Excel Advanced Find Features - how to use advanced find features Like match case, 
match entire cell contents, within workbook, ? one character, * series of zero or more characters.

Find the complete steps in the below video link:


 Excel Advanced Find Features - how to use advanced find features

Excel Delete Blank Rows - how to Delete Blank Rows




This example teaches you how to delete blank rows or rows that contain blank cells.

Find the complete steps in the below video link:


 Excel Delete Blank Rows - how to Delete Blank Rows

Excel Row Differences - how to detect row differences




This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row.

Find the complete steps in the below video link:

 Excel Row Differences - how to detect row differences

Excel Copy Visible Cells Only - how to Copy Visible Cells Only




By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only.

Find the complete steps in the below video link:

 Excel Copy Visible Cells Only - how to Copy Visible Cells Only

Excel Budget - Create your own budget sheet




This example shows you how to create a budget in Excel.

Find the complete steps in the below video link:

 Excel Budget - Create your own budget sheet

Excel Meal Planner - how to create meal planner




This article shows you how to create a meal planner in Excel.

Find the complete steps in the below video link:

 Excel Meal Planner - how to create meal planner

Excel Invoice - how to create invoice template




This article describes how to create a simple invoice in Excel.

Find the complete steps in the below video link:

 Excel Invoice - how to create invoice template

Excel Automated Invoice - how to create Automated Invoice




This article describes how to automate the generation of invoices in Excel. If you are in a hurry, simply download the Excel file.

Find the complete steps in the below video link:

 Excel Automated Invoice - how to create Automated Invoice

Excel Reject Invalid Dates - how to Reject Invalid Dates using data validation


This example teaches you how to use data validation to reject invalid dates.

Find the complete steps in the below video link:

 Excel Reject Invalid Dates - how to Reject Invalid Dates using data validation

Excel Prevent Duplicate Entries - how to Prevent Duplicate Entries




This example teaches you how to use data validation to prevent users from 
entering duplicate values.

Find the complete steps in the below video link:

 Excel Prevent Duplicate Entries - how to Prevent Duplicate Entries

Excel Product Codes - how to prevent entering wrong product codes




This example teaches you how to use data validation to prevent users from entering incorrect product codes.

Find the complete steps in the below video link:

 Excel Product Codes - how to prevent entering wrong product codes