Microsoft Excel The Ultimate FOUR COURSE Training Pack

Microsoft Excel The Ultimate FOUR COURSE Training Pack

Size
8 GB
Seeders
0
Leechers
1
Files
98
Category
Added
07/09/22 at 9:22am GMT+1
Infohash
b1970358905a115896e1892d03b0fd4053c0e133

Description
Description

Whether you’re a new Excel user who wants to go to the highest level you can manage, or an existing user who’d like a combined “best practice” refresher, skills enhancer and a reference for whatever you may want in the future, this is the choice for you!

With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the short “General Introduction” module at the start of each course). These are a great addition because they enable you to practice the skills you learn.

Our Microsoft instructors are seasoned professionals – they don’t just know the software: they’ve used it commercially and taught it in a classroom environment for years. You won’t be in better hands!

And we don’t woffle! Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and our instructors get to the point so you make the best use of your time.

The Introduction course takes you from the very basics in using the different tabs, working with data and editing data, formatting sheets, reviewing workbooks and creating charts.

The Intermediate course starts with file management, encryption and accessibility, before moving on to functions and formulas. It teaches you about using tables, data tools like validation, before moving on to more advanced charts and finishing with SparkLines.

The Advanced course really does take you to another level. It begins with grouping, outlining and subtotals before showing you how to perform What If Analysis, use PivotTables, perform advanced tasks before teaching you about HLOOKUP and VLOOKUP functions. If that wasn’t enough, it finishes with one of out most popular lectures: an introduction to Macros.

Finally, the Professional course you’ll learn about advanced ways of using conditional formatting, LOOKUPs, more functions and PivotTable tools. There’s a lecture on form controls and templates, and the final section introduces you to User Defined Functions (UDFs) using VBA.

Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view.

We’ll say it again: don’t forget the course workbooks and exercises – downloadable with the first “General Introduction” module at the start of each course – which really enhance and deepen your learning. Remember that practice makes perfect!

So although this is offered as a single course, it’s genuinely four courses in one – there are no shortcuts or reduced features. We don’t think you’ll find better value, so why not stop wondering which course to choose, and enrol with us now!
Who this course is for:

This package is great for every level of Excel user!
If you’re new to Excel, we show you what do do from the very beginning, so you needn’t feel intimidated.
If you’re an existing user, we can take you as far as you’re likely to want to go
If you’re an advanced user, we’re sure there’s plenty there to learn – though check the content: we don’t cover advanced VBA and programming in this package, for example.
And at all levels, don’t underestimate the value of a “refresher” – why, they may help you to clarify a few hazy areas, or even unlearn some bad habits!
Above all, we want you to get the most from your training, so make sure you enjoy your time doing the courses, and revisit them as often as you want.

Requirements

You don’t need any knowledge of Microsoft Excel: all you need is a basic understanding of how Microsoft Windows works.
In order to do the exercises we provide, you’ll need a copy of Excel on your computer (any version from 2010 is fine).

Last Updated 2/2021

File list
  • Microsoft Excel The Ultimate FOUR COURSE Training Pack
  • .pad/0 353.2 KB
  • .pad/1 148.3 KB
  • .pad/10 945 KB
  • .pad/11 212.7 KB
  • .pad/12 280.6 KB
  • .pad/13 929.1 KB
  • .pad/14 307.8 KB
  • .pad/15 263.3 KB
  • .pad/16 792.3 KB
  • .pad/17 928.8 KB
  • .pad/18 959.2 KB
  • .pad/19 273.3 KB
  • .pad/2 154.2 KB
  • .pad/20 692 KB
  • .pad/21 53.8 KB
  • .pad/22 482.7 KB
  • .pad/23 536.7 KB
  • .pad/24 271 KB
  • .pad/25 374.6 KB
  • .pad/26 424.2 KB
  • .pad/27 415.6 KB
  • .pad/28 200.7 KB
  • .pad/29 134.8 KB
  • .pad/3 727.9 KB
  • .pad/30 869.5 KB
  • .pad/31 179.8 KB
  • .pad/32 566.8 KB
  • .pad/33 700.3 KB
  • .pad/34 763.2 KB
  • .pad/35 17.3 KB
  • .pad/36 330.4 KB
  • .pad/37 607.6 KB
  • .pad/38 795.3 KB
  • .pad/39 971.7 KB
  • .pad/4 683.2 KB
  • .pad/40 274.8 KB
  • .pad/41 41.7 KB
  • .pad/42 747.2 KB
  • .pad/43 752.3 KB
  • .pad/44 747.6 KB
  • .pad/45 901.7 KB
  • .pad/46 466.4 KB
  • .pad/5 3.7 KB
  • .pad/6 473.3 KB
  • .pad/7 100.4 KB
  • .pad/8 582.2 KB
  • .pad/9 277.7 KB
  • TutsNode.com.txt 63 B
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/1 - General Introduction to Excel Introduction/1 - ExcelIntroductionZandaX.zip 504.7 KB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/10 - Working with Functions and Formulas/81 - IF and Nested Functions.mp4 88.9 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/10 - Working with Functions and Formulas/85 - Array Functions SUMIF & AVERAGEIF.mp4 81.2 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/10 - Working with Functions and Formulas/86 - Array Functions SUMIF & AVERAGEIF.mp4 108.4 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/10 - Working with Functions and Formulas/88 - Formula Auditing.mp4 85.8 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/11 - Managing Tables in Microsoft Excel/91 - Creating Excel Tables.mp4 84.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/11 - Managing Tables in Microsoft Excel/94 - Working with Records and Filters.mp4 122.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/11 - Managing Tables in Microsoft Excel/96 - Advanced Filters.mp4 56.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/12 - Data Tools in Excel/101 - Remove Duplicates.mp4 63.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/12 - Data Tools in Excel/103 - Data Validation.mp4 63 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/12 - Data Tools in Excel/105 - Consolidate.mp4 80.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/16 - Grouping & Outlining and Subtotals/120 - Outlining and Grouping Data.mp4 76.6 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/16 - Grouping & Outlining and Subtotals/122 - Using the Subtotals Tool.mp4 79.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/17 - WhatIf Analysis/125 - Exploring Scenarios.mp4 81.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/17 - WhatIf Analysis/130 - Using Solver.mp4 86.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/18 - Pivot Tables/135 - Displaying Data in a PivotTable.mp4 108.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/18 - Pivot Tables/137 - Formatting a PivotTable.mp4 103.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/18 - Pivot Tables/139 - Slicers.mp4 86.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/19 - Charting Pivoted Data/144 - PivotChart Tools and Formatting.mp4 79.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/2 - Getting Started with Microsoft Excel/11 - Getting Help with Excel.mp4 61.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/2 - Getting Started with Microsoft Excel/7 - About Workbooks.mp4 77.5 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/20 - Advanced Excel Tasks/147 - Excel and Hyperlinks.mp4 97 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/20 - Advanced Excel Tasks/149 - Using Custom AutoFill Lists.mp4 62.2 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/20 - Advanced Excel Tasks/151 - Sharing Workbooks.mp4 76.6 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/20 - Advanced Excel Tasks/152 - Tracking Changes.mp4 74.6 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/22 - Introduction to Macros in Excel/160 - Recording and Playing Macros.mp4 107.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/22 - Introduction to Macros in Excel/163 - Visual Basic and Macros.mp4 62.4 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/24 - Advanced Conditional Formatting/169 - Using Formulas in Conditional Formatting.mp4 57.5 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/25 - Using Form Controls and Templates/174 - Using Form Controls.mp4 92.5 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/25 - Using Form Controls and Templates/176 - Creating Templates.mp4 61 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/27 - Advanced Functions in Excel/190 - Using Error Functions.mp4 59.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/28 - Advanced Pivot Table Tools/206 - Showing Pivot Data as a Percentage.mp4 80.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/28 - Advanced Pivot Table Tools/208 - Creating Custom Pivot Tables Styles.mp4 66.4 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/29 - Introduction to User Defined Functions using VBA/211 - Creating a User Defined Function.mp4 67.2 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/29 - Introduction to User Defined Functions using VBA/213 - Creating an Interactive Procedure.mp4 78.9 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/29 - Introduction to User Defined Functions using VBA/215 - Create and Share a Function Addin.mp4 66.8 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/3 - The Excel Interface/16 - The Home Tab.mp4 58.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/3 - The Excel Interface/20 - The Page Layout Tab.mp4 62.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/3 - The Excel Interface/22 - The Formulas Tab.mp4 87.4 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/3 - The Excel Interface/24 - The Data Tab.mp4 77.5 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/4 - Microsoft Excel Basics/33 - Basic Excel Features.mp4 62.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/4 - Microsoft Excel Basics/35 - Smart Tags and Options Buttons.mp4 76.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/4 - Microsoft Excel Basics/37 - Editing Tools.mp4 67.9 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/5 - Editing Your Workbook/44 - Enhancing a Worksheets Appearance.mp4 70.8 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/6 - Printing and Reviewing Your Workbook/47 - Using the View Tab.mp4 84.1 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/6 - Printing and Reviewing Your Workbook/50 - Managing a Single Window.mp4 83.7 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/6 - Printing and Reviewing Your Workbook/54 - Setting Up Your Workbook.mp4 60.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/6 - Printing and Reviewing Your Workbook/56 - Print Page Layout Options.mp4 60.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/7 - Working with Charts in Excel/61 - Chart Elements.mp4 66.3 MB
  • [TutsNode.net] - Microsoft Excel The Ultimate FOUR COURSE Training Pack/8 - General Introduction to Excel Intermediate/64 - ExcelIntermediateExercises.zip 805 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.