Excel 2013

Online Excel training is designed to create a strong foundation for using the world's most popular business software.

4.61 (2506 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel 2013
6,197
students
12.5 hours
content
Aug 2020
last update
$54.99
regular price

What you will learn

Become a Master in the Work Place using Excel 2013

Description

Online Excel training is designed to create a strong foundation for using the world's most popular business software as a place to organize and analyze information. Participants in this course will start by establishing fundamental skills and best practices essential for using Excel, and will leave with a working knowledge of advanced formulas and functions, as well as key tools to organize, format, and manage data in a spreadsheet. This  12 hour online Excel course is designed for individuals, Career Changers, and skill enhancement.

Content

Essentials and Intro to Formulas and Functions

Introduction and the Ribbon
Interactive Guides
Navigating
QA Toolbar
More QA Toolbar Part
Formulas
Saving Files
Functions
Continued Formuli
Troubleshooting Issues
Compatibility Issues
Course Check List

Formatting, Spreadsheet Design, Page Setup and Printing

Fill Handle
Copying and Pasting
Auto-fill Series Formatting and Styles
Styles and Themes
Templates
Working with Worksheets
Copying Entire Worksheets
Custom View
Spell Check in Excel
Working with Large Worksheets
Split Screen
Printing
Page Layout View
Course Check List

List/Table Essentials and Charting

Flash Fill
Well Defined List
Sorting
Sort by Then
Formatting
Format as Table
Filtering
Multi-Field Filtering
Remove Duplicates
Inserting Automatic Subtotals
Column Line Charts
Pie Chart
Formatting Charts
Chart Templates
Recommended Charts and Quick Analysis Tools
Printing Charts
Sparklines
Review
Course Check List

Importing Data, Pivot Tables, Protecting and Linking Data

Importing Data from Sources
Importing Database File
Pivot Tables
Custom Pivot Tables
Advanced Pivot Tables
Pivot Table Exercise
Formatting Pivot Tables
Slicer Tool
Pivot Charts
Filtering Charts
Data Validation
Rules
Conditional Formatting
Advanced Conditional Formatting
Manage Rules of Conditional Formatting
Conditional Formatting Data Validation
Protecting Worksheets
Comments
Printing Comments
Linking Data Between Worksheets
Course Check List

Creating Functions

Named Ranges
Logical Functions
If Functions
Nested Functions
Lookup Functions
V Lookup
Database Function Sumif
Database Function Averageif
Database Function Sumifs
If Error Functions
V Lookup Range
Date Functions
Course Check List

Advanced Tools

Consolidate Data
Consolidate with Different Layouts
Intro to Goal Seek Tool
Goal Seek Tool
Installing Solver Tool Add-In
Solver Basic Sheet
The Solver Tool
PMT Data Table Worksheet
Data Table Command
Two Variable Data Table
Scenario Manager
Adding Developers Tab
Recording a Macro
Running Your Macro
Recording Macros with Relative References
Record a Formatting Macro
Better Formatting Macro
Add Form Buttons
QA Macro Buttons
Introduction to Skydrive
Skydrive
Course Check List

Reviews

Alexandra
February 28, 2023
Perfect pacing, very useful information and a great introduction course for those with a little experience and/or complete newcomers, I recommend this to anyone wanting to learn more about Excel!
Bruna
August 24, 2022
O curso é muito bom, as explicações e as dinamicas são ótimas, mas, poderia ter mais opçoes de idiomas para as legendas. isso facilitaria o aprendizado e tomaria menos tempo para conclusão do modulo.
Angela
July 20, 2022
I wish there was a test at the beginning so that someone with some excel knowledge can get some exceptions for some lessons.
Christos
June 25, 2022
Till now it seems amazing and flows perfectly. I hope it is going to be the same once more complicated things need to be explained.
Sheetal
December 29, 2021
It was amazing learning experience. Understood Macros like never before. Great content and well explained training.
Vinicius
December 11, 2021
Facilita bastante o aprendizado de maneira mais confortável para o aluno, otimiza tempo, sendo de fácil acesso e aproveitando o tempo entre viagens e projetos para dedicar tempo no aprendizado.
Becky
December 9, 2021
This guy is entertaining and keeping me interested in the course! I'm actually really enjoying learning about excel.
Stefanos
September 14, 2020
Great course, it really improved my knowledge of excel and it helped me to get over with everyday staff faster!!!
Aaron
July 2, 2020
Excellent Methodology, excellent exercises and great Content. This training is really useful for anyone!
Carole
April 27, 2020
Very good, as it starts right from the very beginning for somebody like myself who knows nothing about Excel and it is at a good pace and explained well
Araceli
April 15, 2020
Si fue una buen elección ya que es bastante claro hasta ahora, el exponente es muy explicito. Me encanto mil gracias por ser tan claros.
Nor
April 7, 2020
This course is a step by step course which makes it clear what I am learning. Unfortunately, many of the videos are blurred especially, for the first few sections and I have to keep switching to my own Excel file. It was very troublesome and uncomfortable having to look at blurred videos most of the time. Other than that, Fernando was an amazing host! I learned a lot from this course. Thank you!
Richard
April 6, 2020
It was a very good course since I discovered some new things which is useful for my projects, excellent explanation from the exhibitor since it helped me to know step by step the procedures while practicing.
Shannon21
April 4, 2015
I am very impressed by this course. I feel I have enough knowledge that I will be able to work with Excel in my new job. Thanks much, Sue
Pamela
March 30, 2014
I've tried other learning methods, but afterwards I can't remember how to do it.This course has taught me in a way that I have retained the information and have the knowledge to work in Excel with confidence! Thank You!

Charts

Price

Excel 2013 - Price chart

Rating

Excel 2013 - Ratings chart

Enrollment distribution

Excel 2013 - Distribution chart

Related Topics

58489
udemy ID
6/5/2013
course created date
2/8/2020
course indexed date
Bot
course submited by