آموزش برنامه نویسی اکسل Visual Basic&Excel 2013

<< آموزش تصویری شیرپوینت SharePoint 2013 Lynda Microsoft Dynamic CRM 4&Microsoft Dynamic Server2011 >>
آموزش برنامه نویسی اکسل Visual Basic&Excel 2013
نویسنده و تهیه کننده Infiniteskills
امتیاز جایزه: 0
قیمت: 9,000 تومان

آموزش مقدماتی و پیشرفته اکسل  2013 و برنامه نویسی در اکسل به کمک Visual Basic از موسسه Infinite Skills


Infinite Skills Learning Microsoft Excel 2013

 Start Here
Managing Excel Workbooks And Worksheets
  Entering And Editing Data In Cells
  Math Basics
  Formatting Worksheets
  Workbook And Worksheet Management
Page Setup And Printing
  Mathematical Formulas
  Advanced Formatting
  Security
  Excel 2013 Templates
  Graphics Objects
  Using Charts In Excel
  Excel As A Database
  Advanced Formulas
  Conditional Formatting

Infinite Skills Learning Microsoft Excel 2013 Advanced

 Getting Started
 Using Mathematical Functions
 IF Functionality
 Performing Data Lookups
 Sparklines
 Further Mathematical Functions
 Outlining
 Scenarios
 Custom Views
 Functions For Manipulating Text
 Arrays
 Useful Data Functions
 Some Other Useful Functions
 Auditing And Troubleshooting Formulas
 PivotTables
 PivotCharts
 Goal Seek And Solver
 Macros
 Summary And Credits

Learning Visual Basic for Microsoft Excel Training Video

Getting Started
Macros
Procedures And Functions
Getting Started With VBA Programming
Manipulating Excel Objects
Working With Excel VBA Functions
Controlling Program Flow And Execution
Events
Debugging And Error Handling
Interacting With Users Through Forms
Running And Storing VBA Code
Summary

Microsoft Excel - Advanced Formulas And Functions Training Video

“In this Microsoft Excel Advanced Formulas and Functions training course, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel.”

You will begin by reviewing the basic operations, such as sum and count syntax, function processing order, and knowing the troubleshooting tools. You will explore extended formula usage with 3D referencing, naming cells and absolute referencing. Guy proceeds to instruct you on how to look up and reference type functions using VLookup and HLookup. Other features that are covered in this computer based training include; generating random numbers and values, locating data using text functions, and learning to use an array formula to count unique entries.

By the completion of this training course, you will be comfortable with using many of the advanced formulas and functions that this powerful spreadsheet software from Microsoft offers. Working files are included, allowing you to follow along with the author throughout the lessons.”
“Table of Contents

01. Welcome
02. Getting The Basics Right
03. Extend Your Formula Usage
04. If And If Type Functions
05. Lookup And Reference Type Functions
06. Mathematical Functions
07. Statistics
08. Text Functions
09. Date And Time Functions
10. Information And Referencing Functions
11. Array Formulas And Functions
12. Conclusion”

Microsoft Excel - Shortcut Guide Training Video

A Practical Training Course That Teaches Real World Skills
In this project-based Microsoft Excel – Shortcut Guide video tutorial series, you’ll quickly have relevant skills for real-world applications.

Follow along with our expert instructor in this training course to get:
Concise, informative and broadcast-quality Microsoft Excel – Shortcut Guide training videos delivered to your desktop
The ability to learn at your own pace with our intuitive, easy-to-use interface
A quick grasp of even the most complex Microsoft Excel – Shortcut Guide subjects because they’re broken into simple, easy to follow tutorial videos
Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft Excel – Shortcut Guide tutorial, online or offline… so you’ll know the exact steps for your own projects.

Microsoft Excel - Charts In Detail Training Video

“In this Microsoft Excel – Charts in Detail training course, expert author Guy Vaccaro takes you beyond the basics of Excel, diving into detail about creating and using charts within this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.”

You will start by learning the basics of Excel charts, such as how to create them quickly and why the right chart type matters. From there, you will learn about the tools within the design and format tabs, including the different chart layout styles and colors, adding and manipulating shapes, and managing data labels. Guy will show you special chart types and properly explain scatter charts. This training video will teach you about chart data and how to create charts from multiple data sources. Finally, Guy will teach you how to print your chart and copy and link it to other Office applications.
By the completion of this video based training course, you will be fully versed in creating and using Excel charts. Working files are included, allowing you to follow along with the author throughout the lessons.

01. Welcome
02. Chart Basics
03. The Design Tab
04. The Format Tab
05. Special Chart Types
06. Chart Data
07. Printing And Sharing Charts
08. The End”

Microsoft Excel – Tables Deep Dive

In this Microsoft Excel – Tables Deep Dive training course, expert author Erin Olsen takes you beyond the basics of Excel, diving deep into creating and using tables in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.
You will start out by the learning the basics of Excel tables, such as how to prepare data for tables, creating and naming tables, and converting tables back to ranges. From there, you will move into working with table records, including how to add and delete records, use the data entry form, and sort and filter table records. Erin will teach you how to format tables and modify and create custom and default table styles. This video tutorial will also teach you table calculations, including how to create calculated columns, understand structured references, and work with table rows. Finally, you will learn how to work with table tools, such as moving tables, removing duplicates, and how to create charts from tables.
By the completion of this computer based training course, you will be fully capable of creating, using, modifying, and customizing tables in Excel. Working files are included, allowing you to follow along with the author throughout the lessons

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 36:40
ویرایش 2013
نوع تصویری(Multimedia)
تعداد DVD 2
سطح مقدماتی-متوسط-پیشرفته
هزینه حمل دارد
7 آموزش تصویری Agile project powerpoint کاربرد Goal Seek bit Essential مدیریت ارتباط با مشتری زبان اصلی ویدئو دانلود پاورپوینت Scenario seven نرم افزار Advanced اکسس lynda لیندا فروش Total Training فارسی شرکت آموزش تصویری excel 2013 office مایکروسافت آموزش microsoft وان نوت پیشرفته مدیریت پروژه Agile آموزش تصویری پراجکت 2013 مقدماتی Training مدیریت پروژه چابک 2010 انگلیسی آموزش تصویری وان نوت 2013 vba تخصصی آموزش تصویری excel 2010 هفت فیلم onenote آموزش ساخت ماژول برنامه ریزی زما تصویری Visual Basic خرید آموزش Exchange Server
آمار سایت
اپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2014