excel

Excel is a big subject. Learn to do what?

Here are some general links to Excel learning materials (mostly free). These should keep you busy for a while.  Ask you you have questions about specific features, functions or areas.

Responding to “TEACH ME EXCEL!”  2016 04 26   Oz du Soleil

https://ozdusoleil.com/2016/04/26/sssveda-day-24-responding-to-teach-me-excel/

How do you respond to the request “Teach me Excel””

That’s a tough question. One thing that needs to be made clearer to the public is that:

Excel is a development tool.

It’s more that something for budgets and making lists. Thus, with a vague request like “teach me Excel” it’s hard to know if the person will need financial modeling, data cleansing, web scraping, database connection, data vis, payroll management … etc.

.

What Is Excel?**** 2016 08 01   Oz du Soleil

https://ozdusoleil.com/2016/08/01/what-is-excel-excel-ignited-day-1-sssdeva-2/

I’ve been asked this over the years by people who are curious about Excel or want some insight into what Excel can do.

Answering the question is difficult because of the endless ways that people have used Excel to serve their needs.

In this video I answer “What is Excel?” several ways, in summary:

– Excel is a development platform for managing data

– Excel is the second best software for ANY purpose

– Excel is just a tool that serves a purpose.

.

What is your current skill level.

.

Are you willing to pay, or want just free materials?

.

Tour of Excel’s Ribbon & Other Structures****2016 08 03   Oz du Soleil

https://ozdusoleil.com/2016/08/03/tour-of-excels-ribbon-other-structures-excel-ignited-day-2-sssveda/

Here I cover each of the main tabs, showing the most important features that an Excel beginner should know, and I point out features that are more advanced or specialized.

The video includes brief demos of key Excel features, including: conditional formatting, sort, filter, Find/Replace, and number formatting.

Chris Macro’s survey of how professionals use Excel’s Quick Access Toolbar:

2:35 Opening Excel

4:00 Pinning a working to the Recent menu

5:01 Changing the Office Theme to black

6:00 The Home tab

6:10 Format Painter

7:08 Change font

7:44 Cell Borders

8:07 Cell Alignment

8:25 Wrap Text

8:50 Number Formats

9:30 Conditional Formatting

10:44 Format as Table

12:18 Insert Row/Column

12:49 Find and Replace

13:54 The Insert Tab

13:59 Pivot Table

14:50 Insert Shapes

15:13 Insert Charts

15:28 Slicers

16:00 Text Box, Word Art

16:45 The Draw Tab

17:08 The Page Layout Tab

17:14 Margins, Orientation

17:38 Scale to Fit (controlling how many pages a worksheet prints out on)

18:37 Turn off grid lines

18:49 Aligning objects

20:00 The Formulas Tab

20:45 Formula Evaluator

21:03 The Data Tab

21:03 Get & Transform

21:34 Sort, Filter

25:22 Text-to-Columns

25:43 Flash Fill

26:45 Data Validation: Drop Down Lists and other ways to prevent input of bizarre data

28:26 The Review Tab

28:26 Sheet and Workbook Protection

29:06 The View Tab

29:06 Show or hide: Page breaks, Page Layout, Formula Bar, Headers

29:30 Freeze Panes

29:44 The Developer Tab

29:44 VBA window and Form Controls

30:26 The Quick Access Toolbar (QAT)

31:40 Chris Macro’s QAT Survey

31:52 Closing Summary

.

Excel 365(2019) for Windows training from MS

https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb

Quick start

Intro to Excel

Rows & columns

Cells

Formatting

Formulas & functions

Tables

Charts

PivotTables

Share & co-author

Take a tour    Download template >

Formula tutorial    Download template >

Make your first PivotTable    Download template >

Get more out of PivotTables    Download template >

.

MS Virtual Academy (MVA)-Microsoft Excel 2013 Essentials 2hr course freehttps://docs.microsoft.com/en-ca/learn/

course guides students through typical Excel use and shows them how to get the most out of Excel features to work effectively and efficiently with workbooks, worksheets, formats, numeric and text functions, and charts.

.

One Way to Get Good with Excel**** 2016 04 28   Oz du Soleil

https://ozdusoleil.com/2016/04/28/sssveda-day-25-one-way-to-get-good-with-excel/

One way to get good with Excel is to dig into the real-world spreadsheets that other people built. Try to understand their formulas and layout. See how formulas and features are woven together.

Here are some Excel power users who make their spreadsheets available for downloading. Check them out.

Kevin Lehrbass

Alex Powers: http://itsnotaboutthecell.com/

Chris Macro: http://www.thespreadsheetguru.com/

ExcelIsFun: https://www.youtube.com/user/ExcelIsFun/videos

Download the workbook: http://datascopic.net/cafeteriarandomizer

.

Intro to Excel Ignited (Illuminating Excel for Beginners)   2016 07 31   Oz du Soleil 

https://ozdusoleil.com/2016/07/31/intro-to-excel-ignited-illuminating-excel-for-beginners/

My regular work had focused on complex Excel skill and data management needs. But Excel Ignited will start with the most basic in Excel. That initial spark that grows into a roaring fire to help us get at the data we need.

.

XelPlus Lelia Over 200 Excel YouTube Tutorials in ONE Placehttps://www.xelplus.com/free-excel-tutorials/

e learn 2020 05 01- 200+ YouTube Tutorials Leila Gharani XelPlus- List15 updated monthly.xlsx (downloaded)

The links in this file are updated on a monthly basis. Check back to get the latest file (download link).

.

! 10 Microsoft Excel Tips Every User Should Know2019 10 09   Andre Da Costa

https://www.groovypost.com/howto/essential-microsoft-excel-2016-tips

Excel 2016 is a vast cornucopia of tools that let you manipulate, organize, analyze, and format data in a spreadsheet. Although Excel has been the lifeblood of many a corporate office, research firm, and financial outfit, Excel can be equally as handy and powerful for everyday users. Whether you are a home user managing a household budget, a small business owner managing inventory or a school teacher taking daily attendance, Excel will make your life easier if you learn to use it. Let’s check out those tips.

.  1. Resize Columns and Rows

.  2. Add or Remove Columns, Rows or Cells

.  3. Freeze Panes

.  4. Change Text Alignment in Cells

.  5. Use Cell Protection to Prevent Editing an Area of the Spreadsheet

.  6. Apply Special Formatting to Numbers and Currency in Cells

.  7. Five Essential Excel Functions You Should Know – Sum, Average, Max, Min, Count

.  8. Create and Manipulate Charts

.  9. Reveal Formulas

.10. Maximize Printing Options when Printing Large Workbooks

.

Welcome to Excel – Take a Tour (MS)

https://templates.office.com/en-US/Welcome-to-Excel-TM10000137

If you’re new to Excel, or even if you have some experience with it, you can walk through our most requested features in this tour. With real-world examples and helpful visuals, you’ll be able to sum, fill, sort, filter, and pivot like a pro. Please note that this template only applies to Excel 2013 and 2016 for Windows. This is an accessible template.

.

**Online Excel Lessons****** 2013 11 07 Jeff Lenning ****http://www.excel-university.com/online-excel-lessons/ ****I’m pleased to announce the immediate availability of the Excel University Chapter Evaluation Courses, which are online Excel lessons that cover a single chapter and topic and can be used to evaluate our online Excel training. These mini-classes typically take about 30 minutes to complete, and contain a lecture video, homework activities, the practice Excel workbook, an exam, a certificate of completion, and additional resources.

.

Ron De Bruin’s Excel 2003-2016 Function Bible -

http://www.rondebruin.nl/efb/efb.htm

You can use the link below to download all the 468 example files and a Function Index workbook so it is easy to search and open the example workbooks. When you open the Excel Function Bible Menu workbook you will find a worksheet for each function classification group but I also add the classifications on my site with a brief description, check out the links below the download. Download the Excel Function Bible (18.4 mb)

.

Step-by-Step Learning Videos From GCF LearnFree****https://www.makeuseof.com/tag/best-excel-tutorials-courses-beginners/

The Goodwill Community Foundation’s LearnFree online academy is an outstanding accompaniment to Microsoft’s official course. It is broken down into similar sections and videos, all of which are free on YouTube.

Again, it’s the careful break-up of learning Excel that is key here. GCF LearnFree turns it into a step-by-step process, with a total of 29 sections. Each section has a video, a long article, as well as recommended exercises.

.

**The Start-to-Finish Giant Tutorial by Excel Easy******http://www.excel-easy.com/

it’s flabbergasting that such a great tutorial is available for free.

You start with the introduction, move on to the basics, learn how functions work, start analyzing data with Excel, and finally learn Excel VBA at the advanced stage. Each of those has the simplest explanation possible in the form of a single page, with screenshots and easy language.

As if that wasn’t enough, Excel Easy then gives you 300 examples of common tasks you can automate in Excel. Get ready to become an Excel macros ninja!

.

Office Online Training Courses Free & Paid, Excel Word & Outlook–

http://www.myonlinetraininghub.com/microsoft-office-online-training-courses

Excel 2016 Tutorial: A Complete Guide on Excel for Anyone Sali Kaceli (video 2:04hr).

MyExcelOnline -

https://www.myexcelonline.com/free-excel-online-training-courses#webinars

Functions & Formulas    Learn The MUST KNOW Excel Formulas to ADVANCE your Excel skills!

    IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...!

Macros & VBA

     Learn How To Record MACROS & Write VBA Code within 1 HOUR!

    AUTOMATE repetitive & boring tasks with a single press of a button that will SAVE YOU Time & Money!

Pivot Tables

    Analyze Tons of Data With a Couple of MOUSE CLICKS!

    Create interactive EXCEL DASHBOARDS without having to memorize Formulas or write code!

.

Introducing Spreadcheats – Become Supergood with Excel in 30 days                    2008 10 31

https://chandoo.org/wp/tag/spreadcheats/

Starting next week, PHD is going to feature a 30 post series on spreadcheats. The purpose of these posts is to make day to day spreadsheeting a breeze. Each post will be less than 200 words in size and aspires to make your day at office a little bit more productive. I have already identified

.

Linkedin Learn Excelhttps://learning.linkedin.com/in/microsoft-excel?trk=par_acq_MSFThelp-excel-tc-help-seealso-c017-v00114_learning&src=mi-inprod&veh=excel-help&utm_source=microsoft&utm_medium=help-integration&utm_campaign=par_acq_MSFThelp-excel-tc-help-seealso-c017-v00114_learning

Advance your knowledge of Microsoft® products with LinkedIn Learning. 30 day free trial, followed by paid subscription

You can learn

   • Basics and fundamentals           • Worksheet management

   • Financial functions           • Data management and analysis

   • Macros in depth              • Advanced formulas and functions

   • Database creation           • Master pivot tables, formulas

   • and more

.

Microsoft Excel 2016 Quick Start Guide - Computer-PDF.comhttps://www.computer-pdf.com/office/excel/401-tutorial-microsoft-excel-2016-quick-start-guide.html

New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics. A PDF file by Microsoft

Introduction to Excel 2016****https://www.computer-pdf.com/office/excel/464-tutorial-introduction-to-excel-2016.html

This booklet is the companion document to the Excel 2016: Intro to Excel workshop. It includes an introduction to the Microsoft Office 2016 interface and covers the various aspects of creating, formatting, editing, saving, and printing a document in Excel

Advanced Excel ToolsExcel 2016 ****https://www.computer-pdf.com/office/excel/466-tutorial-excel-2016-advanced-excel-tools.html

This booklet is the companion document to the Excel 2016: Advanced Excel Tools workshop. PDF file by Kennesaw State University.

Excel 2013: Advanced Excel Tools****https://www.computer-pdf.com/office/excel/369-tutorial-excel-2013-advanced-excel-tools.html

Download free Microsoft Office Excel 2013 Advanced Excel tools, course tutorial training, a PDF file by Kennesaw State University.

.

Microsoft’s Official Excel Video Training****https://support.office.com/en-us/article/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb

The new Office Basics training videos are the official tutorials for newcomers, covering everything you would need to know. I especially like how Microsoft has broken down each segment, like Quick Start, Intro to Excel, Add and Format Charts etc. All videos are free to stream as well as download, in case you want offline backups or to train teams.

.

MicrosoftTraining.net

Excel Intermediate 2013      Excel Advanced 2013 ****

Excel VBA Introduction 2010         Excel VBA Intermediate 2010 ****Excel VBA Advanced 2010  Excel Advanced – For Power Users 2010 ****

Excel Pivot Tables 2010      Excel PowerPivot 2010 ****

Excel Charting 2010  Excel Dashboards for Business Intelligence 2010 ****Excel Forecasting and Data Analysis 2010 .

Mike Girvin´s ExcelIsFun YouTube channel

https://www.youtube.com/channel/UCkndrGoNpUDV-uia6a9jwVg

Free Excel Education for the world from Excel MVP and Highline Professor, Mike Girvin. Search for any video topic you want! Excel. Formulas. Charts. Dashboards. PivotTables. Dynamic Arrays. Power Query. M Code Formulas. Power Pivot. DAX Formulas, Power BI. Power BI Desktop. And Much More! It is all at the excelisfun channel here at YouTube : )

.

Excel Productivity Guidehttps://excelchamps.com/excel-productivity-guide/

With this guide, you can take your excel skills to a whole next level. It will help you to win at your daily work using some smart Excel tactics....·          30 Useful Excel Tips which will help you to save your a lot of time and you will perform your daily tasks like a champ....·          80 Excel Keyboard Shortcuts for daily use. You can learn shortcuts for your faorite tasks and become super speedy in your work....·          20 VBA Codes for you to automate your simple daily tasks. You can use these codes instantly once you add them in your VB editor....·          100+ Excel Functions for daily use. These functions tutorials are fully loaded with downloadable sample files and simple examples to understand.****...·          4 Specific Excel Templates for daily use. These are automated excel templates to help you to track your data in no time.

.

ExcelGuru free‘DIY BI’ e-Book

https://www.excelguru.ca/blog/2017/04/06/diy-bi-e-book-launches-tomorrow/

If you haven’t already, sign for our mailing list to receive your copy!  You can do so at the bottom of this post.

Those e-Books will be released in the following order:

  *  DIY BI Tips, Tricks and Techniques for Excel

  *  DIY BI Tips, Tricks and Techniques for Power Query

  *  DIY BI Tips, Tricks and Techniques for PowerPivot

  *  DIY BI Tips, Tricks and Techniques for Power BI

.

ExcelTip.com Categories 

• http://www.exceltip.com/

Tips Tips       Excel General Tips

Excel Keyboard Shortcuts Tips     Excel Generals Tips

Excel Customizing Tips      Excel Tools Tips

Excel Files Tips       Excel Worksheet, Workbook Tips

Excel Range Name Tips    Excel Information Tips

https://web.archive.org/web/20190605032920/http://spreadsheetpage.com/index.php/tips

http://www.contextures.com/excelfiles.html#FN0022

Excel Sample Templates -- AlexJ           Excel Sample Templates -- Roger Govier

Excel Sample Templates -- Ron Coderre

.

Use Excel? Excel basics for beginners****2019 02 23   Yoda Learning

https://yodalearning.com/tutorials/excel-basics-guide-for-beginners/

In this blog, we will learn Excel basics guide for beginners, Learning Excel basics are just a start to what’s in store to solve a lot of our daily problem and save time. Microsoft Office is very useful for a wide range of applications. It features calculation, graphing tools, pivot tables, and a macro programming...

.

Things you should learn in Excel Course      **** 2019 02 13   Yoda Learning

https://yodalearning.com/tutorials/things-you-should-learn-in-excel-course/

The essential skills that a competent business Excel user should be aware of are Formatting & basic formulas, Excel shortcuts, VLOOKUPS & conditional statements, Data analysis like filtering, sorting, and analyzing data, Data visualization like tables, charts, and dual axis charts, What-if-analysis and Pivot tables. The complete Excel course is bifurcated into three major parts viz. Beginner Excel Course,...

.

Learn Any Area of Excel using these 80 Links**** 2011 12 12

Last week I asked, **What is one area of Excel you want to learn more?**

More than 250 of you responded to this question. Many of you shared your areas of interest thru comments, quite a few of you also emailed me personally.

You told us what you want to learn, the next step is logical. We share some of the best tutorials & examples with you so that you can learn. In this post, we have presented more than 75 links, to help you learn your area of focus.

I have divided this in to 16 areas. In each area, we have identified (upto) 5 best links for you to learn more. I have also recommended 1 or 2 training programs that make you awesome in that area. Plus, if we found any excellent external resources, we have highlighted them as well.

So go ahead and learn Excel..

Here is another resource. It looks like you can subscribe to the site for $15 per month. So you can use all of their online courses, but apparently you can also download all of their course booklets.

.

! Custom Guide Courseware

https://www.customguide.com/

This site is intended for both individuals and organizations. Individual can sign up for $15 per month, get unlimited access to site. Go crazy for one month doing online courses, and download all relevant e-books, even if you can’t work through them right now.

$15/month/user all access to site.

$3600/50users ($70each)

Everything You Need to Train:

    Interactive Training Interactive eLearning

    Learn by doing—not watching—with interactive simulations.

    Interactive Training Customizable Courseware

    Course kits contain everything you need to teach amazing classes.

    Interactive Training Free Quick References

https://www.customguide.com/training - Interactive e-Larning

You are supposed to pay, but you can view most of the lessons free. Here are a few examples. Many more

Excel 2019 Basic: Fundamentals, Edit a Workbook, Basic Formulas, Basic Formatting, Insert Objects, Manage Worksheets

Excel 2019 Intermediate: Charts, Print and Distribute, Intermediate Formulas, Manage Data, Tables, Intermediate Formatting, Collaboration

Excel 2019 Advanced: PivotTables, PivotCharts, Troubleshoot Formulas, Advanced Formatting, Advanced Formulas, Analyze Data, Macros

Office 365 Essentials: Fundamentals, Editing, Formatting, Word, Excel, PowerPoint

Office Online: Fundamentals, OneDrive, Word, Excel, PowerPoint, Outlook Online

Word 2019 Basic: Word Fundamentals, Work With and Edit Text, Format Text and Paragraphs, Format the Page

Word 2019 Intermediate: Tables, Graphics, Styles, Themes, and Templates, Long Documents

Word 2019 Advanced: Collaborate with Word, Advanced Documents, Mailing Documents

.

https://www.customguide.com/quick-reference

Free Quick References! For download:

Access 2016 Basic, Intermediate (Access 2013)

Excel 2019 Basic Intermediate Advanced (Excel 2016, 2013)

Outlook 2019: Basic Intermediate (Outlook 2016, 2013)

PowerPoitn 2019: Basic, Intermediate (PowerPoint 2016 2013)

Project, SharePoint, Skye, Teams, Zoom

Word 2019: Basic, Intermediate, Advanced (2016, 2013

.