Beginner Microsoft Excel 2013 / 2016 Data Analysis (Udemy.com)

Beginner Microsoft Excel 2013 / 2016 training: Excel spreadsheet based data analysis using formulas

Created by: Brian Jackson

Produced in 2017

icon
What you will learn

  • Create simple Excel spreadsheets
  • Use Excel to produce charts and graphs
  • Format Excel reports for printing

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 96 / 100

icon
Course Description

Want to learn Excel but you're afraid you don't have the time?
Or maybe you're worried that Excel will be too complicated.
Then again, maybe you already tried but got bogged down wading through hours of detailed training material.
Learn Microsoft Excel 2013/2016 the Fast and Simple Way
Maybe it's time you tried the fast and simple approach to learning Excel... and do it all in under 2 1/2 hours.
Hi, my name is Brian Jackson and I'd like to teach you Excel the fast and simple way, by focusing on the features of the program most commonly used in simple spreadsheets. We'll begin with the basics:
  • Starting, Stopping, Saving, Windows and Menus
  • Assigning Values to Cells & Performing Arithmetic Operations
  • Relative and Absolute Cell References and Ranges
  • Common Math Functions: SUM, AVERAGE, MIN, MAX & COUNT
  • Editing Columns, Rows and Cells
  • Formatting Columns, Rows and Cells
That's all it takes is 6 lessons to learn the basics, then the section concludes with a super simple sample baseball spreadsheet.
Go Beyond the Basics to Add Some Polish
In the following section you'll learn more advanced techniques which you can use to make your spreadsheets shine:
  • Working with Worksheets and Workbooks
  • Freezing Rows and Columns
  • Functions
  • Using Date Functions to Make Monthly Projections
  • Sorting
  • Conditional Formatting
  • Charts and Graphs
  • Formatting and Printing Reports
The course concludes with 2 sample projects in which we construct book revenue and Udemy review tracking spreadsheets.
Are You Finally Ready to Learn Excel?
If you're ready then come along with me and let me teach you Excel the fast and simple way...
---BrianWho this course is for:
  • This course is intended for those new to Excel
  • This course is not appropriate for anyone possessing prior Excel knowledge
  • This course demonstrates the use of Excel on Windows 8.1

icon
Instructor Details

placeholder

I was born the middle of the last century in Los Angeles, California. After moving for a time to the Silicon Valley, I graduated from Humboldt State University amid the redwoods of Northern California.
Two weeks after graduation I was working as a computer systems programmer for Lockheed Missiles and Space (LMSC) back in the Silicon Valley. Two months after that and I was married as I have been happily ever since (for 38 years).
After 14 years at Lockheed I moved from working on IBM mainframes to using PCs running the Unix operating system and encountered a thing called the Internet. Cisco Systems seemed to be the right place to work, so I joined the company as their 650th employee. Eleven years later Cisco had grown to over 20,000 employees.
I retired at the age of 48 and instantly became bored!
Throughout my professional career I'd always enjoyed both writing and providing technical training. So, I attended creative writing classes at my local junior college and began to write.
I managed to write and self-publish a handful of books, but things didn't take off until my wife, Melanie Jackson, an established author with a New York company, left traditional publishing to join me in self-publishing.
In 8 years, from 2010 to now, Melanie and I have made half-a-million dollars self-publishing well over 100 books. I also managed to record a pair of audiobooks for Amazon and Audible sale.
By 2014, our rapid rise to Kindle fame had already dwindled. I decided to

icon
More courses by Brian Jackson

Unofficial Udemy Student Guide: Courses Free or Dirt Cheap

$11.99

Write a Book! Creative Writing Skills for Beginner Writers

$11.99

GIMP 2.8/2.10 Beginner-Advanced: Free on Windows/MacOS/Linux

$11.99

Clip Studio Paint Pro/Ex (Manga Studio 5) Digital Art

$11.99

GIMP 2.8/2.10 for Beginners: Free Book and eBook Covers

$11.99

Self-publishing Children's Books: Self-publish w/PowerPoint

$11.99

icon
Reviews

4.8

51 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Great instructor, very well explained

Friendly tone, easy to follow

section wise differentiation is a very good way to teach about any thing

good teaching!

Nice introductory course. Easy to follow along with and grasp the basics pretty quickly.

Excellent quality. Plenty of useful information in each lesson.

I really happy by doing course

Excellent course of Excel for beginner , step by step and well organized course .

good voice, short and sweet .

Can use some more exercises with details..

So far so good. I don't have a clue about any of this but hoping to learn more!

This training is highly recommended to all beginers in Excel, the trainer provide all key functions of excel, and delivers it in a simple and crystal clear way that makes understanding easy for all

Great Instructor. This course is very detailed and the best for beginners.