|
|
Articles related to "Microsoft Excel"
Changing Cell Color w/VBA in Excel This article covers a useful technique for changing cell properties in a range based on the contents of each cell. microsoft excel • vba • vb • visual basic • applications
Copy and Paste in Microsoft Excel Instructions and tips on using the cut, copy and paste functions in Excel, and using absolute and relative references. excel commands • difference between cut and copy • paste special • absolute references • errors in copying in excel
Create Your First Spreadsheet Now that you know some of the basics, create your first spreadsheet, then you will be on your way to becoming a spreadsheet master. computer software • microsoft • excel • spreadsheets • worksheet
Elements of a Spreadsheet Spreadsheets have many different elements becoming familiar with them is as important as any other task that a user can perform. This article shows more basic essentials. excel • microsoft excel • spreadsheets • worksheets • format
Excel creates mailing list Microsoft Excel software allows you to create a mailing list, update and sort it without having to know Excel in depth. Beginners can follow this free online tutorial. free online tutorial • microsoft excel • microsoft excel software • computer software • computer software training
Learn to Use Subtotals in Microsoft Excel Using the Subtotals command in Excel to save time and produce accurate workbooks. how do you use subtotals in excel • easy ways to design spreadsheets • help with microsoft excel • my spreadsheet doesn’t work right • subtotals don’t work
Learning Microsoft Excel Menu Bar Commands An explanation of several Microsoft Excel commands to improve spreadsheet design and performance. advanced spreadsheet commands • spreadsheet trial and error • microsoft excel commands • building fancy spreadsheets • using goal seek in excel
MS Visual Basic for Applications Using VBA with Office tools, theory of VB and VBA, and an up to date list of resources available on Suite 101. vba • vb • ms • microsoft • excel
Starting with VBA for MS Excel Decision based calculations are often at the core of many programming tasks. Combining Excel and Visual Basic for Applications can help to build efficient solutions. microsoft excel • vba • vb • visual basic • applications
The Arranging Windows Function in Excel Excel is packed with features that enable power users to get things done faster and more accurately. Using Window features can help anyone get the most out of Excel. microsoft excel features • windows in excel • freezing panes • split windows • arranging windows
Time Saving Microsoft Excel Tips The following tips will demonstrate little known time savers that will increase productivity as you use Excel. microsoft excel • excel class • time saver • personalize excel • excel productivity
Using Microsoft Excel in Knitwear Design Technology already available on most PCs can prove very useful when graphing hand knit designs. knitting help • knitwear design • use of excel • formatting cells • proportional graph paper
Using Yahoo! Financial Stock Quotes Yahoo! Financial stock quotes are free, on-line and can be accessed either via the Yahoo! web site or downloaded into Microsoft Excel or OpenOffice.org Calc yahoo! finance stock quotes • personal finance • microsoft excel • openoffice.org • writting macros
Personal Budget Income Categories for Excel Need help starting a personal budget without the help of expensive budgeting tools? Here are ideas for income budget categories for Microsoft Excel budget spreadsheets. personal budget • budgeting software • income categories • budget categories • microsoft excel budget spreadsheets
U3 Smart Drives 101 This article provides an overview of U3 smart drive technology u3 smart drives • u3 smart drive • what is a u3 smart drive • u3 smart drives 101 • removable storabe
An Introduction to Google Finance Google Finance is still in Beta mode, but it's an excellent source of finacial data. This article shows how programmers and analysts can access that on-line and free data google finance • stock quotes • download financial data • programming with financial data • microsoft excel openoffice.org stock quotes
How to Calculate Sohcahtoa in Spreadsheets Sohcahtoa has been used by generations of teachers with generations of school children; it can now be made much easier by using spreadsheets. trigonometry trigonometrical functions relationshi • microsoft excel • openoffice.org calc • right angled triangle • sine cosine tangent
How to use a Spreadsheet to Analyze Race Results A spreadsheet and an Internet connection are all that's needed to start analyzing horse racing results to find that chink in a bookmaker's armour. horse racing analysis • bookmaker • spreadsheet horse racing results • microsoft excel openoffice.org calc spreadsheet • spreadsheet over round book
Learning the Excel Sort Command A simple guide to using the Data Sort commands and icon in Microsoft Excel. sorting with microsoft excel • an example of sorting • using spreadsheet commands • multiple sorting • how does the data sort command work
Mail Merge by the numbers Mail Merge is a great tool that can save you time. However, mastering the process can be difficult. Here is a different approach that is not in the books. mail merge • merged documents • icons • address block • recipients
OpenOffice Macros: The Worksheet_Activate Method OpenOffice.org Calc does not have a Worksheet_Activate method, but don't let that be a show stopper when migrating from Microsoft Excel. microsoft excel worksheet_activate • openoffice calc worksheet_activate • openoffice calc macros • migrating from microsoft to openoffice • migrating from excel to calc
Technical Training Technical training can help you build confidence, save time and prepare for promotions. Assess your technical competencies and learn to quickly fix deficiencies or plan technical training • technical training competencies • increasing your technical skills • compentency with microsoft office • microsoft word skills
Excel Quick Start If you need to learn Microsoft Excel quickly, then read this article. microsoft • microsoft excel • excel • basics • computer software
Speadsheets for Your Budget Spreadsheets simplify creating a budget while organizing planned income and expenses, and you have many good spreadsheets to choose from. budget • spreadsheets • budget planning • budgeting spreadsheets • debt reduction
The One Million Dollar Project Within this lesson, students will be "given" one million dollars - and work to spend the money on a socially beneficial project (building a no-kill animal shelter, creating a community for battered families, etc.) math • civics • social benefit • lesson plan • teacher's net
Absolute and Relative Cell Addressing This tutorial shows how to create a monthly mortgage repayment calculater in Excel or Calc, and how to simplify it by using absolute and relative cell referencing excel calc absolute cell reference • excel calc relative cell reference • relative cell referencing • absolute cell referencing • complex formula
Automating Word and Excel with VBA and VBScript Programmers can quickly automate Microsoft office applications by using VBA, and when combined with VBScript they have a very powerful tool at their disposal. vba vbs vbscript • microsoft office application automation • windows programming • word excel programming • word document select
Budget Templates for Spreadsheets Get spreadsheet templates andd learn how to use spreadsheet budget templates to simplify creating a personal or household budget. personal budget • household budget • budget spreadsheet • spreadsheet templates • budget forms
Databases for Small Businesses Databases help small businesses be more organised and sell more. This article provides a general introduction to some of the things which have to be considered. small business databases • database management • using databases • making databases work • contact management software
Stately Pride In the current affairs of the world, it is surpassingly easy to become focused on world-geography, events, etc. But it is perhaps in this very global society that we need to stress the importance of pride and knowledge in what we have, right out our own back door. state history • technology learning • teacher technology • lesson plan
Computer Security Weekly, April 17, 2000 April 17, 2000, This week's events in computer security, both on and off the net. computer • security • network • internet • virus
Continuing Ed Enrichment Classes Enrichment classes offer an opportunity for career advancement, personal growth, and an academic experience with no curriculum requirements. Lifelong learners take note! continuing education • enrichment • degree • curriculum • academic
Continuing Education for Small Business Owners Small business owners can really benefit from seminars and classes on running a small business. continuing education for small business owners • classes on running a small business • ongoing learning opportunities • learn to use computer software • free classes on computer basics
Creating Labels Labels are not just labels. The label program can create labels for addresses, file folders, business cards and more. labels • avery denison • templates • template • create
Excel More Basics Excel or any other spreadsheet software has become a staple for every business and many homes. excel • microsoft • software • computer software • tools
Introduction to Plot: Life Graphs A multi-day middle school lesson plan which gives students a foundation in the study of plot by creating a visual representation of their lives. visualization reading strategy • during reading strategies • reading-art integration • post reading strategies • plot study
Three Signs of Financial Problems Learn how to identify potential financial problems. Employ money management techniques & develop a personal budget if these signs appear. Find personal finance resources. financial problems • money management • financial help • personal budget • personal finance
Using Adobe Illustrator Adobe Illustrator offers creative flexibility for projects from postage stamps to posters. Artwork is created and saved in formats for print, publications or web pages. adobe illustrator cs3 cs4 uses • flexible powerful tools design projects • single page layout program • artwork creation • print publication web sites
Ways Teachers Use Technology Time-saving tools available to teachers, such as electronic grade books and lesson plan software. electronic grade book • lesson plan software • differentiating instruction • testing accommodations • web-based grade systems
Creating Price Book Pages Learn how to create your own price book pages, and keep your price book updated to save money on frequently purchased items such as groceries and household items. make a price book • compare prices • frugal tips • find the best prices • save on groceries
ETF Fundamental Valuations for 2009 Though fundamental analysis is typically reserved for individual stocks, the strategy is still helpful when evaluating exchange-traded funds. evaluating etf • fundamental analysis • strategies • exchange-traded funds • portfolio
Free Professional Development Don’t break the bank on expensive courses to develop yourself professionally. There are many low and no-cost training alternatives. no-cost training alternatives • develop professionally • professional skills • develop professional skills • training options
How to Create Trigonometric Macros in Calc Trigonometric functions in Calc (and other spreadsheets) work in radians rather than degrees; however a few simple macros will put that right. trigonometric functions • openoffice calc macros • trigonometry spreadsheet • inverse trigonometric functions • sine sin cosine cos tangent tan
How to Succeed at Work in Any Economy Worried about your job? Secure your career by applying these tips to succeed in any economy. succeed work • career tips economy • secure career • economic uncertainty • job tips
Improving Your Chances of Landing a Job For those who have recently been laid off, downsized, or are just plain out of work, these helpful tips can improve your chances of standing out from the crowd. unemployed • career advice • job seeking • unemployed workers • resume help
Learn to Program with BBC BASIC This article explains why BBC BASIC is a good learning language, which BBC BASIC to choose, programming, and a starter set of links to programming articles. programming • bbc basic • learning to program • how to program • coding
OpenOffice Macros: Accessing Calc Cells This tutorial shows how to do one of the most important things that an OpenOffice Calc macro must do - reading from (and writing to) cells. openoffice calc macros • macro to access cells • thiscomponent • getcellbyposition • getcellrangebyname
Using a Database Effectively Databases help small businesses profile customers, store details and sell more. This article provides the guidance needed to make it effective. small business databases • database management • using databases • customer lists • effective database management
Using the Adobe Illustrator Graph Tool Graph information can be entered into Adobe Illustrator for creative graphic embellishments with a little understanding of how the Graph Tools work. adobe illustrator cs3 graph tool vector tip • import excel spreadsheet data • create graphic design chart • export microsoft word office powerpoint format • change format layout visual style
Your Money or Your Life, A Personal Finance Book Your Money or Your Life offers unique views on saving money, investing, early retirement, frugal living, and financial independence by examining what really matters. your money or your life • personal finance book • early retirement • saving money • financial independence |
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
T |
U |
V |
W |
X |
Y |
Z |
0-9 |
|
|
|
|
|
|
|
|