How To’s - Computer Programs
 
How To... Use Microsoft Excel For Work

Contributed By aprile


Master the many uses of using Excel for work, and you will shine as the office’s number guru!


Microsoft Excel is a crazy powerful spreadsheet program that you can use for just about anything.  That’s why folks from Timbuktu to down the street use it every day in their offices.  Master the ins and outs of Excel and you will shine as the office’s number guru!

 

Spreadsheets - You’re faced with a bunch of numbers your boss wants you to make sense of, don’t panic!  Just open up MS Excel, and start.  With Excel you can create all kinds of functional and creative spreadsheets.  Spreadsheets can be as big or as small as you need them to be with the capability of using up to 1 million rows and 16,000 columns.  Now that is a mondo-spreadsheet! 

 

If you have an enormous amount of data to input, you can either do it manually or Import data from other documents.  Each cell of a spreadsheet is easily formatted for text or numbers.  You can turn ordinary numbers into currency, dates, percentages and more just from the selecting them in Format.  Also plug Formulas into specific cell areas to do calculations with ease, and there’s even a Formula Auto Complete function that clues you in on these intimidating calculations. 

 

Want color?  Need some style?  Use the Style Gallery to select a pre-formatted style, or customize to your heart’s content.  You can even produce charts and graphs with 3-D effects to make your reports really eye-catching.  Excel even lets you create charts and graphs from Word and Access files. 

 

More - You can really impress the boss when you remember to be creative with Excel.  Every spreadsheet can have a use.  Here’s a list of just a few:

 

Budgets

Calendars

Expense Reports

Forms

Inventories

Labels

Lists

Reports

Schedules

Statements

Time Sheets

... more »
By kathrynpless

How To... Use Microsoft Powerpoint For Work
This isn't a tutorial on how to use Power Point, but rather how to use it for work. Master the many uses of Powerpoint to impress your boss, colleagues and clients.

Presentations - Microsoft Powerpoint gives you the tools you need to create lively and seamless presentations. Presentations of what you ask?  You name it. Add life to budgets, department timelines or set up merchandising plans. Strategy sessions take on a new life with Powerpoint and make your ideas vibrant and exciting.  If you need to make an announcement that catches everyone’s attention, a sharp presentation can make it pop.  No more boring reports.  Help your boss and colleagues or clients see your vision.  Even monthly statements can be given a shot of life using Powerpoint.  Instead of boring old spreadsheets, dazzle them with a live information right before their eyes.  And don’t forget whenever you’re stuck with a format, you can always experiment with Powerpoint Templates you can find online.

Set up a Groove workspace and edit and create with your team in real time.  Collectively work on budgets, set dates on calendars, create timelines for projects, hold training sessions with teams without even leaving your desk.  Now you’re cooking with gas, well maybe not gas, but with creativity at least.  Creativity that will increase your productivity and help you to achieve your goals.  

More – Impress everybody at work by remembering to be creative with Power Point. And ultimately, every presentation can have a use.  Here’s a list of just a few ideas you can use PowerPoint for:

Budgets
Calendars
Timelines
Strategies
Plans
Merchandising
Reports
Schedules
Trainings
Statements
Announcements
Product Showcase
Info Sessions

Graphics, format, animation and many other features available let you direct the action of the information you are presenting, which will always set you apart from the herd.

... more »
By kathrynpless

How To... Use Microsoft Access For Work

This isn’t an instructional lesson on how to use MS Access, but rather how to learn to use it for work.


Information is gold in today’s workforce.  Keep all your info at work safe with Microsoft Access.  With Access you will be able to store and manipulate data to your heart’s content.  Use the basic Access Database to input Names, Addresses, Phone Numbers, Account Information and other valuable data.  From there you have the freedom to generate reports, mail merges and tables with specific fields tailored to your needs through easy-to-use queries. Plus it has the tools built in to help you create relevant groupings in queries so that all data is clear and up-to-date.


Reports Create stunning Reports chock full of information.  MS Access gives you the advantage of seeing what your report will look like while you work on it.  Run a Query and pluck out exactly the data you need easily.  Analyze trends, forecast marketing strategies and group information for clarity.  You can design your own report and put your personal style on it or use one of the many Access Templates.


Mail Merges MS Access can save you hours of work.  Instead of being a painful chore, Mail Merges for mass mailings becomes a breeze.  Compose your letter in Microsoft Word, and then set up Fields (name, address, etc) to mesh with a query.  Then, push the enter key and like magic, well written and personalized letters come pouring out of your printer.  You can update the data in Access and print out letters as you need them or when a client’s information changes.


Tables MS Access is also compatible with Microsoft Excel.  Transform a query or report into useful Spreadsheets.  This capability is a life saver when you are faced with time constraints.  Once you set up your Database you can Import information from Excel or Export it from Access.  This feature lets you create Budgets, Inventories, Market Trends, and more, with ease.  You can even work in real time with your team with Windows Sharepoint Services.


Learn the ropes with this program.  By keeping the integrity of your work-related information in tact, you’ll become a valued go-to expert for data extraction and manipulation.
... more »
By kathrynpless

How To... Use Microsoft Outlook For Work

This is not an instructional on how to use or setup your Microsoft Outlook Mail.  Rather, how you can use this huge program for work.  Networking, Scheduling, Lists and Organization of everything in between.

Mail – Of course, you can have your ho-hum Outlook mail Inbox.  But then you can have your super tricked out InboxFolders (to organize your emails), Email Rules (to force all incoming emails to go straight to wherever you want), Flags (to mark an email as priority or complete), Categories (also to organize your emails), and color tags (for more email organization, and email decoration).  Put these all together and your Inbox will be a well-oiled machine.  Quick to find what you’re looking for, marked with priorities and less overwhelming.

Calendar – This is easy.  Simply create new Appointments and Meetings, and your calendar populates beautifully.  You can even create multiple calendars to distinguish different schedules  - i.e. your work schedule versus a project schedule or a production timeline schedule.  Here you can invite attendees (even straight from your Contacts), and color code items for a better visual organization of all appointments.

Tasks – Tasks are genius!  I mean, talk about saving your life at work.  You can use this particular section as if it’s a giant, digital To-Do ListCreate Tasks and assign them to be due daily, or every Monday, etc, and poof!  Every time you are behind, a little task notification pops up to remind you to, “Pick Up Collections” or whatever it is that you input.   The best thing about them is you can set up recurrences as often as they are needed.  I myself have had over 100 tasks running at a time to keep me on track at work.

Contacts – Another brilliant addition.  Never forget anyone’s information, name or face again.  Yes.  You can even put pictures in these bad boys.   Microsoft Outlook creates an incredible database for you to utilize with every single contact.  Just select New Contact, and go from there.  Name, Business Number, Mobile Number, Email, Fax, Address, Website, Profession, Department, Title, Photo ID, Birthday, Assistant, Notes, are all input fields to be used.  And there are more!  Plus you can Import and Export this list whenever necessary.  Then you can even put Categories and Color Tags to each contact.  Extreme organization of your people network achieved!

Notes – Easy breezy stuff.  Create a new note, color code or categorize it, and that’s it.  The note automatically saves and is always there for an additional reference. 

Ok so now you get it.  Outlook is way more than an email inbox.  So start playing around and pressing buttons. It will give you an edge with all of your information at work.  Very important.

... more »
By aprile

First Previous Next Last
Showing 1 - 4 of 4 Articles