Excel 2016 Advanced
Excel 2016 Advanced, available at $19.99, has an average rating of 3.8, with 82 lectures, based on 70 reviews, and has 401 subscribers.
You will learn about How to use intermediate to advanced Excel functions from various categories (counting/summing/averaging, math, text, date/time, statistical, financial, reference, and logical) to solve practical problems More advanced tips for working with formulas, including formula auditing and formula evaluation How to use Excel’s many powerful tools for data analysis, including tables, pivot tables, data tables, Goal Seek, and Solver How to use Excel’s tools for importing external data from databases, text files, and the Web How to use a number of intermediate to advanced tools for adding professional touches to your spreadsheets, including data validation, workbook/worksheet protection, scenarios, form controls, and recording macros An introduction to several tools new to Excel 2016, including Flash Fill for text pattern recognition and several data analysis tools (Quick Analysis, the Excel Data Model, and the PowerPivot and Power View add-ins) This course is ideal for individuals who are Any competent Excel users who aspire to becoming Excel “power users” It is particularly useful for Any competent Excel users who aspire to becoming Excel “power users”.
Enroll now: Excel 2016 Advanced
Summary
Title: Excel 2016 Advanced
Price: $19.99
Average Rating: 3.8
Number of Lectures: 82
Number of Published Lectures: 57
Number of Curriculum Items: 82
Number of Published Curriculum Objects: 57
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- How to use intermediate to advanced Excel functions from various categories (counting/summing/averaging, math, text, date/time, statistical, financial, reference, and logical) to solve practical problems
- More advanced tips for working with formulas, including formula auditing and formula evaluation
- How to use Excel’s many powerful tools for data analysis, including tables, pivot tables, data tables, Goal Seek, and Solver
- How to use Excel’s tools for importing external data from databases, text files, and the Web
- How to use a number of intermediate to advanced tools for adding professional touches to your spreadsheets, including data validation, workbook/worksheet protection, scenarios, form controls, and recording macros
- An introduction to several tools new to Excel 2016, including Flash Fill for text pattern recognition and several data analysis tools (Quick Analysis, the Excel Data Model, and the PowerPivot and Power View add-ins)
Who Should Attend
- Any competent Excel users who aspire to becoming Excel “power users”
Target Audiences
- Any competent Excel users who aspire to becoming Excel “power users”
This course takes up where the Excel 2016 Beginners course leaves off. It covers a wide variety of Excel topics, ranging from intermediate to an advanced level. You will learn a wide variety of Excel functions, tips for creating readable and correct formulas, a number of useful data analysis tools, how to import external data into Excel, and tools for making your spreadsheets more professional. To learn Excel quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.
***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****
***** CLEAR AND CRISP VIDEO RESOLUTION *****
***** COURSE UPDATED: February 2016*****
“As an Accountant, learning the Microsoft Office Suite really helps me out. All of the accounting firms out there, whether Big 4 or mid-market, want their employees to be well-versed in Excel. By taking these courses, I become a stronger candidate for hire for these companies.” – Robert, ACCOUNTANT
There are two questions you need to ask yourself before learning Excel. 1. Why should you learn Excel in the first place? 2. What is the best way to learn?
The answer for the first question is simple. Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you’re a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today’s economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.
The answer to the second question is you learn by doing. Simple as that. Learn only that which you need to know to very quickly get up the learning curve and performing at work or school. Our course is designed to help you do just that. There is no fluff content and the course is packed with bite-sized videos and downloadable course files (Excel workbooks) in which you’ll follow along with the instructor (learn by doing).
If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn Excel in the quickest and simplest manner then this course is for you!
You’ll have lifetime online access to watch the videos whenever you like, and there’s a Q&A forum right here on Udemy where you can post questions.
We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you’re not 100% satisfied, we will gladly refund the full purchase amount!
Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…
Course Curriculum
Chapter 1: Introduction to Course
Lecture 1: Welcome to Intermediate & Advance Course
Lecture 2: How to download Exercise Files and Handouts
Lecture 3: REMINDER: Turn on HD
Chapter 2: Summarizing Functions
Lecture 1: COUNTIF, SUMIF, AVERAGEIF
Lecture 2: COUNTIFS, SUMIFS, AVERAGEIFS
Chapter 3: Math Functions
Lecture 1: Intro to Math Functions
Lecture 2: INT, ROUND, CEILING, FLOOR
Lecture 3: ABS, SQRT, SUMSQ
Chapter 4: Text Functions
Lecture 1: Intro to Text Functions
Lecture 2: LOWER, UPPER, PROPER
Lecture 3: TRIM, VALUE
Lecture 4: Concatenating
Chapter 5: Dates and Times Functions
Lecture 1: Intro to Dates and Times in Excel
Lecture 2: Y2K
Lecture 3: TODAY, NOW
Lecture 4: DATEDIF
Chapter 6: Statistical Functions
Lecture 1: Intro to Statistical Functions
Lecture 2: MIN, MAX
Lecture 3: MEDIAN, QUARTILE, PERCENTILE
Lecture 4: STDEV, VAR
Chapter 7: Financial Functions
Lecture 1: Intro to Financial Functions
Lecture 2: PMT
Chapter 8: Reference Functions
Lecture 1: Intro to Reference Functions
Lecture 2: INDEX
Lecture 3: MATCH
Chapter 9: Logical Functions
Lecture 1: Intro to Logical Functions
Lecture 2: IS… Functions
Lecture 3: IF… Functions
Chapter 10: Advanced Formula Tools
Lecture 1: Range Names 2
Lecture 2: R1C1 Notation
Lecture 3: Auditing Formulas
Chapter 11: Importing External Data
Lecture 1: Intro to Importing External Data
Lecture 2: Importing Data from a Database
Lecture 3: Importing Data from a Text File
Lecture 4: Importing Data from the Web
Lecture 5: Importing Data from Saved Connections
Chapter 12: Data Analysis Tools
Lecture 1: Intro to Data Analysis Tools
Lecture 2: Quick Analysis
Lecture 3: Tables
Lecture 4: Pivot Tables 1
Lecture 5: Pivot Tables 2
Chapter 13: Power BI
Lecture 1: Intro to Power BI
Lecture 2: Data Model
Lecture 3: Power Query
Lecture 4: Power Pivot
Lecture 5: Power View
Lecture 6: Power Map
Chapter 14: Adding Professional Touches
Lecture 1: Intro to Adding Professional Touches
Lecture 2: Data Validation
Lecture 3: Protecting Worksheets and Workbooks
Lecture 4: Custom Views
Lecture 5: Scenarios
Lecture 6: Outlining
Lecture 7: Developer Ribbon
Lecture 8: Using Form Controls
Lecture 9: Recording a Macro
Chapter 15: Conclusion to Course
Lecture 1: Conclusion to Excel 2016 Intermediate and Advanced Course
Instructors
-
Optima Train
Practical Training for Today's Knowledge Worker
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 3 votes
- 3 stars: 13 votes
- 4 stars: 21 votes
- 5 stars: 31 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024