Looking for:
Free Office Tutorials at GCFGlobal
Share your document in Word for Windows : Learn how to share your documents when you share your files using OneDrive or Office SharePoint right from within Word using the new Share option on the Ribbon. You can also share a copy of your document by sending it as an email attachment. Make the Switch to Word – Get started with the new version to see how to do everyday tasks.
A look at Word Get an in depth look at Word from starting it up, to saving your file. Also learn how to convert your. Create your first Word Document – Create a blank document and learn the basics of adding and formatting text. Save, Publish and Share your Documents – Save your file either to your computer, or to an online service like SkyDrive. Then find out how to share it with others, even if they have an older version of Office. Create Your First Document – Learn how to type where you want to on a page, fix spelling errors, make a list, change page margins, add emphasis to some words, quickly add some style, and save your work.
Create Visually Compelling Documents in Word – Learn how to use text effects to apply the same types of formatting that you use for graphics and images directly to document text, adjust, correct, and enhance images with picture editing tools. Microsoft Word – Get familiar with some of the new features of Microsoft Word with this free tutorial from Microsoft.
Microsoft Word Tips and Tricks : Learn some timesaving techniques to help you work faster with this short course from Microsoft. What’s New in Excel : View some of the top new features in Excel Getting Started with Excel : In this course, you’ll learn how to create a workbook, work with worksheets, create a basic chart and save your workbook. Create and Format Pivot Tables – 5 video lessons from Microsoft on how to work with Pivot tables, group data in pivot tables, filter data and slicers and create Pivot charts.
Create and Format Tables – 5 video lessons from Microsoft on how to create and format Excel tables, sort and filter tables, add a total row and filter data with slicers. Create and Format Charts – 4 video lessons from Microsoft on how to create and format charts, add sparkline charts, trendlines and drop lines.
What’s New in Excel – Find out about the new features in Excel Create a blank workbook and learn the basics of working with columns, cells, and data. Basic Tasks in Excel : Learn the basic steps to get you started putting your data in cells and grouping them in rows and columns. This will allow you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Create your First Spreadsheet with Excel – learn how to create a spreadsheet, do basic math in Excel, add and delete columns and rows, keep column titles in sight as you scroll, and prepare a spreadsheet for printing with this free tutorial from Microsoft.
Basic Tasks in Excel – Find out what is Excel, apply a template, create and save a workbook, enter data in a spreadsheet, format numbers, apply cell borders, create an Excl table and more.
Excel Printing and Setup. Excel Charts and Graphs. Introduction to OneNote for Mac. Excel – Introduction to Charts. Tips and Tricks MS Word. Excel Basics Math and Functions. Excel Large Data PivotTables. Excel Math with Dates and Times. Excel Large Data vLookups. Excel Large Data Sorting and Filtering.
Excel Large Data Final Report. Outlook – Quick Start Guide. Follow these steps to make the link to a form library. Power View is used to examine and analyse data and is just one of the features you will learn about in our Excel Advanced Data Analysis course. In the VBA for Microsoft Excel course, you will not only learn how to record macros in Excel, but write the code behind them.
PowerPivot is used to for connecting and manipulating data, particularly from external sources. It allows you to connect tables of data that have common fields just like a relational database and is just one of the features you will learn about in our Excel Advanced Data Analysis course. Flash Fill recognises a pattern in your data and is a great tool to extract a field and break it down into its component elements. For example, in this video tip Column A has the first and last name in one field.
Flash Fill makes splitting the names up into two separate cells first name and surname column very easy. Information required for a presentation may already exist in a Word document. You’re able to import this information into a PowerPoint presentation without having to retype or cut and paste. There are so many hidden features in Excel, it could take a lifetime to learn them all.
Thankfully, we have done the hard work for you, and come up with five very helpful Microsoft Excel tips to resolve some of the questions you never even knew to ask about Excel.
Need to create a sequence of dates? It’s very easy using Excel’s AutoFill feature. Most people know that when you press the Enter key on the keyboard when using Microsoft Word , a new line is inserted into the document.
A Quick Step is a feature that lets you make a shortcut to any multi-step action. For example, moving emails and marking them as read, or forwarding an email and flagging it.
It makes short work of a repetitive task. Staff intranet sites are driven by people actively contributing and collaborating. Want some clever cell formatting in Excel but get confused by the Custom Format Cell options? Here is a quick tutorial to writing clever cell formats. Pasting the values from a formula so that the numbers never change has always involved several steps. Often you want to calculate an answer, but store the number, not the calculation.
A PivotChart is an interactive chart that provides a graphical analysis of data. Your data comes from existing tables, databases or PivotTable reports. A slicer is a visual filter that allows further insight into a particular field. In this video, you will learn how to create a drop-down so you can select from a list without having to retype each time.
Free Office Tutorials at GCFGlobal.Tutorials and corrected exercises of Office and Excel in PDF files
Gain essential skills in Office and , including Microsoft Access, In this free tutorial, learn how to enter, manage, and search through large. Microsoft Office Suite of Applications ; Free tutorial. Rating: out of ( ratings). 17, students. 1hr 13min of on-demand video ; Created by Dr. Free Microsoft Office tips. Step-by-step beginner to advanced level tutorials for improving your skills in Excel, Word, PowerPoint & more. Learn online now.
Download free tutorials and courses on ms office – Documents PDF
Enjoy the following free Microsoft Office Tutorials. Some are from Officeskills. What’s New in Word : View some of the top new features in Word Getting Started with Word : In this course, you’ll learn how to create a blank document or one based on a template, select and format text, create bulleted and numbered lists, change text alignment, and change line spacing.
You’ll also learn how to add headers and footers, change page numbers in headers and footers and add pictures and tables to a document. Share your document in Word for Windows : Learn how to share your documents when you share your files using OneDrive or Office SharePoint right from within Word using the new Share option on the Ribbon.
You can also share a copy of your document by sending it as an email attachment. Make the Switch to Word – Get started with the new version to see how to do everyday tasks. A look at Word Get an in depth look at Word from starting it up, to saving your file. Also learn how to convert your.
Create your first Word Document – Create a blank document and learn the basics of adding and formatting text. Save, Publish and Share your Documents – Save your file either to your computer, or to an online service like SkyDrive. Then find out how to share it with others, even if they have an older version of Office. Create Your First Document – Learn how to type where you want to on a page, fix spelling errors, make a list, change page margins, add emphasis to some words, quickly add some style, and save your work.
Create Visually Compelling Documents in Word – Learn how to use text effects to apply the same types of formatting that you use for graphics and images directly to document text, adjust, correct, and enhance images with picture editing tools. Microsoft Word – Get familiar with some of the new features of Microsoft Word with this free tutorial from Microsoft. Microsoft Word Tips and Tricks : Learn some timesaving techniques to help you work faster with this short course from Microsoft.
What’s New in Excel : View some of the top new features in Excel Getting Started with Excel : In this course, you’ll learn how to create a workbook, work with worksheets, create a basic chart and save your workbook. Create and Format Pivot Tables – 5 video lessons from Microsoft on how to work with Pivot tables, group data in pivot tables, filter data and slicers and create Pivot charts.
Create and Format Tables – 5 video lessons from Microsoft on how to create and format Excel tables, sort and filter tables, add a total row and filter data with slicers. Create and Format Charts – 4 video lessons from Microsoft on how to create and format charts, add sparkline charts, trendlines and drop lines. What’s New in Excel – Find out about the new features in Excel Create a blank workbook and learn the basics of working with columns, cells, and data.
Basic Tasks in Excel : Learn the basic steps to get you started putting your data in cells and grouping them in rows and columns. This will allow you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Create your First Spreadsheet with Excel – learn how to create a spreadsheet, do basic math in Excel, add and delete columns and rows, keep column titles in sight as you scroll, and prepare a spreadsheet for printing with this free tutorial from Microsoft.
Basic Tasks in Excel – Find out what is Excel, apply a template, create and save a workbook, enter data in a spreadsheet, format numbers, apply cell borders, create an Excl table and more. Microsoft Excel – Modify Data in a Workbook. Video on how to select cells, cell ranges, copy, paste and paste preview and find and replace data. Also learn how to convert selected data to a table and apply table styles. Take the course. Working with Excel Tables – Learn how to manage information by using Excel tables, which make it easy to format data, sort, filter, add totals, and use formulas with this free tutorial from Microsoft.
Create a Basic Chart in Excel – Charts make data visual. With a chart you can transform spreadsheet data to show comparisons, patterns, and trends. Microsoft Excel – Get familiar with some of the new features of Microsoft Excel with this free tutorial from Microsoft. Free Office tutorial from Microsoft. Getting Started with PowerPoint You’ll also learn how to saving your presentation and how to share it. Collaborate on PowerPoint presentations with co-authoring : Learn how to collaborate with your colleagues and work on a presentation at the same time when you save your presentation to OneDrive or Office SharePoint.
Share your PowerPoint presentation with others : Learn how to share your presentations and slide shows with others with the new Share option on the Ribbon.
PowerPoint Overview. View the video that gives an in depth look at PowerPoint Learn how to create a presentation from a template and explore all the PowerPoint features on the ribbon. How to do a PowerPoint Presentation using images and clipart. Download the exercise files from our blog and follow along with me using the PowerPoint presentation or video.
Upgrade to PowerPoint – Get familiar with some of the new features of Microsoft PowerPoint with this free tutorial from Microsoft. This is a good tutorial if you are planning on upgrading from PowerPoint or earlier. Getting Started with Access – Learn about Access , how to get started using databases and getting to know database objects.
Create an Access Database – Learn how to create an Access database and a web app and how to decide which one to use. Getting Started with Access – A guide for mostly experienced users making the switch to Access However, this is also a good general overview of Access Design the Tables for an Access Database – This is the first step in setting up your database.
Learn the design process for designing the tables for an Access Database. Create the Tables for an Access Database – Learn the common tools for creating the tables for an Access Database. Create Relationships for an Access Database. Learn how your tables talk to each other by creating relationships in an Access database.
Getting Started with Outlook : In this course, you’ll learn how to set up your first email account, compose and send emails, use links to share items in email, view only unread emails, reply to emails and search email.
You’ll also learn how to create a signature for your emails. Manage your Calendars – 8 videos from Microsoft on how to view and customize your calendars, search for calendar items, email, share or print your calendar, open and view multiple calendars, create calendar groups, import a Google calendar, assign a delegate to manage your calendar and more. Manaage Meetings – 5 videos from Microsoft on how to schedule appointments, schedule an online Skype for Business, manage recurring meetings, attach a file to a meeting invitation, use OneNote to take Outlook meeting notes.
The mission of officeskills. Microsoft Office Tutorials. Free Microsoft Word Tutorials Create Your First Document – Learn how to type where you want to on a page, fix spelling errors, make a list, change page margins, add emphasis to some words, quickly add some style, and save your work.
Creating Columns in Word : Video on how to create a brochure style document in Word using columns View PDF Watch Video Take Course Create Visually Compelling Documents in Word – Learn how to use text effects to apply the same types of formatting that you use for graphics and images directly to document text, adjust, correct, and enhance images with picture editing tools.
Free Microsoft Excel Tutorials Free Microsoft Excel Tutorials What’s New in Excel : View some of the top new features in Excel Getting Started with Excel : In this course, you’ll learn how to create a workbook, work with worksheets, create a basic chart and save your workbook.
Free Microsoft Excel Tutorials Create your First Spreadsheet with Excel – learn how to create a spreadsheet, do basic math in Excel, add and delete columns and rows, keep column titles in sight as you scroll, and prepare a spreadsheet for printing with this free tutorial from Microsoft. Free Outlook Tutorials Free Outlook Tutorials Getting Started with Outlook : In this course, you’ll learn how to set up your first email account, compose and send emails, use links to share items in email, view only unread emails, reply to emails and search email.
Stay Connected For general inquiries, please contact me at the email address below. Our Mission The mission of officeskills. All Rights Reserved.