Our Microsoft Excel and Microsoft Excel VBA Webinar
training is broadcast live and is taught "hands-on".
We can broadcast our Excel Training anywhere in the
world at any time. We can also use our webinars for
your company onsite training. Call us for more details at 1.805.498.7162.
Our Microsoft Excel Seminar and Microsoft Excel VBA
Seminar training is taught "hands-on" and is also
broadcast live as a webinar. Our workshops are never
canned and are adjusted to our customers training needs
Our Microsoft Excel and Microsoft Excel VBA Company
Onsite training is customized for our customers
particular Microsoft Excel needs. They are taught
"hands-on" and can also be broadcast live as a webinar
anywhere at any time.
View all of our Microsoft Excel training and Microsoft
Excel VBA training offerings. Our workshops are
presented as hands-on public seminars or can be
broadcast live as a webinar to anywhere in the world.
View all of our Microsoft Excel and
Microsoft Excel VBA self-study manuals. Our self-study
manuals are derived from our almost twenty years of
Microsoft Excel training and software design experiences.
View the skill levels required for all of our Microsoft
Excel training and Microsoft Excel VBA training. All of
our Excel training is customized to our customers needs
in class so you do not need to be an expert to take it.
creates award wining software in Microsoft
Excel for NASA, The US NAVY, Caterpillar, Time Warner Cable and Northrup Grumman.
We can build just about anything in Microsoft Excel,
but we specialize in advanced modeling, visual interfaces, data processing (data mining), report generation and dashboard construction.
The harder the challenge, the happier we are. We love producing a solution when other companies said it could not be done.
For example, our award for helping design the
Mars Rover software in
Over the years, we have pushed Microsoft Excel software design
to its limits providing tools for business, engineering and science related tasks.
Along this journey, we have also realized that Microsoft Excel macros coupled with
other design tools like Visual Basic .NET, Web ASP,
Microsoft PowerPoint allowed hybrid tools to be developed that were quick in design yet more
powerful than using just Microsoft Excel macros alone. The idea is to use each environment's
strengths and making them act as one seamless tool. At EMAGENIT,
we do all of our programming in
the US which means your proprietary information remains secure. We work continuously with
businesses as well as the technical communities and we provide a life long guarantee so if
something goes wrong down the road, we will always fix it.
To learn more about our software
design click here.
"Imagine-It", we specialize in Microsoft Excel training and
Microsoft Excel VBA training.
We have been providing
Microsoft Excel training since 1998. We offer a wide variety
of Microsoft Excel training and Microsoft Excel VBA training
workshops that take you from the beginning to the most
advanced Excel power use. Our training experience includes
companies and organizations like Time Warner, NASA JPL,
Caterpillar, USDA, AMGEN, BMW, Lockheed, The US Air Force
and The US Navy.
At EMAGENIT, we have been personalizing our training and
problem solving since our very first day of business. Our
innovative style of teaching provides you with the best
hands on training in the industry. You will be amazed at how
much you can learn in such a short amount of time. Our
training programs are taught onsite at your workplace,
through a live broadcast webinar you can come to one of our
public workshops. Anytime you take a course from us, you can
come back any time and retake it free, an exceptional value
(free repeat details).
To learn more about EMAGENIT click
Our Microsoft Excel Add-Ins
have been redesigned and improved to tackle your rogue data and
repetitive task Excel problems.
Microsoft Excel Add-Ins are designed to tackle the tough
data problems and repetitive tasks that you encounter in
Microsoft Excel. From automatically time stamping
worksheets, to comparing different tables, to cleaning
data so it can be used effectively on worksheets, they
have you covered. If you have an idea after reading about our add-ins,
click on the suggestion link and fill out the form. If we
can use your idea, you get a free version of the software
for as long as we make them. To view our list of Excel
Microsoft Excel tip of the week provides useful information that lets you work easier.
How to Clean Your Excel Text Data
When comparing text in different tables, looking for headers in a row and
various other text tasks in Microsoft Excel, your data has to be
(uncorrupted) in order to work with.
Microsoft Excel's various worksheet functions like
SUMIF... depend upon your
data having consistent characters. Just a tip, consistency
in names is the number one killer in databases especially
with multiple databases. The three heavy hitters that mess up your data are non-printable ASCIIs,
spaces and rogue characters that are not supposed to be there
like */().,- and so forth. There are three Microsoft Excel worksheet functions
that can be used to deal with these problems. They are
gets rid of the non-printable ASCIIs.
Non-printable ASCIIs occur after text in cells when converting text between different computer languages,
operating systems and with programs that purposely output
corrupted tables so you cannot move their data. They range between 0-31 of the
ASCII table, you
cannot see them, but they are there. When developing data
crunching software for our customers, we encounter them
about 60% of the time at some point in the project. The TRIM
function removes leading and trailing edge spaces around
text and standardizes the spacing between text to one space.
Spaces by the way are the number one killer for a data
program so beware of them as they effect everything text
especially downloaded tables from databases. Substitute will
get rid of any character in a piece of text without having
to know its location which is a royal pain to figure out.
You could use REPLACE but that requires you to know the
position and number of characters which again is a royal
pain. And if you cannot type the text in SUBSTITUTE to
lookup, then use the CHAR function and the appropriate ASCII
number for its second argument to generate the character that it needs.
For example, you cannot type in " between two "" but you
could use CHAR(34) to generate it.
Also with SUBSTITUTE, it is case sensitive so use LOWER to
lower case your text being analyzed so you do not miss
anything. UPPER and PROPER can be used to return the text
back to its original format once the operation is completed. So here they are the way we use them, if you think you have
a corrupted column of data or row, insert a blank one right
next it, run these functions to clean the data, then do a
paste special and copy and paste the values back over the
originals and get rid of the extra column you just made. By
the way, keep
nesting the SUBSITUTE function for each rogue character
you want to get rid of. You must know your data in order for
you to get rid of the right characters. Also there are many
variations of using these functions together.
||=PROPER( SUBSTITUTE( LOWER( A2
) , "/" , "" ) )
||=TRIM( CLEAN(A4) )
||SUBSTITUTE( SUBSTITUTE( A5
, "/" , "" ) ) , "*" , "")
SUBSTITUTE, TRIM and CLEAN Formula Examples
To learn more about capabilities like these, check
out our Intermediate
Microsoft Excel workshop.
To view our Tip of the Week log
Microsoft Excel Resources page provides useful
information and tips about Microsoft Excel.
It discusses basic Excel operations like writing formulas,
running worksheet functions, typing data and using worksheets. Also discussed is how to use our favorite
worksheet functions in real life situations and the syntax behind writing them in formulas. Our resources page also discusses
why you want to use Excel VBA (macros) in Excel and the basics behind its operation.
To view our resources page click
Site Map Mobile Site
Copyright © 2002-2015
EMAGENIT All Rights Reserved