Beginner Microsoft Excel 2013 / 2016 Data Analysis
- 3 hours on-demand video
- 3 articles
- 3 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Create simple Excel spreadsheets
- Use Excel to produce charts and graphs
- Format Excel reports for printing
- You should already have purchased and installed Excel 2013 for Windows
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
Using Date Functions to Make Monthly Projections
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...
- 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
This is an introduction to the course providing details on each of the lectures.
In the Life and Times of Brian Jackson I provide an overview of my life so far.
In this lecture you'll see how to create a Udemy review tracking tool as a further demonstration of the techniques contained in this course. Note that the spreadsheet created in this lecture is available for download as part of the Sample Excel Workbook referenced in the introduction.