|Course or Certification Name||Category||Location||Mode of learning|
|Microsoft Office 2010: Advanced Access||MS Office||Online self study|
|Microsoft Office 2013: SharePoint for Power Users||MS Office||Online self study|
|Microsoft Office 2010: Advanced Project||MS Office||Online self study|
|Microsoft Excel - Advanced Excel Formulas & Functions||MS Office||Online self study|
|Microsoft Excel - Data Analysis with Excel Pivot Tables||MS Office||Online self study|
|Deploying Microsoft 365 Teamwork||Online self study|
|Node.js, Express, MongoDB & More: The Complete Bootcamp 2020||Emerging Web Technologies||Online self study|
|MS office Training||MS Office||Online self study|
|Using Microsoft Office 2019||MS Office||Online self study|
|Managing Microsoft Exchange Online in Office 365||MS Office||Online self study|
|Microsoft Office 2013 Powerpoint Certification Training||MS Office||Online self study|
|The Python Mega Course: Build 10 Real World Applications||Data Analysis||Online self study|
|Introduction to SharePoint Online||MS Office||Online self study|
|Microsoft SharePoint Online for Site Administrator||MS Office||Online self study|
|Microsoft Office 2010: Beginning Visio||MS Office||Online self study|
Microsoft Office Access 2010 is a database management system from Microsoft and offers several advanced options for importing and exporting data. Microsoft Office 2010: Advanced Access course is designed with the aim to provide training on various methods of importing, exporting, and linking to external data sources in Access 2010, such as other Access databases, SQL Server databases, Excel spreadsheets, Microsoft Word files, and XML files. This course also covers various topics like PivotTables and PivotCharts, managing data efficiently, SQL, Action queries, Macros, SharePoint,VBA and other related areas.
Microsoft Office SharePoint takes you through tasks like creating websites using templates, editing and deleting pages. It also goes through processes like content organizer to manage site content in SharePoint 2013.This course also prepares candidates for the Microsoft Certification Exam 77-419 that confirms them as Microsoft Office Specialist. It will show how to manage list views so that you can view more sorts of metadata about a particular item and organize document templates to create excel files by default. The course also trains you on working with content types and column properties so that libraries can maintain more sorts of folders and SharePoint. This will highlight the ability to identify risks and capitalize on opportunities.
The advanced project covers how to tailor default options, groups to the Ribbon, new tabs and buttons to the quick access toolbar. One will learn how to import or export a tailored Ribbon and Quick Access Toolbar. Moreover, there will custom fields that include formatted task and resource data like graphical indicators, outline codes and formulas that cater to the needs of the project. The course also covers tools for managing multiple files so that you can find the relation between your projects. Providing an overview of the project tasks, plan and resources, it helps professionals to analyze project resources, schedules and budgets. The course also renders information on tracking project progress and advanced task scheduling. Additionally, you will get information on resource planning, consolidation and update on new features in Microsoft office advanced project.
See why this is one of the TOP-RATED Excel courses on Udemy: "One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!" -Julio Garcia "This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can teach!" -Barbara S. "Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!" -Bruno Ricardo Silva Pinho __________ FULL COURSE DESCRIPTION: __________ It's time to show Excel who's boss. Whether you're starting from square one or aspiring to become an absolute Excel power user, you've come to the right place. This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel. __________ By the end of the course you'll be writing robust, elegant formulas and functions from scratch, allowing you to: Easily build dynamic tools & Excel dashboards to filter, display and analyze your data Go rogue and design your own formula-based Excel formatting rules Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.) Manipulate dates, times, text, and arrays Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!) __________ We'll dive into a broad range of Excel formulas & functions, including: Lookup/Reference functions Statistical functions Formula-based formatting Date & Time functions Logical operators Array formulas Text functions INDIRECT & HYPERLINK Web scraping with WEBSERVICE & FILTERXML __________ What gives you the right to teach this class? Can't I just Google this stuff? I have a genuine passion for Excel that most people reserve for things like kittens, ice cream, and significant others. The only thing I love more than learning Excel is teaching it, and as the founder of Excel Maven and Maven Analytics I've been lucky enough to teach Excel to 150,000+ students across 180+ countries . My teaching style is conversational, authentic and to the point, and I will always communicate complex concepts in a framework that is clear and easy to comprehend. As a full-time analytics consultant and Excel instructor, I cut my teeth using Excel to solve real-world business problems and develop award-winning analytics & data visualization tools for Fortune 500 companies. If you care about creds, I'm a card-carrying MOS Certified Excel Expert and my work has been featured by Microsoft and the New York Times. Ok so I don't actually carry the card, but you get the idea. If you're looking for the ONE course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel ninja, you've found it. See you in there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: Full course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee . Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365. __________ P. S. Looking to master the full Microsoft Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel PivotTables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Looking for the Spanish version of this course? Search for Microsoft Excel - Frmulas y Funciones Avanzadas by Chris Dutton and Enrique Ruiz Tapia, with fully translated videos, slides, formulas and Excel datasets!
Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Pivot Table course: "This is a great Excel course. You can feel confident putting these skills on your resume, and the lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just LEARN Excel Pivot Tables, but become a true Pivot Table EXPERT " -Monique C. "Chris provides clear, detailed explanations and shows how to use Excel Pivot Tables to extract hidden details and facts using raw, real-life data sets in Excel. The quizzes and homework reinforce the lessons and the course layout makes it easy to go back to sections that need revision. This course is exactly what I was looking for to master Excel Pivot Tables. Thanks, Chris!" -Paul M. "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel and Pivot Table courses from Chris & Maven Analytics and look forward to viewing them as well." -Ernie A. __________ FULL COURSE DESCRIPTION: Excel Pivot Tables are an absolutely essential tool for anyone working with data in Excel. Pivots allow you to quickly explore and analyze raw data in Excel, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers . Whether you're exploring product sales, analyzing which marketing tactics drove the strongest conversion rates, or wondering how condo prices have trended over the past 10 years, Excel Pivot Tables provide fast , accurate and intuitive solutions to even the most complicated analytics questions. This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way. __________ We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including: Raw data structure in Excel Pivot Table layouts & styles Design & formatting options Sorting, filtering, & grouping tools Calculated fields, items & values Pivot Charts, slicers & timelines Interactive Excel dashboards __________ We'll then explore and analyze Excel datasets from a number of real-world case studies , including: San Diego burrito ratings Shark attack records from 1900-2016 Facebook Post data from Spartan Race Major League Baseball team statistics San Francisco employee salaries Daily stock market data IMDb movie ratings Apple Store mobile app ratings Wine ratings and descriptions __________ Whether you're looking for a quick Excel Pivot Table primer, trying to diversify your Excel skill set, or hoping to step up your analytics game in a major way, you've come to the right place . In today's increasingly data-driven world, analytics skills are in short supply and incredibly high demand, and those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro! See you there! -Chris ( Founder, Excel Maven & Maven Analytics ) __________ NOTE: This Excel course includes downloadable resources and Excel project files , homework and course quizzes , lifetime access and a 30-day money-back guarantee (compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Office 365) __________ P. S. Looking to master the full Excel + Power BI stack? Complete the path below and emerge an analytics ROCKSTAR: Excel Pro Tips for Power Users Advanced Excel Formulas & Functions Data Visualization with Excel Charts & Graphs Data Analysis with Excel Pivot Tables Excel Power Query, Power Pivot & DAX Up & Running with Power BI Desktop Publishing to Power BI Service Course access includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee!
Content is the most critical digital asset for every organization. In this course you will learn how to plan, configure, and manage SharePoint Site Collection and OneDrive for Business to enable modern content services which transform the content lifecycle. Specifically, this course discusses the modern SharePoint site structure, such as SharePoint hub sites. It provides best practices for the adoption and deployment of OneDrive for Business within your organization. It also covers sharing, security, and monitoring in SharePoint Online and OneDrive for business.In this course you will learn how to manage user profiles and apps with proper permission settings. We will also discuss how to plan and configure Managed Metadata, Business Connectivity Services, and search allowing content to be found, consumed, and governed across Office 365.Microsoft Teams is the hub for Teamwork in Microsoft 365. In this course you will learn how to plan, deploy and manage Microsoft Teams. Specifically, this course discusses the relationship of Teams with SharePoint, OneDrive and Office 365 Groups. It provides best practices for the adoption and deployment of Teams within your organization. It also covers how to establish guest policies and data governance for your Teams data.Transforming teamwork and collaboration inside and outside the organization becomes more critical in a modern workspace. In this course you will learn how to leverage Office 365 Collaboration Workloads to improve your organizations productivity, such as Yammer, Stream, PowerApps, and Flow. We will evaluate available collaborative toolsets and analyze business requirements. You will also learn how to plan and develop governance for digital transformation including user adoption and change management.
This Microsoft Office Course Bundle is an all-inclusive training on the notable Office products such as Excel, Word, PowerPoint, Access, Outlook, OneNote, Project, Sway and Visio
Microsoft Office is a suite of cross-compatible applications and services that include programs for word processing, spreadsheets, presentations, information management, note-taking, project management, diagrams, and more. Being well-versed in Microsoft Office is a must for many business environments. This skill will cover the essential information needed to be proficient in each one of the applications, as well as some advanced techniques in the more popular application
In this computer science course, you will learn how to set up and use Exchange Online, a hosted messaging application within Microsoft Office 365 that provides organizations with access to the full-featured version of Exchange Server. You will learn how to run your messaging system in Office 365. We will cover the various types of email recipients that are available and how to manage the email domains for them. We will guide you through the email protection capabilities of Office 365 and will show you how to manage the clients and mobile devices accessing their email in Office 365. You will learn about the archiving and security features in Exchange Online. Finally, you will learn how to move your existing messaging system to Office 365.
Microsoft® PowerPoint is a tool that help professionals to create stunning presentations and effectively use Microsoft PowerPoint 2013 interface. The MOS PowerPoint 2013 training from Simplilearn provides a broad overview of Microsoft® PowerPoint 2013 for creating new presentations using keyboard shortcuts and implement multimedia and special effects through animation.
The Python Mega Course is the most practical course you will find on the web today. So far, over 140,000 students have used the course to learn Python programming and to build real-world applications in Python 3. You will learn how to build Python apps during this course, even if you know nothing about programming. You will start from scratch and progressively build up your skills by creating some awesome Python programs ranging from webcam object detection apps, to data collector web apps that query data from SQL databases, to data visualization dashboards on the browser. The course has it all to make you an all-round Python programmer that not only knows Python but also the technologies you need to know to create professional applications. The course follows a modern-teaching approach where students learn by doing . You will start Python from scratch by creating simple programs first. Once you learn the basics, you will then start with the fun part, which is building 10 real-world applications. You will code the apps, guided step-by-step by easy video explanations and continuous support from the course instructor. The applications you will build in the course consist of database apps , web apps , desktop apps , web scraping scripts , webcam object detectors , web maps , data visualization dashboards , and more. These programs are not only great examples to help master Python, but you can also use them for your portfolio. By buying the course you will gain lifetime access to all of its videos, coding exercises, quizzes, code notebooks, cheat sheets, and the Q&A inside the course, where you can ask your questions and get an answer on the same day. On top of that, you are covered by the Udemy 30-day money-back guarantee , so you can easily return the course if you don't like it. If you don't know anything about Python, do not worry! In the first 12 sections, you will learn Python basics such as functions, loops, and conditionals and learn how to apply the basics by doing some examples. If you already know the basics, then the first 12 sections can serve as a refresher. The other 20 sections focus entirely on building real-world applications. The applications you will build cover a wide range of interesting topics: Web applications Desktop applications Database applications Web scraping Web mapping Data analysis Data visualization Computer vision Object-Oriented Programming Specifically, the 10 Python applications you will build are: A program that returns English-word definitions A program that blocks access to distracting websites A web map visualizing volcanoes and population data A portfolio website A desktop-graphical program with a database backend A webcam motion detector A web scraper of real estate data An interactive web graph A database web application A web service that converts addresses to geographic coordinates To consider yourself a professional programmer you need to know how to write professional programs and there's no other course that teaches you that, so join thousands of other students who have successfully applied their Python skills in the real world. Sign up and start learning the amazing Python programming language today! Frequently Asked Questions Will I be able to learn Python and find a job after completing this course? I have heard of quite a few success stories where students have rigorously followed the course and have found a job afterwards. However, whether you will be able to learn Python and be job-ready, heavily depends on you. If you merely watch the videos, without trying anything on your own, you will hardly learn anything. Instead, you have to try the code you see in the videos on your computer, change the code, run it, improve it further, run it again, fix the possible errors, try making a similar app, repeat, ask questions in the Q&A when you get stuck, and try to solve all the exercises in the course. That way you will certainly learn how to program with Python and be able to find a job. How much time will I need to complete the course? That depends on two factors: (1) Your background: Someone coming from a math or computer science background may be able to complete the course in a shorter time compared to someone coming from a social science background for example. (2) The effort you put in: If you just watch the videos, you may finish the course in two days. However, simply watching the videos is not enough. You need to experiment with the code you see in the videos. The more you experiment with it the better you become. Depending on the two factors I mentioned above, students spend from one week to three months to complete the course, most spending one month. I don't know anything about programming. Will I still be able to learn Python? This course assumes you have no previous knowledge of programming. Whenever a programming term is mentioned (e. G. a variable) the meaning of the term is explained thoroughly so you not only understand how to use that particular term in Python, you also understand what that term means in programming. Will I get support if I get stuck? Yes. Feel free to drop a question in the Q&A, and me, or my teaching assistant, will answer your questions within the same day. Does this course cover Python 2 or Python 3? Python 3 What IDE/editor is used in the course? Visual Studio Code is used in the course. It is very new and probably the best IDE that exists today. However, you can use your favorite IDE. The code will work the same, no matter the IDE. Does the course expire? No. Once you buy the course it's yours. I update the content regularly and all the updates are also included for free in the one-time purchase you make.
In this Introduction to SharePoint Online training you gain a comprehensive overview of Microsoft’s popular cloud-based platform. In this hands-on course you will learn to create, manage, and customize sites using new tools to help you empower your organization.SharePoint Online gives people powerful enterprise tools to inform and connect people to better share and collaborate from anywhere: the office, home or mobile devices. Users can create and manage sites for document lifecycle management, easier access to information, and a variety of tools and strong Office 365 integration for content management and intranet development.
SharePoint online is one of the hottest features in Office 365. It allows organizations to collaborate in a variety of different ways. This course is designed to provide you with the necessary skills to implement SharePoint Online, provide rich site architecture and articulate search, as well as improve the productivity experience for your virtual teams
Microsoft Visio 2010 is a powerful diagramming program that provides users with a diverse set of pre-drawn stencils, shapes, sample drawings and templates for illustrating complex ideas visually and also a powerful collaboration tool that allows the user to review and share Visio diagrams, link content from other Microsoft applications, and save and send directly from inside Visio 2010. In this course the various features of the Visio interface will be explored. It explores these features and demonstrates how to add apply and manipulate text, work with themes and backgrounds and how to design and format decorative elements of a diagram page. You will also be shown how to access and use templates, shapes and stencils for creating contemporary looking diagrams. Once the diagrams have been created, this course will also demonstrate how to manipulate, align, connect shapes to achieve professional looking results, embed shapes and graphics from Microsoft applications and finally how to preview, print and save Visio in different file formats.