Microsoft office for mac 2011 tutorial excel basics powerpoint

Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. Download our free office for mac quick starts to get up and running quickly. Microsoft excel is part of the suite of programs called. Whether youre new to microsoft s popular word digital slideshow application, new to ms powerpoint 2011 or even an expert merely looking to brush up on the fundamentals, youre sure to be well served by this quality video tutorial from the folks at lynda. The new training titles include powerpoint, outlook, excel and word 2011 for mac tutorials. Powerpoint themes allow for a variety of presentation topics, giving you the freedom to choose the best presentation template design for your project. Get up to speed in no time with these popular guides. To do that, click the browse themes option that you will find at the bottom of the dropdown themes gallery refer to figure 2 above, and navigate to wherever the given presentation, template, or theme is located. If you are authoring macros for office for mac, you can use most of the same objects that are available in vba for office. The office for mac 2011 training downloads include portable document format. Tools in powerpoint views powerpoint has several views that allow you to edit and see presentation content in various useful ways. By default, documents saved in powerpoint 2010 are saved with the. Powerpoint is a powerful presentation application, but to use it most effectively, you first have to understand the basics.

With office 365, you can collaborate with anyone, anywhere. Sep 24, 2015 next, point to microsoft office and click on excel to start it. Today, we will be going over the basics of using microsoft excel. Keep in touch and stay productive with teams and microsoft 365, even when youre. Microsoft excel tutorial making a basic spreadsheet in excel duration. We will be using pc desktop computers running the windows operating system. Learn how to jump to a specific slide in powerpoint s slide show mode. You can also apply any powerpoint presentation or template as a theme, even if it doesnt show up within the theme gallery. When you make charts in office 2011 for mac, you find a brandnew set of chart tabs on the ribbon that guide you with the latest microsoft charting technology. Microsoft excel is part of the suite of programs called microsoft office, which also includes word, powerpoint, and more.

From students to the csuite, most people are familiar with microsoft office. Create easier to interpret spreadsheets in excel, edits documents from. To access the same training online, visit the office for mac website. To see a tip for a button on the ribbon or toolbar, rest the pointerover.

Heres a tutorial designed to introduce mac users to the basics of microsofts powerpoint software and to help them develop their skills using the program. Save documents, spreadsheets, and presentations online, in onedrive. Excel basics 5 hints to hide the ribbon while you work, on the right side of the ribbon, click. It features calculation, graphing tools, pivot tables, and a macro programming language called visual basic for applications. You can also change the theme for an office document, sheet, or slide and watch how this simple task can change the overall appearance of your content. This book aims to be a comprehensive reference for the use of microsoft office for windows, microsoft office for mac, and microsofts office online and office 365 services. Use excel for mac 2011 to check out a sharepoint file so that only you can make changes. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced. Excel basics click cell c2, and then click edit paste. Collaborate for free with online versions of microsoft word, powerpoint, excel, and onenote.

We will use microsoft powerpoint 2011 for mac in this example but you could really be using word or excel versions of office 2011 to do the. Powerpoint basics for students 3rd 12th heres a tutorial designed to introduce mac users to the basics of microsofts powerpoint software and to help them. This tutorial introduces some of the tasks and features that you can use in all presentations. Excel 2011 is a version of excel developed by microsoft that runs on the mac platform. A copy of the data appears in cells c2, c3, and c4. Microsoft powerpoint is a presentation tool that supports text, shapes, graphics, pictures and multimedia along with integration. In powerpoint, click the slide where you want to paste the copied worksheet data. Powerpoint basics lesson plan is suitable for 3rd 12th grade. Microsoft office programs must be purchased for the users operating system os either a mac or pc.

Outlook for mac and onenote for mac do not support vba. Youll find a detailed topic outline for each course as. Basics and descriptive statistics psych 209 in psych 209, we will use excel to. Learn how to quickly zoom with the scroll wheel in powerpoint. Microsoft powerpoint is a commercial presentation application written and distributed by microsoft for microsoft windows and mac os x. Point, ms office essential shortcuts for you to learn. On the home tab, click the arrow next to paste, and then click paste special. For onetime purchases of office for mac 2011 you can install office on only one computer. Microsoft powerpoint templates offer the widest range of design choices, which makes them perfect for modern and sophisticated presentations and pitches. Microsoft word, powerpoint, excel, onenote, outlook, and onedrive logos. Students, businesses, scientists, news organizations, economists, and many other groups use charts. It much easier than you would imagine with this quick tutorial. A spreadsheet is the computer equivalent of a paper ledger sheet.

Microsoft has released a new office suite for mac users for 2011, and the new version of word has some features to make it easier than ever to create great documents. Before saving or quitting, i can happily edit and work with the. Oct 01, 20 the office for mac 2011 training downloads include portable document format. How to use master slides demostration in powerpoint 2011 for mac nyim training tutorial. Learn how to customize the quick access toolbar in powerpoint.

Microsoft has released a new office suite for mac users for 2011, and the new version of word has some features to make it easier than ever to create. Learn the basics of using microsoft excel for mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good. Word excel crash every time i quit or save powerpoint crashes on start, after selecting the document type. While this book doesnt teach basic computer skills or general windows or os x usage, this book will cover a few core techniques that complement the use of microsoft office. Next, point to microsoft office and click on excel to start it. Select and copy the area of data you want to link to. Learn how to open a powerpoint presentation in slide show mode. If the ms powerpoint icon is not on the desktop, go to the start menu. In powerpoint for mac 2011 essential training, author david rivers demonstrates how to create effective slideshows and dynamic presentations using the tools in microsoft powerpoint. Microsoft excel full name microsoft office excel is a spreadsheet an application written and distributed by microsoft for microsoft windows and mac os x.

Replace the second instance of answer with comments. Microsoft excel is a spreadsheet developed by microsoft for windows, macos, android and ios. Microsoft powerpoint is a presentation tool that supports text, shapes, graphics, pictures and multimedia along with integration with other microsoft office products like excel. Outlook for office 365 for mac powerpoint for office 365 for mac excel 2019 for mac onenote for mac powerpoint 2019 for mac word 2019 for mac excel 2016 for mac outlook 2016 for mac powerpoint 2016 for mac word 2016 for mac outlook 2019 for mac. Learn whats possible with word, excel, and powerpoint. Notice that a copy of the numerical data now appears in column c and column d. This excel 2011 tutorial covered the basic concepts of spreadsheets such as. The current versions at the time of writing this tutorial are 2010 for microsoft windows and 2011 for mac os x. Tip the keyboard shortcut for the paste command is. Powerpoint basics 20 on the where popup menu, click documents, then click the arrow next to the save as box so that the arrow faces upward.

To do that, click the browse themes option that you will find. Automate tasks with visual basic macros at the bottom of the window, select the lines of code shown below, and then click edit copy. See the full list of keyboard shortcuts, organized into. Learn the basics of charts, including the elements of a chart, which chart is. In powerpoint, a table is formatted to look nice, but it cant have word fields or excel formulas. It is an electronic spreadsheet program with which you can create graphs and worksheets. Need to know how to paste an excel table into a microsoft powerpoint for mac 2011 presentation. Formatting cells a1 to f4 select cell a1, click the left button on the mouse and drag it over cells in columns af and row 14. Themes also influence how charts look within excel and powerpoint, and also how your tables appear in all office programs. It was first announced by bill gates on august 1, 1988, at comdex in las vegas. In the paste special box, select display as icon, and under paste as, select microsoft excel worksheet object. Excel is a powerful spreadsheet and data analysis application, but to use it most effectively. See the full list of keyboard shortcuts, organized into logical categories. Excel 2011 is a version of excel developed by microsoft that runs on the mac.

Microsoft powerpoint is a presentation tool that supports text, shapes, graphics, pictures and multimedia along with integration with other microsoft. Youre definitely not the first mac user to notice that microsoft dropped a different printer driver interface into word than it has in its other mac programs. Rows are represented by numbers along the side of the sheet. Click start programs microsoft powerpoint occasionally, microsoft powerpoint will be in a folder called microsoft office or similarthis will make one more step between programs and microsoft powerpoint in the diagram above. Applying themes in word, excel, and powerpoint 2011 for mac. Get going quickly and easily with office 365 video training. Ill start by going through the basics of using word, walking through the interface, understanding the views, and getting text on that blank page. You can switch among the views as you work by selecting one from the view menu or clicking one of the five view buttons in the lower lefthand corner of the powerpoint window. Learn how to quickly zoom with the scroll wheel in. The current versions at the time of writing this tutorial are 2010 for. In powerpoint for mac 2011 essential training, author david rivers demonstrates how to create effective slideshows and dynamic presentations using the tools in microsoft powerpoint 2011. Store and organize data, analyze data, and represent data graphically e. Microsoft excel tutorial making a basic spreadsheet. Aug 26, 20 learn how to create a quick flowchart in microsoft office applications such as word, excel, and powerpoint for mac.

A table in powerpoint 2011 for mac is a much simpler affair than in word or excel. For information about vba for excel, powerpoint, and word, see the following. It features calculation, graphing tools, pivot tables, and a macro programming language called visual. Microsoft office excel 2007 basics getting started the excel window 1 quick access toolbar stores shortcuts for commonly used tools such as save, undo, and print. Download and install or reinstall office for mac 2011. Basics tutorial complete congratulations, you have completed the excel 2011 tutorial. Wordexcel crash every time i quit or save powerpoint crashes on start, after selecting the document type. In the code, click after the quotation mark that follows answer, press return, and then click edit paste. Learn how to temporarily hide your slide show during a powerpoint presentation. If you need a more powerful table in your slide, create the table in word or excel and then choose insertobject from the menu bar and select the word document. In the code, click after the quotation mark that follows answer, press return, and then click edit.

In excel for mac 2011 essential training, author curt frye gives a. Customer support and troubleshooting for office for mac 2011 ended october, 2017. Click start programs microsoft powerpoint occasionally, microsoft powerpoint will be in a folder called microsoft office or. However, you may transfer office for mac 2011 to another computer that belongs to you if you experience a hardware failure or you buy a new computer. How do i print twosided from microsoft word for mac. Standard office bundles come with word, excel, powerpoint, and onenote. Learn how to create a quick flowchart in microsoft office applications such as word, excel, and powerpoint for mac. In the new folder dialog box, type powerpoint practice folder, and then click create. Outlook onedrive word excel powerpoint onenote sharepoint. Excel will open a new workbook with the default name book1 and cell a1 as the active cell. Office for mac for visual basic for applications vba. Microsoft office wikibooks, open books for an open world. How to use master slides demostration in powerpoint 2011 for mac nyim training tutorial duration.

Acquire the essential skills needed for producing professional work using microsoft access, excel, outlook, powerpoint, publisher, and word in the office 2010 suite. Link excel to powerpoint with mac microsoft community. Click the start button, click all programs, click microsoft office, and then click microsoft excel 2010. The course provides indepth instructions for changing the look of presentations. You can also change the theme for an office document, sheet, or slide and watch. How to paste an excel table into a powerpoint for mac 2011. Whether youre new to microsofts popular word digital slideshow. This tutorial introduces some of the tasks and features that you can use in all workbooks.

Microsoft office, or simply office, is a family of client software, server software, and services developed by microsoft. Aug 26, 20 basic flowcharts in microsoft office for mac learn how to create a quick flowchart in microsoft office applications such as word, excel, and powerpoint. Microsoft office guides, tutorials, and instruction sheets. How to make an excel chart in office 2011 for mac dummies.