Course Description
Learn everything Excel has to offer to your home and office in a very easy-to-understand format. With visual training methods, you will retain the information you learn so you can effectively put it to use immediately and further down the road. Dive deep into all of Excel’s features and functions in this Basic to advanced Level course.
Streamline Your Workflow and Enhance Your Results
Whether you’re in the field of engineering, management, marketing, accounting, finance, or education, the skills you will acquire from this course will launch you to a much higher level of value. Taking advantage of Excel in its entirety will make what you do and how you do it much easier, no matter what industry you work in.
Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite
Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 52 lectures and 17+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.
By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. You’ll also be shown clever multi-interacting formula work, and you’ll tackle how to resolve missing data that causes that pesky “N/A.”
The Ability to Master Excel
Whilst in this course we’ll cover the basics of Excel after that we’ll move onto more advanced-level topics. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process. Complete with working files, you’ll be able to follow along with the author throughout the lessons.
Lessons are also focused on organizing your data easily through outlining, expanding or contracting columns to display more or less data, and summarizing data.
Before long, you’ll be able to set up and record your own macros and array formulas, and you’ll know how to ask Excel to try out different solutions for you.
Your ability to master everything from sorting and managing data, to performing complex calculations quickly will help you use the program to its fullest potential.
By the end of the course, you’ll be confident when using Excel’s most advanced features for complex tasks at home and in the office.
What am I going to get from this course?
• Visual training method, offering users increased retention and accelerated learning.
• Over 50 lectures and 17+ hours of content!
• To take your basic Excel skills to the next level
• Learn basic to Advanced Level Microsoft Excel 2013 from a professional trainer from your own desk.
• 52 lectures (17+ hours of content) Master functions for working with lookups, advanced IF statements, math, and text, Macros, Sparklines, outlining, custom views, and scenarios ,Create and edit pivot tables, charts and much more!
• Breaks even the most complex applications down into simplistic steps.
• Suitable advanced Excel users. Ideal for users who learn faster when shown.
• To gain a solid understanding of the more powerful features and functions in Excel
• To be able to use Microsoft Excel in a commercial environment
• Learn auditing and troubleshooting formulas, such as goal seek, solver, and macros
Curriculum
01 Basics Number Format, Keyboards, PivotTables, Formulas.
02 Comprehensive Excel Formula Types & Elements Video and 12 Examples.
03 How Formulas Calculate: Order of Precedence in Excel.
04 Percentage Increase or Decrease Formula.
05 Cell References: Relative, Absolute & Mixed and 8 Examples.
06 Scenarios to Save Sets of Formula Inputs, Paste Special Trick.
07 Worksheet & Workbook References, 3-D Cell References.
08 Excel Table Formula Nomenclature / Structured References and 22 Examples.
09 Defined Names & Aggregate Functions.
10 AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS.
11 Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM.
12 AND & OR Criteria Calculations: D Functions like DSUM, DCOUNT.
13 AND & OR Criteria Calculations: Table Feature.
14 AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
15 IF & IS Functions To Deliver Numbers, Text, Formulas, Nested Ifs
16 Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...
17 Introductions to SUMPRODUCT Function
18 VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
19 Text Functions RIGHT, LEFT, MID, SEARCH for Partial Text VLOOKUP
20 VLOOKUP, DGET & MATCH For Looking Up Records and 7 Examples
21 INDEX and MATCH Functions For Unusual Lookups and 4 Examples
22 CHOOSE function to lookup table for VLOOKUP with Multiple Tables
23 VLOOKUP and IFNA for Commissions
24 Getting Top 5 Values With LARGE And Bottom 5 With SMALL
25 Goal Seek: Get Formula to Evaluate To Desired Result
26 Excel Compare Two Lists Formula: Item In List? Item Not In List?
27 How to Track Down Excel Formula Errors (16 Examples)
28 Excel Data Validation: List, Date, Time, Custom (22 Examples)
29 Flash Fill: Extract, Combine, Insert, Reverse Data (25 Example)
30 Custom Number Formatting & Text Functions, (33 Examples)
31 Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More
32 Introduction To Array Formulas and Array Functions
33 Sorting In Excel. Excel Sort (13 Examples)
34 Excel Subtotals, Add Subtotals based on One or Two Columns
35 Excel 2013 PivotTables: Basic To Advanced 58 Examples
36 Excel Filter For Extracting Records with AND or OR Criteria
37 Excel Advanced Filter Extract Data 26 Examples Basic – Advanced
38 Excel Text To Columns To Split or Convert Data 7 Examples
39 Excel Import Data: Text File, CSV File, Access, Excel File
40 Conditional Formatting Basic To Advanced 50 Examples
41 Review Of Chart Basics For Excel 2013
42 Save Chart As Template in Excel 2013
43 Set Default Chart in Excel 2013, Keyboard Shortcuts Charts
44 Pie within Pie Chart in Excel 2013
45 Combining Chart Types and Secondary Axis in Excel 2013
46 Statistics: Histogram Formulas & Chart in Excel 2013
47 Statistics: Dot Plot (Cell Chart)
48 Conditional Formatting: Bar Chart with Data Labels
49 Break Even Analysis Formulas & Chart, Plotting Break Even Point
50 Financial Functions_ PMT, RATE, NPER and FV 12 Examples.
51 Recorded Macro Basics, including Absolute & Relative References
Demo video
