With Office for the web you can view, edit, and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser, so you can work anywhere. Skip to main content Microsoft. Microsoft Office: Beginning PowerPoint for Mac 2011 - 12 Month Access - $149. +Microsoft PowerPoint for Mac 2011: Adding Simple Presentation Enhancements. Try Our Demo Courses ABSOLUTELY FREE! Our free demo courses are a great way to discover e-learning!
Get the most out of Microsoft Office 2011 for Mac with handy tips for working in Office in general as well as word processing in Word, making spreadsheets in Excel, creating PowerPoint slides, and e-mailing with Outlook.
- Get going quickly and easily with Microsoft 365 video training. Learn what's possible with Word, Excel, and PowerPoint. Get up to speed in no time with these popular guides. Work smarter and get more out of your Office apps. Do your best work together.
- Learn Excel With Our Free Online Training Courses On Formulas, Macros & VBA and Pivot Tables. 333 Excel Shortcuts for Windows and Mac. 101 Excel Formulas & Functions Examples. 101 Excel Pivot Tables Examples. Free Microsoft Excel Online Course – 20+ Hours Beginner to Advanced Course.
- The Microsoft Excel program is a spreadsheet consisting of individual cells that can be used to build functions, formulas, tables, and graphs that easily organize and analyze large amounts of information and data. Excel works like a database, organized into rows (represented by numbers) and columns (represented by letters) that contain.
- Free Beginner Excel Training Online. Excel Details: Free Beginner Excel Class Online: Intro to Excel › Top Law From www.training-nyc.com Law Details: Apr 28, 2020 In this beginner Excel class, we'll walk through some of the key beginner tips and tricks to work efficiently in Excel.Microsoft Excel is a powerful spreadsheet and analytics tool used by businesses and individuals across the.
Learn Excel Online. Microsoft offers free Excel classes online on edX to learn both fundamental and advanced Excel skills. Introduction to Data Analysis using Excel is a 4-week, self-paced online course perfect for learners with little or no prior experience using the software. Learn how to set up an Excel sheet, perform calculations, use basic.
Tips that Work throughout Office 2011 for Mac
The applications in Office 2011 for Mac use many common commands and features. The following common commands and features work the same throughout all of Office 2011 for Mac’s applications (Word 2011, Excel 2011, PowerPoint 2011, and Outlook 2011):
Undo: Look for the Undo button on the Standard toolbar or press the keyboard combination Command-Z.
Multiple Undo: Click the tiny triangle next to the Undo button to see a pop-up menu of available Undo actions.
Select All: Choose Edit→Select All or press Command-A to select everything in your document, including tables, charts, pictures, and other objects.
Help: Free training movies and online courses are now available in Office 2008 Help. Click the Help button on any of the toolbars and explore topics under Popular Training. You can also find them in Help search results.
Pop-up menus: Right-click or Control-click just about anywhere on the screen to get context-sensitive menus.
Copy: Press Command-C.
Cut: Press Command-X.
Paste: Press Command-V.
Menu bar: Press Control-F2 to activate the menu bar. Then use the arrow keys to navigate the menu and press the spacebar to activate a menu item.
Dock: Press Control-F3 to activate the Dock. Then use the arrow keys to navigate the menu and press the spacebar to activate a menu item.
Tips and Tools for Working with Word 2011 for Mac
If you spend a lot of time using Word 2011, you’ll soon look for ways to make word processing faster and more efficient. The following commands and tools help improve word-processing efficiency in Word 2011 for Mac:
Print Layout view: Choose View→Print Layout to work with word-processing documents the traditional way.
Notebook Layout view: Choose View→Notebook Layout for taking typed notes and recording audio notes of meetings and classes.
Publishing Layout view: Choose View→Publishing Layout to make newsletters and other publications.
Customize keyboard shortcuts: Choose Tools→Customize Keyboard to set up keyboard shortcuts.
Customize menus and toolbars: Choose View→Customize Menus and Toolbars to create and fine-tune your menus and toolbars.
Change font sizes: Use the slider bar on the Formatting Palette.
Display Reference Tools: Press Option-Command-R to display Reference Tools on the Object Palette.
Tips and Tricks for Excel 2011 for Mac
When you work frequently with Excel 2011 for Mac, you’ll want to gather some tricks for staying in charge of spreadsheets. Use these quick tips for your most common activities using Excel 2011:
Rename a worksheet: Double-click a sheet tab to change its name.
Edit cells: Double-click a cell to edit the cell formula or cell contents on the worksheet.
File timesaver: Save your files as Excel Binary Workbook (.xlsb) to get a much smaller file that opens and saves faster.
Create table rows and columns: Choose Insert→List to start the List Wizard, which helps you create row and column tables for your data.
Alternative menu options: Hold down the Shift key while navigating Excel’s menus to see alternative options.
Perfecting PowerPoint 2011 for Mac Presentation Skills
Free Online Courses For Microsoft Office 2011 Mac Downloads
Don’t let your audience suffer “death by PowerPoint” with the presentations you create in PowerPoint 2011 for Mac. Spruce up your slide presentations with these handy PowerPoint 2011 features:
Cross-platform presentations: To play your presentations on other platforms, install Flip4Mac, a free QuickTime codec that enables you to play Windows Media Video format in QuickTime.
Print handouts: To print handouts with lines for taking notes, choose File→Print. Look for the Print What pop-up menu and choose Handouts (3 Slides per Page).
Create a PowerPoint package: To create a package that has all DRM-free media properly linked, choose File→Save As. In the Format pop-up menu, choose PowerPoint Package.
Notes Page View: Choose View→Notes Page to work in a special view that allows you to see your slide and create extensive notes.
Online Computer Courses Microsoft Office
Outlook 2011 for Mac Basics
New to Office 2011 for Mac is Outlook 2011. With Outlook 2011 for Mac, you can manage and manipulate your e-mail, calendar, and contacts with these shortcuts:
Microsoft Office 2011 Free Download
E-mail: Outlook 2011 supports IMAP, POP, and Exchange protocols. To switch to Mail view, press Command-1.
Calendars: Outlook 2011 supports W3C standard calendar protocol and Microsoft Exchange calendar protocol. To switch to Calendar view, press Command-2.
Contacts: Outlook 2011 supports W3C standard vCard protocol and Microsoft Exchange calendar protocol. To switch to Contacts view, press Command-3.
Tasks: A built-in task manager with calendar tie-in. To switch to Tasks view, press Command-4.
Notes: A built-in notes manager. To switch to Notes view, press Command-5.
Microsoft Office Suite is a handy tool. Its uses are for writing, editing, presentation and calculation work.
Microsoft Excel is no doubt a multi-utility platform. It is used for a wide range of purposes by analysts, bankers, marketers, and accountants. Business schools too impart training in Excel. The internet has a wide range of MS Excel tutorials. It instructs you on its efficient usage. These tutorials will give you an in-depth knowledge of Microsoft Excel.
We have listed some resources to benefit you. These websites will teach you essential data management and analysis skills.
1. Microsoft Excel Help Center
Microsoft Excel Help Center is the best platform to learn excel online. It is an official website of Microsoft. A collection of tutorials will help you to learn MS Excel. Topics in the tutorials cover Data formats, Pivot Tables etc.
Tutorials are available on mail merges. In addition, you can choose the guides relevant to your current needs. Most importantly, some tutorials contain practical experiments. This enables you to get a hands-on experience.
Some of the featured topics dealt with in the website are,
- Move or copy worksheets or worksheet data
- Save a workbook in another file format
- Dropdown list
- Freeze panes to lock rows and columns
- Calculate the difference between two dates
- List of all Excel functions available
- How to avoid broken formulas
- IF function
- Access support for excel
- VLOOKUP function
- SUM function
“Ask The Community” platform provides solutions to queries.
Learn From – Microsoft Excel Help Center
2. GCF LearnFree.org
GCF LearnFree.org has one of the most detailed free resources to learn Excel online. It offers 29 tutorials and an addition of five tutorials. Besides, you will learn Excel basics and advanced lessons. In addition, the instructions come in simple terms for you to practice. Further, you will get a quiz at the end of the tutorials. This will assess your knowledge.
Some of the topics covered in the website include the following,
a) Excel 2016 Basics
- Getting started with Excel
- OneDrive
- Creating and Opening Workbooks
- Saving and Sharing Workbooks
b) Working with Cells and Sheets
- Cell Basics
- Modifying Columns, Rows and Cells
- Formatting Cells
- Number Formats
- Working with Multiple Sheets
- Using Find & Replace
- Checking Spelling
- Page Layout and Printing
c) Formulas and Functions
- Introduction to Formulas
- Creating Complex Formulas
- Relative and Absolute Cell References
- Functions
d) Working with Data
- Basic Tips for Working with Data
- Freezing Panes and View Options
- Sorting Data
- Filtering Data
- Groups and Subtotals
- Tables
- Charts
- Conditional Formatting
e) Additional Advantages
- Track changes and Comments
- Inspecting and Protecting Workbooks
- Intro to PivotTables
- Advanced instructions in PivotTables
- What-if Analysis
Learn From – GCF LearnFree.org
3. Excel Exposure
Excel Exposure is another best resource to learn excel online. It has a free online training course with links to video lessons. It covers topics like conditional formatting, error checking and macros. It deals with advanced concepts too.
Complicated issues tend to split into simple terms throughout. This makes even Visual Basic for Applications (VBA) easy to learn. Notably, Excel Exposure has a large group of followers. The lessons split into Beginner, Secondary and Advanced levels. A section on Excel 2013 too is available.
Learn From – Excel Exposure
4. Chandoo
Chandoo too is a vibrant platform to learn MS Excel online. You can begin with the fundamentals and move on to advanced topics. In addition, it has over 450 articles and tutorials on MS Excel. You will learn conditional formatting and create reports at a faster pace. Tips found on this website come from forums. Solutions to formulas, formatting, shortcuts, pivot tables, etc find their way here.
Topics having elaborate explanations are,
Microsoft Excel Training For Beginners
- Excel Basics
- Advanced Level
- Pivot Tables
- Project Management and
- Top 10 Excel Features
In addition, some of the Formulas dealt with in this website are,
a) Basics
- IF
- CHOOSE
- SUMFIS
- VLOOKUP and
- SUBTOTAL
b) Advanced
- SUMPRODUCT
- INDEX
- Multi-condition Lookups
- Array Formulas and
- Top Formulas for Analysis
Besides, a section on Excel VBA proves to be helpful.
Learn From – Chandoo
5. Excel Central
Excel Central is a noteworthy free site to learn MS Excel online.
Four versions of programs are available.
Learn From – Excel Central
6. Contextures
Contextures provides you a great way of learning Excel online for free. It has everything you require to become a master in Excel. Added to this, a variety of lessons, sample files, and videos help you. Tips and tutorials are available for free.
The tips and tutorials search occur in an indexed order.
The Sample Excel Files contains categories such as,
- Data Validation
- Filters
- UserForms, VBA, Add-Ins
- Conditional Formatting
- External Data
- Dashboards
- Charts and Graphics
- PivotTables
- Functions
- Scenarios
- Comments and
- Unblock Files
Learn From – Contextures
7. Excel Hero
Excel Hero is the best website to learn MS Excel online. It is an excellent resource for beginners. Many of the workbooks are available for download.
Among other things, you will learn,
- Excel Formulas
- Animated Business Charts
- Excel Optical Illusions
- Filling PDF Forms from Excel
- Using XML inside Excel
Excel Hero’s blog gives additional information.
Learn From – Excel Hero
8. Mr. Excel
Mr. Excel is another noteworthy site to learn excel online. It includes a variety of tips and tricks that will help you to learn excel. Besides this, free webinars guide you further. This will help you to get insights into the featured topics.
In addition, the site appears in subject sequences. Besides, Mr.Excel.com expert group can answer questions of the users. The site has a library of essential Excel books and tutorials.
Learn From – Mr. Excel
9. Improve Your Excel
It is another important source to learn Microsoft Excel online. It has free videos and webinars that will improve your knowledge of Excel.
Added to this, it deals with various topical categories such as,
Office For Mac Tutorials
- Data Validation
- Excel Features
- Graphs
- Hyperlinks
- Excel Counting Functions
- Pivot Table
- power Query
- Excel Functions
- Working With Data
- Power Map
In addition, it introduces topics such as the VLOOKUP function.
Learn From – Improve Your Excel
Also Read: Career Scope of Advanced Excel
10. Excel Easy
Excel Easy is one of the easy resources to learn Excel online. Beginners will find it to be helpful. The website contains six essential topics. The introduction deals with subjects such as Range, and Formulas and Functions.
The Basics deal with subjects such as,
- Ribbon
- Workbook
- Worksheets
- Format Cells
- Find & Select
- Templates
- Data Validation
- Keyboard Shortcuts
- Share and
- Protect
Functions deals with subjects such as,
- Count and Sum
- Logical
- Call References
- Date & Time
- Text
- Lookup & Reference
- Financial
- Statistical
- Round
- Formula Errors and
- Array Formulas
Data Analysis deals with subjects such as,
- Sort
- Filter
- Conditional Formatting
- Charts
- Pivot Tables
- Tables
- What-If Analysis
- Solver and
- Analysis ToolPak
VBA deals with various subjects including,
- Create a Macro
- MsgBox
- Workbook and Worksheet Object
- String
- ActiveX Controls and
- Userform
An additional of 300 examples prove helpful.
Learn From – Excel Easy
11. ExcelJet
ExcelJet is the best online site to learn Excel Shortcuts for Windows and Mac. Quick reference for keyboard shortcuts prove to be user-friendly. You can jet through a program without using the mouse.
The following have shortcut navigations,
- File
- Ribbon
- General
- Tables and Filters
- Drag and Drop
- Navigation
- Selection
- Active Cell
- Extend Selection
- Select Special
- Cell Edit Mode
- Entering Data
- Formatting
- Number Formatting
- Borders
- Formulas
- Gird Operations
- Pivot Tables
- Workbook
- Dialog Boxes, etc.
Learn From – ExcelJet
12. Annielytics
Annielytics is one of the most genuine sites to learn Excel online. This site by Annie Cushing proves helpful. Annie is a web analytics data expert.
Videos and tutorials on Excel in this site are informative.
Learn From – Annielytics
13. EdX Excel Courses
EdX is a most useful platform to learn Excel. Below are some links to learn Excel from EdX,
Data Analysis & Visual with Excel
Microsoft Excel for the Data Analyst
Introduction to Data Analysis using Excel
Analyzing and Visual Data with Excel
You can learn most of the above courses in a self-paced manner.
Learn From – EdX
14. Khan Academy
Khan Academy is one of the best sources to learn MS Excel online. It includes many video-tutorials on MS Excel. Instructive videos solve queries on Excel. Khan Academy offers ample free training courses. These courses are on varying subjects.
Learn From – Khan Academy
Free Online Access Training
15. The Spreadsheet Page
The spreadsheet page is an online excel tutorial which provides extensive tutorials and books on Microsoft Excel. This website is handled by John Walkenbach. He is written more than 60 books for the users. Besides, he has written 300 articles about MS Excel. Therefore, you will get the examples of custom number formats, which you can play with and tweak on your own time. It also helps you to get familiar in Microsoft Excel.
Learn From – SpreadSheet Page
16. Excel Bytes:
Excel Bytes is a website which is handled by Microsoft Excel specialist Mike Rempel. From this resource, you can get the free video tutorials and tips about Microsoft Excel. It also contains a collection of different how-to tutorials.
Learn From – Excel Bytes
17. Excel Functions.Net
Excel Functions.net is a reliable resource to learn MS Excel online. It has a collection of tutorial and tips about MS Excel. It will help you to learn the basic excel functions & formulas, pivot tables, macros, VBA, etc.
Learn From – Excel Funtions.net
18. Best Excel Tutorial
Best Excel Tutorial is a complex and completely free resource for learning MS Excel through online. It explores database functions with the most common function you would ever utilize when creating or mining a database. Besides, you will get essential tips and tutorials on Microsoft Excel.
Learn From – Best Excel Tutorial
19. Home And Learn
This is a free resource which helps you to learn about the Excel VBA. In this tutorial, you will learn how to create your own macros. It also helps you to take your Excel skills into the next level and establish yourself ahead of the competition.
Learn From –Home And Learn
Above guidance to learn Excel online will definitely enrich your scope. Go through the Excel lessons to master your craft.
Comments are closed.