Beginner Microsoft Excel 2013 / 2016 Data Analysis

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

What you'll learn

Create simple Excel spreadsheets

Use Excel to produce charts and graphs

Format Excel reports for printing

Requirements

You should already have purchased and installed Excel 2013 for Windows

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 WayMaybe 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 MenusAssigning Values to Cells & Performing Arithmetic OperationsRelative and Absolute Cell References and RangesCommon Math Functions: SUM, AVERAGE, MIN, MAX & COUNTEditing Columns, Rows and CellsFormatting Columns, Rows and CellsThat'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 PolishIn the following section you'll learn more advanced techniques which you can use to make your spreadsheets shine:Working with Worksheets and WorkbooksFreezing Rows and ColumnsFunctionsUsing Date Functions to Make Monthly ProjectionsSortingConditional FormattingCharts and GraphsFormatting and Printing ReportsThe 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…–-Brian

Overview

Section 1: Introduction

Lecture 1 Course Overview

Lecture 2 About Your Instructor

Lecture 3 Sample Excel Workbook

Section 2: Basic Functionality

Lecture 4 Starting, Stopping, Saving, Windows and Menus

Lecture 5 Assigning Values to Cells & Performing Arithmetic Operations

Lecture 6 Relative and Absolute Cell References and Ranges

Lecture 7 Common Math Functions: SUM, AVERAGE, MIN, MAX & COUNT

Lecture 8 Editing Columns, Rows and Cells

Lecture 9 Formatting Columns, Rows and Cells

Lecture 10 Simple Sample Baseball Spreadsheet

Section 3: More Advanced Functionality

Lecture 11 Working with Worksheets and Workbooks

Lecture 12 Freezing Rows and Columns

Lecture 13 Functions

Lecture 14 Using Date Functions to Make Monthly Projections

Lecture 15 Sorting

Lecture 16 Conditional Formatting

Lecture 17 Charts and Graphs

Lecture 18 Formatting and Printing Reports

Lecture 19 IF and IFS Functions

Section 4: Sample Projects

Lecture 20 Book Revenue Tracker

Lecture 21 Udemy Review Tracker

Lecture 22 Overview of my Udemy Review Tracker - 1/8/2016

Lecture 23 Udemy Review Tracker - 1/8/2016

Lecture 24 Overview of My Udemy Course Progress Tracker

Lecture 25 Udemy Course Progress Tracker Excel Spreadsheet

Section 5: Conclusion

Lecture 26 Student Request: More on Formatting and Printing Reports

Lecture 27 Where Do I Go From Here?

Lecture 28 How Do I Leave a Review?

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