1. Free Online Excel Classes For Mac
2. Microsoft Excel Training For Beginners
3. Free Excel Formula Training

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!

Learn some of the key intermediate level Excel for Mac skills, tips, and tricks. You'll learn some formatting tools, including conditional formatting, the A. 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. Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more. It can be programmed to access external databases and is an excellent tool for data modeling, statistics, and financial calculations. With Excel, you can use built-in functions to quickly and easily perform common. Search freeze panes in excel mac and find the best free office suite training courses, classes and videos of freeze panes in excel mac online, to be office experts.

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.

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 Excel is a functional software that opens up great opportunities for working with data. Therefore, it is popular. The coursedemy.com team of experts has prepared a selection of the best Excel training courses.

There are free and also paid materials for users of any level. Excel courses vary in complexity and student certification. Some do not imply such. Others provide a certificate that has professional value and increases the chances of getting the desired position.

20+ Best & Free Online Excel Classes, Trainings, Courses of 2021

1. Excel for the Real World (Skillshare)

The course is aimed at entry-level users. It explains in simple terms how Excel built-in functions can help simplify the presentation and analysis of data. Teacher – Al Chen. He is the founder of KeyCuts, a business training and consulting company. Included in the Fortune 500.

Microsoft Excel course helps to master:

• Use and customization of the tape for individual needs;
• Structuring the file and sheets in the book;
• Fundamentals of Microsoft Excel (for example, formatting);
• Selection and auto-completion of data;
• Writing basic and most effective formulas, including VLOOKUP;
• Sorting and printing tables;
• Hidden paste capabilities through the use of Paste Special.

2. Microsoft Excel Course – From Beginner to Expert in 6 Hours (Udemy)

The course from a professor with more than 20 years of experience is Todd MacLeod. Suitable for beginners and advanced users. It will help to master Excel at the expert level, or the service will return the money.

Contains 83 lectures with a total duration of 6.5 hours. Provided with lifetime access. Excel training is multi-platform and ends with a certificate.

It is considering:

• Basic Microsoft Excel Classes: editing, entering, sorting and displaying data;
• The use of absolute, mixed and relative links;
• Task automation using Macros;
• Microsoft Excel integration with Microsoft Word;
• Removal of duplicates from Excel;
• Quick writing of formulas using the point-and-click method;
• Collecting data from the Internet and creating online forms.

3. Excel – Tips and Tricks (Linkedin Learning)

Designed for mid-range users. The teacher and author of the course is Dennis Taylor. He has over 25 years of experience in developing and teaching spreadsheets. The course is specialized.

What you will learn:

• Simultaneous input of data/formulas, creating diagrams with a key combination, presentation of all sheet formulas;
• Effective data entry and user lists;
• Input, editing, as well as a special date and time formats;
• Keyboard shortcuts for quickly applying commonly used number formats;
• Data management using the functions TRIM, Flasn Fill, TEXTJOIN;
• Selection and display of unique data;
• Design effective spreadsheets;
• Secrets of effective work with charts and pivot tables.

4. Best Excel Tutorials & Courses (Linkedin Learning)

The resource offers over 7,500 courses allowing teaching Excel. There are textbooks for those who begin to learn the software and confident users. There are Excel courses of general and specialized focus. A filter system is provided for convenience. Here are the best Microsoft Excel training programs online. Materials can be selected according to their level of ownership, type, and time allocated for completing tasks.

There are courses of such directions:

• fundamentals of Excel;
• mastering pivot tables;
• The use of conventional and advanced formulas/functions;
• Development of Power Pivot;
• Data management and analysis;
• Tips for increasing the efficiency of using Excel;
• Excel tutorials on working with macros;
• Creating schedules;
• Weekly tips on using software from experts;
• Data modeling.

5. Free Online Excel Classes (EDX)

The resource has collected training courses from leading educational institutions. For example, Harvard, Massachusetts, and Boston universities, as well as the Alexandria Library, the World Wide Web Consortium, and others. There are even educational materials from Microsoft. Courses are offered in English and Spanish. It is possible to obtain a certificate.

Directions:

• Introduction and Excel basics;
• Create powerful sheets;
• Data analysis (including Excel for financial analysis);
• Data visualization.

6. Best Online Excel Classes and Courses (Udemy)

Free Online Excel Classes For Mac

More than 6.5 million people study material on this resource. The site offers many Best Microsoft Excel classes of varying lengths. You can choose exercises in the form of tests or practical tasks. Here is the best + free Microsoft Excel Training, Courses, classes, certifications, tutorials and programs for 2021. After purchase, access to the materials is offered unlimited. There is also Free Excel Training.

Directions:

• Data analytics;
• Creating macros;
• Application of functions and formulas;
• Shortcuts and their use in Excel;
• Work with charts;
• Best Excel VBA Courses.

Another plus – you can choose different languages for video and subtitles. This is especially useful if you are learning a language or want to improve your proficiency.

7. Online Microsoft Excel Course – Basic & Advanced (GoSkills)

Suitable for people with busy schedules. This is basic and advanced excel training. It consists of 52 lessons, each of which includes a video lesson for 3-6 minutes and practical materials. One lesson takes about 30 minutes. The total training time is 26 hours. GoSkills Certified.

The course reviewed:

• use of mathematical, logical, static and text functions of MS Excel;
• Application of the functions VLOOKUP, MATCH, HLOOKUP, and INDEX;
• Sorting and filtering data for quick search;
• Work with charts;
• Automation of repetitive tasks using macros;
• Creating and formatting pivot tables;
• Data verification to limit their input;
• Setting up a document for printing.

8. Learning Excel 2019 (Linkedin Learning)

Maybe Best Microsoft Excel Certification online course from David Rivers, whose customers are Corel. Focused on the fundamental functions of the program. Suitable for beginners.

Microsoft Excel Training Examines:

• Data entry capabilities;
• Autocomplete in Excel 2019
• Use of data formats: text, numeric, date and time;
• Fixing cells;
• Adding diagrams;
• Providing access to files, sending by e-mail, printing documents.

9. Microsoft Excel Tutorial – Top 10 Excel Formulas to Work Smarter (Skillshare)

An excellent course for intermediate users. It is specialized. Excludes dispersion of attention, focusing on mastering formulas. Created by a certified Microsoft Excel expert with 15 years of training experience. The course contains 13 video lessons with a total duration of 3 hours. A full lecturer workbook is provided.

The course reviewed:

• Useful and advanced Excel 2013 functions for text;
• Accounting for exceptions using SUMIFS, COUNTIFS, AVERAGEIFS;
• The use of nested IF functions;
• Guarantee the reliability of reports using the logical function IFERROR;
• INDEX and MATCH for flexible search and complex tasks;
• Ranking with FREQUENCY and SMALL & LARGE;
• Database functions;
• Application of the OFFSET function;
• Advanced function SUNPRODUCT;
• Dynamic search using VLOOKUP and HLOOKUP.

10. Excel Training – Zero to Hero (Skillshare)

Quickly introduces Excel features. 24 lessons, with a total duration of 2 hours, will make an expert out of a novice. The course provides practical exercises. For each of them, there is a file with a finished table that needs to be changed in a certain way.

During the course, you have to clear dirty imported data, create an inventory table, order form, etc.

You will learn:

• Configure the file for printing on different sheets;
• Add images and quotes, as well as make templates for the latter;
• Draw up a table (borders, lines);
• Create Pivot tables;
• Delete dirty data, formatting, empty columns/rows;
• Create powerful spreadsheets, sort them by date, price or name;
• Find and remove duplicates;
• Repeat formulas;
• Make graphs/charts.

11. Ultimate Excel Course — Advanced Formulas for Analysing Data (Skillshare)

A short but comprehensive course from an Excel expert with 17 years of experience, as well as the creator of Computergaga. Represents the 7th grade from the Ultimate Excel Course series. This is one of the Best Microsoft Excel Courses, designed for middle-tier users. In 7 lessons, he teaches the use of the most effective formulas. The total duration of the videos is 44 minutes. Students are provided with the Excel files used by the teacher.

The course reviewed:

• Use of analytical functions SUMIF, AVERAGEIF and COUNTIF;
• The use of the above functions in the presence of a condition (for example, a time period);
• Use and hidden features of SUMPRODUCT;
• Typical and extended use of the AGGREGATE function.

12. Excel Skills for Business Certification (Macquarie University)

For those who are looking for a tool for professional development, we recommend paying attention to this resource. Offers applied training. Upon completion, a certificate is issued. The course is designed for beginners. For 6 months of training, you will become an Excel Expert.

Features:

• Learn Microsoft Excel remotely;
• Independent determination of deadlines for assignments;
• English language course allows you to use subtitles in Hungarian, Arabic, Vietnamese, or English;
• The subscription provides for the possibility of a pause in training, or its cancellation at any time;
• Best Microsoft Excel Certification online with an authoritative document on training;
• Contains 4 courses: Excel Fundamentals, intermediate levels (1 and 2), and advanced.

13. Free Excel Tutorial (Excel Easy)

A great resource for people who are completely new to Excel. It is a study guide. By focusing on it, you will be able to understand what functions and features of the software are worth exploring, and in what sequence. This information is also presented on the site. Filling the resource is enough to learn Excel yourself.

The site offers full Excel training free. Another advantage is the availability of illustrations that accompany the information presented. This makes training as affordable as possible. A separate section is presented, “300 examples”, which clearly shows the answers to popular questions.

14. Free Online Excel Training (TrumpEXCEL)

A full course in MS Excel with free access. Created by an expert with the status of Microsoft Excel MVP. Divided into 7 modules. In total, they contain 26 Excel training videos. The total duration is 12+ hours.

What the course will teach:

• Input, editing, and also the formatting of data and numbers;
• Autocomplete (standard, using custom lists and flash fill);
• The use of formulas of different orientations and their combination;
• Checking, sorting and filtering data;
• Work with standard and dynamic diagrams;
• Creating, formatting and editing data in pivot tables;
• Writing macros and getting to know the VBA Editor;
• Fixing cells and formulas in Excel.

15. Microsoft Excel Course – from Beginner to Advanced (Udemy)

Suitable for users of all levels. Created by Microsoft Certified Trainer, Kyle Pew. For 17.5 hours in an accessible form explains how to use Microsoft Excel 2016 as efficiently as possible. A 30-day money-back guarantee is valid in case of dissatisfaction with the exchange rate. Assumes Excel certification.

The course reviewed:

• The use of the functions VLOOKUP, AVERAGE, SUM, MATCH, IF, INDEX and others;
• Microsoft Excel add-in and Power Pivot tables;
• Management and organization of large volumes of data;
• Creating easy-to-read and analyze spreadsheets;
• The use of pivot tables and the creation of a dynamic report with their help;
• Automation of frequent actions using macros and VBA;
• Achieving the cleanliness of formulas through an audit.

16. Free Excel Training for Beginners (Linkedin Learning)

Another course from Dennis Taylor. It is large-scale and allows the beginner to become a professional. It includes both background information (interface) and specialized (macros).

What the Microsoft Excel training program teaches:

• Data entry: methods and use of autofill;
• Formulas: creation, copying, application of absolute, relative and mixed links, as well as SUM and AVERAGE functions;
• Use of graphs: types of diagrams, their formatting, work with elements, intracellular graphs;
• Formulas linking worksheets and books;
• Using the functions COUNTIF, VLOOKUP, IF, relational operators;
• Protection of books, sheets, and cells;
• Analysis, filtering, separation and verification of data;
• Creation of pivot tables;
• Work with macros.

17. Excel 2019 Essentials (Pluralsight)

A short and comprehensive course for beginners. Total duration – a little more than 2 hours. During this time, the key features of the Excel interface and software functions are considered.

The course reviewed:

• Excel interface: appointment, features, and use of menu tabs;
• Backstage view: saving, exporting, printing and providing access;
• Data and sheet management: quick navigation, insertion, input, editing, selection of data or multiple ranges;
• Row and column management;
• Data formatting: currency, numerical, accounting, percentage, and date formats, as well as auto-completion and Flash Light;
• Work with totals: automatic calculations, autosum, auto-complete with formulas;
• Saving taking into account file formats.

18. Advanced Excel Formulas & Functions (Udemy)

Perhaps the best Advanced Excel Course. Teacher – Chris Dutton. His work was noted by Entrepreneur, Microsoft, HuffPost, and the New York Times. The course teaches 75+ formulas. Assumes certification.

In the course there are:

• Writing, auditing and detecting errors in formulas;
• Use of hotkeys;
• Creating a drop-down menu and checking data;
• Conditional and logical operators: using IF, IS, NOT &, IFERROR, AND / OR;
• Randomization and static formulas: SUMPRODUCT, SMALL / LARGE, SUMIFS, AVERAGE, IFSRANK / PERCENTRAN, COUNTIFS;
• Links and search using VLOOKUP, INDEX, MATCH, XLOOKUP;
• Band management through the use of OFFSET / COUNTA;
• Arrays of formulas: use and definition of a constant, array formulas;
• Functions related to date and time;
• Formatting based on formulas.

19. Complete Excel Course – Excel Essentials for the Real World (Udemy)

Designed for users of different levels. It allows you to learn Microsoft Excel quickly, subsequently efficiently and seamlessly analyzing data. Written based on the author’s 15 years of experience in finance. Lecturer (Leila Gharani) is an expert in Microsoft Excel MVP. Students receive a certificate.

Excel Essentials course teaches:

• Navigate in large databases;
• Automate analysis using effective formulas (VLOOKUP, ROUND, IF and others);
• Clean tables from dirty data using hidden Excel functions;
• Save working time using life hacks;
• Create accurate and compelling reports;
• Use the Get & Transform tool to import and transform data;
• Use pivot tables/charts, as well as slices and timelines to create interactive reports.

20. Excel – Advanced Formulas and Functions (Linkedin Learning)

Suitable for confident users. The course was created by a recognized MS Excel expert, Dennis Taylor. It is aimed at achieving maximum efficiency in the application of formulas, including the most powerful ones.

What you will find in the course:

• Changing the formula without editing the values and vice versa;
• How to tabulate data on multiple sheets using a 3D formula;
• The capabilities of the functions IF, AND, NOT, OR, IFS;
• Help functions: CHOOSE, VLOOKUP, HLOOKUP, SWITCH, XLOOKUP, MATCH / INDEX (separate and shared use);
• Tabulation of data using the criteria SUMIF, COUNTIF, as well as AVERAGEIF;
• Text functions (for example, removing unnecessary spaces using TRIM);
• Help functions OFFSET, as well as INDIRECT;
• Obtaining information through CELL and INFO.

21. Data Visualization with Advanced Excel (Coursera)

The course is taught by Alex Mannella, a former director of the audit firm PwC. The course is capacious. Teaches specialized skills in the analysis and visualization of large data sets. Then you do not need to create PowerPoint presentations.

Starting with the built-in Excel tools, it teaches you how to build complex graphs/reports and combine them into dynamic panels. Designed for beginners. However, for experienced professionals – this is new knowledge in Excel. There is a certification.

In the course there are:

• Creation of databases and models (including relational);
• Analytical methods: modeling, scenario analysis, and sensitivity;
• Data visualization: selection, creation, and presentation of charts/tables;
• Creation of dynamic information panels.

22. Microsoft Excel Course – Introduction to Data Analysis (Coursera)

Partner of the course is the University of Rayk. The teacher (Sharad Borle) is an assistant professor at the Johns Graduate School of Business. With this course, you will learn Microsoft Excel for 4 weeks and 20 hours of classes. You can get a certificate. Available with English, Arabic, and Spanish subtitles.

Microsoft Excel Training For Beginners

In the course there are:

• Reading data and formatting tables;
• Use of arithmetic and logical functions of Excel, their transfer and copying;
• Organization of data through the functions IF, VLOOKUP, HLOOKUP, as well as RANDBETWEEN;
• Data filtering;
• Creation and application of pivot tables with numerical and categorical data;
• VLOOKUP for sheets;
• Advanced features for creating graphs, as well as histograms, linear, and pie charts of the summary/dot type.

Free Excel Formula Training

As you can see, training courses are presented in abundance. The main thing is to find the one that you like and allow you to achieve the desired heights. We hope that our selection will help.