Download free courses materials, tutorials training on ms office basics in PDF files. Microsoft Word can be used to create documents, brochures, leaflets, outlines, .. To save your document in the PDF file format, go to File > Save As. The saving. Ms Office is a package suite of MS Word (A Word Processor), MS Excel (A .. Distance Learning: Several online distance learning courses are 'offered by.
|Language:||English, Spanish, Japanese|
|Genre:||Politics & Laws|
|Distribution:||Free* [*Registration Required]|
for using our Microsoft Office tutorials. You may already refer the . use multiple tutorials to build a more comprehensive proficiency in the Microsoft Office Suite. Office basics Learning. Office Training Center · terney.info · Office Training Center Intro to Office basics · Get help and support · Change your Office Learn the basic functions of Microsoft Word and how to use them! Start creating and PDF Basics; PDF evolution · Scanned PDF FAQs. PDF Creation; How to.
Alignment — The alignment options dictate whether the left and right edges of the text in a document adhere to the right side, left, center or justified. Clipboard — The clipboard acts as a type of storage area when a piece of text is temporarily removed and stored for later use within the same session. Using the Cut or Copy commands will place the text in the clipboard. Copy — Copying text simply means making a replica of any text that is currently selecting and saving it to the clipboard.
Cut — Cutting text removes the text entirely from the viewable document and stores it in the clipboard. The Cut function can also be found under the Edit menu or the toolbar. Document — Each document in Microsoft Word is essentially a new file.
Each document can be several pages long. Edit — The edit menu or toolbar in Microsoft Word allows users to perform basic editing functions in their document such as copying, cutting and pasting.
Font — A font is a type of design for text and typically incorporates this design into each letter, number and symbol found on a keyboard. Fonts can range from formal to whimsical. Microsoft Word comes with a series of provided fonts and additional ones can also be downloaded if needed. To change the font used in a document, select the text and either click on the main Font menu, the Font drop-down menu in the formatting toolbar or hit Control-D or Command D.
Footer — The footer is the text that consistently appears on every page of a document, at the bottom of each page. Format — The Format menu or toolbar goes one step further than the Edit menu.
Users can make stylistic changes by changing the look of the text itself, paragraphs, lists and more. Header — The header is similar to a footer except that it sits at the very top of every page in a document. Headers often contain page numbers, the document name or sub-titles within a document. Justify, left justified, right justified — Justification is a type of alignment for text in a word processor. Justify ensures that both the left and right sides of the text in every paragraph run in a straight line.
Left justify makes only the left side of the text aligned, while the right side remains ragged. Right justified does the complete opposite, with only the right side of the text aligned. Open — The Open command opens an existing document in Microsoft Word. Excel Basics Microsoft Excel 3. It begins with things like formatting cells, locating ribbons and workbooks, and using keyboard shortcuts to speed up the editing process. The Motion Training YouTube Channel : Provides a compelling place to start your research, since the beginner video is only nine minutes long, and it has visuals for you to follow along.
Get Started Guide from Microsoft : Delivers a three-part video course with essentials for data entry and editing spreadsheets.
Color coding and data bars are also covered, along with information about how to generate charts and pivot tables. GCF : A free learning environment with a wonderful compilation of Excel tutorials and videos. The online guide starts with an introduction and an explanation of OverDrive. Then it moves onto working with cells, sheets, data, formulas, and functions.
Includes information on how to buy Microsoft Excel, along with a list of the newest features in recent releases.
Chandoo : Find intermediate information about conditional formatting and creating reports quickly. The raw basics are outlined in this one article, using some text, images, and video. However, it also has some additional resources for you to click through and read more.
This way, you know exactly where to go while learning the Excel terms and shortcuts. Excel Exposure : Has a free online training course with links to several video lessons. Conditional formatting and error checking are just some of the topics covered in the earlier sections and goes all the way to macros and some more advanced information.
Excel Exposure has a large community of followers. You can connect with these people and ask questions that actually get responses in the comments. Everything from printing your Excel sheet to completing basic functions is covered here in an easy-to-read format. The Basic Excel Functions page : Even advanced users need a refresher in the simpler functions in Excel, and this is a solid resource to have handy.
For instance, you might need to find out what the Find and Replace function is. A quick search through this article gets you to the answer. These resources provide a refresher on mathematics with plenty of real-world use cases: Excel Advanced Formulas and Functions : This course has been viewed thousands of times, and it takes around six hours to complete, with videos, downloadable materials, and a transcript. The exercise files improve the way you learn, since you have a chance to practice during the course.
The Excel Math Functions : This list is a good starting point for anyone interested in learning even the most basic of functions. It goes deeper into the more advanced usage, so you get a whole range of what to expect when making your own formulas in Excel. Some other functions you might find interesting include Len, Proper, Trim, and Rounding. The financial formulas section is particularly intriguing for those who would like to work in accounting or banking.
This one has had over 9, students enrolled, with courses for mastering the top 25 most advanced math formulas in Excel. It teaches real world examples for the formulas so you can see how to utilize them in the future. Dozens of PDF quizzes, practice files, and slides are available for download, and a beautifully structured course outline is there to walk you through some of the more complicated techniques. Excel as a Financial Calculator : this article is particularly useful since not everyone is at work with a real financial calculator.
So it makes sense to learn these functions in many fields.
We like the key that compares some of the more advanced functions in Excel to buttons on a financial calculator. This allows you to seamlessly transition from a calculator to the Excel spreadsheet. Excel Exposure keeps its articles on the shorter side, which is good if you want to absorb the information in small helpings. Advanced time and math calculations : Helpful guides primarily delivered in video format.
All of the calculations are done through Excel, allowing you to see the visuals and practice them on your own time. You can use it for databases too.
Getting to grips with databases will help you to understand how to use some of the more complex functionality in Excel: Microsoft Office Tutorial on Importing Data into Excel and Creating a Data Model : One of the main reasons people use Excel is for data mining and creating databases in general.
This expands on the essentials of data insertion and organizing that data afterward. For example, you could start with learning how to import data using copy and paste, then go straight to creating a relationship between imported data. Building a database in Excel with a table or list : Wonder How To provides a few simple video tutorials for those interested in this topic. Using Excel as your database : A nice tutorial from Chandoo.