پیشنهاد فرادرس

آموزش Microsoft Office 2013 در 71 ساعت

دسته بندی ها: آموزش اکسس (Microsoft Access) ، آموزش ورد (Word) ، آموزش وان نوت (One Note) ، مایکروسافت پروجکت (Microsoft Project) ، آموزش Outlook ، آموزش Publisher ، آموزش Visio ، آموزش پاورپوینت (Powerpoint) ، آموزش اکسل ، آموزش های یودمی (Udemy) ، آموزش آفیس

این دوره آموزشی MS Office 2013 را به طور کامل بدون نیاز به کلاس به شما آموزش می دهد.

این دوره آموزشی محصول موسسه آموزشی Udemy است.

لیست سرفصل های این دوره:

  • فایل های تمرین excel 2013
  • نوار ابزار دسترسی سریع
  • نوار ابزار کوتاه
  • ایجاد گزینه پشتیبان گیری خودکار، بازیابی و ذخیره خودکار
  • وارد کردن متن و شماره
  • فرمت تاریخ
  • قالب بندی
  • انتخاب داده، موقعیت و چاپ نمودارها
  • سلول های قالب بندی. ویرایش و حذف کردن داده
  • قرار دادن، حذف، پنهان سازی و تنظیم سطر و ستون
  • قرار دادن متن و هم ترازی
  • ادغام سلول ؛ استفاده از تم ها و سبک
  • مرتب سازی
  • توابع تاریخ و زمان
  • رگرسیون
  • تابع LINEST
  • نمونه ای از توابع برای آمار استنباطی
  • VLOOKUP
  • آموزش Microsoft Word 2013
  • آموزش Microsoft Outlook 2013
  • آموزش Microsoft PowerPoint 2013
  • آموزش Microsoft Access 2013 Beginner Course
  • آموزش Microsoft Publisher 2013
  • و...

عنوان دوره: Udemy The Ultimate Microsoft Office 2013 Training Bundle 71 Hours

نویسنده: Simon Sez IT

مدت زمان: 72 ساعت

توضیحات:

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2013 Inside And Out—Quickly, No Travel or Classes.
Master the Ins and Outs of Microsoft Office and Boost Your Office’s Productivity.
Spreadsheets with Excel 2013
Documents with Word 2013
E-mail with Outlook 2013
Presentations with PowerPoint 2013
Databases with Access 2013
Print Publications with Publisher 2013
Make Your Office More Efficient with Microsoft’s Premier Office Management Software
Whether you need to create a spreadsheet for data analysis, a database of customer contacts, or a brochure that outlines the strengths and appeal of your organization, Microsoft Office is the choice of many office professionals. Enjoy significant control over your calendar and communication with Outlook or create engaging presentations with PowerPoint.
Many people are aware of the basics of what Office can do, but learning the more advanced capabilities of the programs in Office gives you greater flexibility and opportunities for creativity. Microsoft Office is designed to make accomplishing office tasks easier and more efficient.
Contents and Overview
The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.
Through over 71 hours of video lectures and 8 quizzes, you’ll learn everything you need to know to make your office run more efficiently with Office 2013.
Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
Excel 2013 Advanced: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns.
Word 2013: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.
Outlook 2013: Gain control of your inbox and avoid accumulating hundreds of unanswered emails.
PowerPoint 2013: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.
Access 2013 For Beginners and Access 2013 Advanced: Become a master of data management, tracking customer information and buying patterns.
Publisher 2013: Create professional looking print publications to communicate the strengths and purpose of your organization.
When you complete this course, you’ll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft Office 2013.
What are the requirements?
Microsoft Office 2013
What am I going to get from this course?
Over 427 lectures and 71.5 hours of content!
Introductory tutorials for Microsoft Excel 2013
Introductory tutorials for Microsoft Word 2013
Introductory tutorials for Microsoft Outlook 2013
Introductory tutorials for Microsoft PowerPoint 2013
Introductory tutorials for Microsoft Access 2013
Introductory tutorials for Microsoft Publisher 2013
Advanced training for Excel 2013
Advanced training for Access 2013
What is the target audience?
Anyone new to Microsoft Office or upgrading from a previous version

Section 1: Learn Microsoft Excel 2013 Beginner Course Lecture 1:Introduction Lecture 2:IMPORTANT - Read this to ensure the best video quality!!!! Lecture 3:What's New Lecture 4:Overview of Principles Lecture 5:Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns Lecture 6:xcel 2013 Exercise Files Lecture 7:Templates; Creating, Opening, and Saving a Workbook Lecture 8:Online, Offline, and Contextual Help Lecture 9:Excel Options Lecture 10:Ribbon Interface Lecture 11:Quick Access Toolbar Lecture 12:Mini Toolbar Lecture 13:Create Backup Option; Auto-Recover and Autosave Lecture 14:Entering Text and Numbers Lecture 15:Date Formats Lecture 16:Formatting Cells; Editing and Deleting Data Lecture 17:Fill Lecture 18:Flash Fill Lecture 19:Themes and Cell Styles Lecture 20:Inserting, Deleting, Hiding and Adjusting Rows and Columns Lecture 21:Wrap Text and Alignment Lecture 22:Merging Cells; Applying Themes and Styles Lecture 23:Borders Lecture 24:Copy, Cut and Paste Lecture 25:Spell checking Lecture 26:Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets Lecture 27:Inserting Comments Lecture 28:Workbook Views, Zoom and Freeze Lecture 29:Printing; Headers, Footers and Margins Lecture 30:Overview of Formulas and Functions Lecture 31:Cell References Lecture 32:Names Lecture 33:Finding Errors; New Excel Functions Lecture 34:Multiple Workbooks and Windows; Comparing Workbooks Lecture 35:Go to; Find and Replace Options Lecture 36:Applying, Clearing and Managing Rules Lecture 37:Chart Types; Chart Recommendation Lecture 38:Basic Formatting Lecture 39:Selecting Data, Positioning and Printing Charts Lecture 40:Saving Workbooks; PDF and CSV Formats Lecture 41:Sorting Lecture 42:Filtering Lecture 43:Tables Lecture 44:VLOOKUP Lecture 45:Text Function Lecture 46:Date and Time Functions Lecture 47:Logical Functions Lecture 48:Financial Analysis Case Study - Part 1 Lecture 49:Financial Analysis Case Study - Part 2 Lecture 50:Quick Analysis Tool Lecture 51:Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt Lecture 52:Protecting Worksheets Lecture 53:Protecting Workbooks Lecture 54:Sharing and SkyDrive Lecture 55:Trust Center; Export; Inspect Workbook Lecture 56:Summary; More Help Section 2: Learn Microsoft Excel 2013 Advanced Training Course Lecture 57:Prerequisites of Excel 2013 Advanced Course Lecture 58:Excel 2013 Advanced Exercise Files Lecture 59:List of Functions; Common Types of Arguments; Basic Use of Functions Lecture 60:Advanced Aspects of Functions; Searching for a Function Lecture 61:Autosum Lecture 62:Payment Lecture 63:Future Value Lecture 64:Principle Payment Lecture 65:Depreciations Lecture 66:How Dates and Times are Stored Lecture 67:Dates and Times Calculation Lecture 68:Exercise on Date and Time Functions; Date and Time Settings Lecture 69:Average Lecture 70:Percentile Lecture 71:Regression Lecture 72:LINEST Function Lecture 73:Example of Functions for Inferential Statistics Lecture 74:Text Function Case Study - 1 Lecture 75:Text Function Case Study - 2 Lecture 76:Lookup and Reference Functions Lecture 77:Logical Functions Lecture 78:Connecting to Other Workbooks Lecture 79:Connecting to Access Data Lecture 80:Connecting to Web Data Lecture 81:Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row Lecture 82:Inserting Columns and Rows; Resizing Tables Lecture 83:Table Reference Lecture 84:Table Styles Lecture 85:Table Selection Lecture 86:Basic Principles of Pivot Tables Lecture 87:Presentational Side of Pivot Tables Lecture 88:Filtering in Pivot Tables; Slices Lecture 89:What if Lecture 90:Scenario Manager Lecture 91:Goal Seeker Lecture 92:Solver Lecture 93:Area Charts Lecture 94:Surface Charts Lecture 95:Stock Charts - Part 1 Lecture 96:Stock Charts - Part 2 Lecture 97:Radar Charts Lecture 98:Bubble Charts Lecture 99:Regression and Scatter Chart Lecture 100:Creating Pivot Charts Section 3: Learn Microsoft Word 2013 Section 4: Learn Microsoft Outlook 2013 Section 5: Learn Microsoft PowerPoint 2013 Section 6: Learn Microsoft Access 2013 Beginner Course Section 7: Learn Microsoft Access 2013 Advanced Training Course Section 8: Learn Microsoft Publisher 2013

حجم فایل:10GB

به این نوشته امتیاز دهید 1 2 3 4 5 بدون امتیاز
Udemy The Ultimate Microsoft Office 2013 Training Bundle 71 Hours

پیشنهاد فرادرس