Microsoft PowerPoint is great for making slides and giving presentations, be it photos for family and friends, business or indeed for anything you want. It's super easy to use and there's load of different backgrounds and colours you can use to make it really eye - catching, and it also makes it a snap to get your message across.
I think it's one of the easiest Microsoft Office elements to master. Just pick the slide design you want for each one and away you go! Each slide is pre set with different font styles and layouts, and there's loads of different templates you can use. It even has an Auto Content wizard so you only have to fill in the blanks!
Full tutorials coming soon for Word, Access, Excel and Power Point!
Friday, June 12, 2009
Using Access - quick overview
Microsoft Access is a powerful database program you can use to store all kinds of information from a simple list of recipes to an inventory catalog with tens of thousands of products. Once information is stored in a Microsoft Access database, it's easy to find, analyze, and print.
Of all the programs in the Microsoft Office suite, Microsoft Access is the one that most intimidates people. "Mastering Microsoft Excel or Word was hard enough," they think. "How can I ever understand a complicated program like Access?"
While it's true that Microsoft Access has many advanced features creating and working with a Microsoft Access database is probably a whole lot easier than you think. Just try it, it gets so much easier once you grasp a few basic facts. Once you feel more comfortable with it, you'll wonder why you were worried. Think of it like a filing cabinet - once you set it up correctly it will manage all your data and you can pull whatever information you need from it instantly.
Once I have put in a bit about all the different Office applications, we can get started ok?
Of all the programs in the Microsoft Office suite, Microsoft Access is the one that most intimidates people. "Mastering Microsoft Excel or Word was hard enough," they think. "How can I ever understand a complicated program like Access?"
While it's true that Microsoft Access has many advanced features creating and working with a Microsoft Access database is probably a whole lot easier than you think. Just try it, it gets so much easier once you grasp a few basic facts. Once you feel more comfortable with it, you'll wonder why you were worried. Think of it like a filing cabinet - once you set it up correctly it will manage all your data and you can pull whatever information you need from it instantly.
Once I have put in a bit about all the different Office applications, we can get started ok?
Monday, February 16, 2009
Excel - useful facts
A spreadsheet (called a workbook within Excel) is a powerful application which can be used to store, manipulate, calculate and analyse data such as numbers, text and formulae. An analogy can be drawn between a spreadsheet and an accountant’s ledger. A ledger is made up of many pages, each page arranged into a series of rows and columns.
Put simply, a spreadsheet is used to enter numbers and perform simple calculations but the capabilities of Excel extend far beyond this. Excel provides a number of features including:
Each worksheet contains 256 Columns and 65,526 Rows. This makes it ideal for keeping accounts, amongst other things, for the largest company or for home use.
By default, there are three worksheets in each workbook, but more can easily be added. Simply click Insert, then Worksheet. You can add as many worksheets as you wish, by clicking on Edit, Repeat or by using the CTRL V keystrokes.
Excel is designed to be user-friendly, so in addition to calculating formulas to add, divide, multiply, subtract and calculate averages using the = function, the same result can be achieved by using the Autosum feature
Put simply, a spreadsheet is used to enter numbers and perform simple calculations but the capabilities of Excel extend far beyond this. Excel provides a number of features including:
- Functions for mathematical, financial and other calculations.
- A selection of tools to facilitate “what if” type analyses.
- A Chart Wizard – to produce graphical representations of data held within workbooks.
- Graphics to highlight information in worksheets and charts.
- Database features which enable the sorting, filtering and analysis of information.
- Macros that allow you to automate time - consuming tasks
Each worksheet contains 256 Columns and 65,526 Rows. This makes it ideal for keeping accounts, amongst other things, for the largest company or for home use.
By default, there are three worksheets in each workbook, but more can easily be added. Simply click Insert, then Worksheet. You can add as many worksheets as you wish, by clicking on Edit, Repeat or by using the CTRL V keystrokes.
Excel is designed to be user-friendly, so in addition to calculating formulas to add, divide, multiply, subtract and calculate averages using the = function, the same result can be achieved by using the Autosum feature
Thursday, January 22, 2009
Hello and Welcome!
Microsoft Office 2003 is a suite of office programs that will be familiar to most people. On this blog I hope to provide as much help and information as possible, beginning with Word.
Do you use Microsoft Word? Millions of people do, but not everyone uses it to its full potential. For instance, have you ever received a letter from a company or individual that was badly laid out and had poor spelling? I bet you have. Yet using Word makes it so easy. A lot of people are not aware of the tools available to them though. Keeping an eye on your spelling is easy. A word that is misspelled will automatically underline to let you know something is wrong.
In the coming weeks I'll be adding many tricks, tips and tutorials you can use in Word, Excel, Access and PowerPoint. These will be in groups like Beginner, Everyday and Advanced, so if there is anything you would particularly like to find out, please feel free to leave a comment, I'd really appreciate your feedback. Thanks for stopping by!
Do you use Microsoft Word? Millions of people do, but not everyone uses it to its full potential. For instance, have you ever received a letter from a company or individual that was badly laid out and had poor spelling? I bet you have. Yet using Word makes it so easy. A lot of people are not aware of the tools available to them though. Keeping an eye on your spelling is easy. A word that is misspelled will automatically underline to let you know something is wrong.
In the coming weeks I'll be adding many tricks, tips and tutorials you can use in Word, Excel, Access and PowerPoint. These will be in groups like Beginner, Everyday and Advanced, so if there is anything you would particularly like to find out, please feel free to leave a comment, I'd really appreciate your feedback. Thanks for stopping by!
Subscribe to:
Comments (Atom)
Twitter Updates
