Categories
Office Productivity

Google Data Studio A-Z for Data Visualization and Dashboards

6 Reasons why you should choose this Google Data Studio course

  • Carefully designed course, teaching you not only how to draw all types of charts in Google Data Studio, but also advanced Data studio specific features
  • Concise – you can complete this course within one weekend
  • Business related examples and case studies
  • Ample practice exercises because Data Visualization requires practice
  • Downloadable resources
  • Your queries will be responded by the Instructor himself

Start using Google Data Studio to its full potential to become proficient at Data Visualization and reporting tasks today!

Either you’re new to Data Visualization, or you’ve made some charts and graphs using some visualization software such as MS Excel or Tableau. Either way, this course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this Google Data Studio course.

Why should you choose this course?

This is a complete and concise tutorial on Google Data Studio which can be completed within 6 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade.

We are also the creators of some of the most popular online courses – with over 600,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! – Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. – Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

What is covered in this course?

This course covers everything you need to insightful and dynamic reports using Google Data Studio in the professional work place.

Below are the course contents of this complete and concise course on Google Data studio:

Introduction – In this section, the structure and the contents of the course are discussed. We also discuss the reason to why should we learn Google Data Studio.

Theoretical concepts – This lecture covers the prerequisite understanding of key terminologies and concepts before we start to work on Google Data Studio.

All charts and tables in Data Studio – We cover all the available chart types one-by-one.  It includes Data tables, scorecards, bar charts, time series, pie charts, GeoMaps, pivot tables and many more.

Data filter controls – This lecture covers the filtering options that can be given to the report viewers so that each viewer can filter the data and see only what s/he wants to see.

Branding the report – Branding a report is a very popular business practice and we will see how we can do it using brand logo and brand colors

Embedding external content – We can add videos, quizzes, feedback forms, company websites to our report. Yes! It is possible. We will see how in this section.

Blending multiple data sets – Real life data is in multiple tables. To plot a graph using data from multiple tables requires data blending. Very Important Section.

Report Sharing and Collaborating – This section covers ways in which you can give viewing or editing rights to others. You can also schedule regular reports to the management using Google Data Studio. Report sharing is something where no other Data Visualization tool can beat Google Data Studio.

And so much more!

By the end of this course, your confidence in using Google data studio will soar. You’ll have a thorough understanding of how to use Data Studio for creating insightful dashboards and beautiful reports.

Go ahead and click the enroll button, and I’ll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ’s

What you can do with Data Studio?

  •     Visualize your data through highly configurable charts and tables.
  •     Easily connect to a variety of data sources.
  •     Share your insights with your team or with the world.
  •     Collaborate on reports with your team.
  •     Speed up your report creation process with built-in sample reports.

Is Google Data Studio free to use?

Google Data Studio is offered completely free by Google.

What is the use of Google Data Studio?

Google Data Studio gives you everything you need to turn your client’s analytics data into informational, easy-to-understand reports through data visualization. The reports are easy to read, easy to share and even customizable to each of your clients

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of Data visualization in today’s corporate world.

Categories
Office Productivity

Microsoft Excel: Data Analysis using Excel Pivot Tables

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 – DATA ANALYSIS WITH EXCEL

__________

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, Maven Analytics)

__________

Most students in this course enroll in our full EXCEL LEARNING PATH, designed to help you build a deep, expert-level Excel skill set:

Categories
Course Office Productivity

Excel vba programming – the complete guide

Excel vba programming – the complete guide free download - freetutorialsus.com

Automate your Microsoft Excel workflow, accelerate your productivity, and master programming with VBA! Beginners welcome

EXCEL VBA PROGRAMMING

Created by Boris Paskhaver
Last updated 1/2020
English
English [Auto]

What you’ll learn

  • Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)

  • Utilize the objects in the Excel Object Model to emulate user actions in Excel

  • React dynamically to user events like entering a cell value or opening a workbook

  • Feel comfortable with the fundamentals of computer programming

Requirements

  • A modern version of Microsoft Excel for Windows (2016 is strongly recommended)

  • Intermediate knowledge of popular Excel features (functions, PivotTables, charts, etc.)

  • Basic knowledge of data types (numbers, strings, Booleans, dates)

  • A desire to learn!

Description

Welcome to Excel VBA – The Complete Guide, Udemy’s most comprehensive VBA course!Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!Over the course of more than 18 hours of content, we’ll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:

  • The Excel Object Model
  • The Visual Basic Editor
  • Objects and Methods
  • Variables and Data Types
  • Writing Your Own Procedures

Size: 2.40GB

Friendly Websites

Related Posts

Categories
Office Productivity

How To Dominate Excel Formatting & Charting Download

Description

Excel is a key skill for virtually every office employee today, but because the software provides what seems like an infinite number of functions, it can become confusing.

If you struggle with Excel, know that you’re not alone. Even though Excel is designed to make your life easier, 82% of users report that Excel causes them stress.

This course is for you if you:

  • Struggle to find online tutorials that make using Excel formulas easy
  • Make mistakes in Excel and feel disappointed with the results
  • Become angry and frustrated because Excel actually reduces your productivity

Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:

  • Work in Excel in a simple yet professional way
  • Create Excel spreadsheets that are clear and uncluttered
  • Make elaborate charts that even average workers will understand

Content & Overview

First, we’ll cover the foundations of Excel formatting and charting. You’ll discover the basics of cells, data and charting, which includes a comprehensive tutorial on how to build charts.

Next comes how to format cells and data the McKinsey way. I’ll explain 8 Excel cell formats with practical examples and how to effectively navigate large data sheets. Plus, you’ll learn how to never lose overview by using five uncommon shortcut functions.

Moreover, I’ll show you step-by-step how to build a chart the McKinsey way and combine stacked column charts with normal column charts to enable advanced data labeling techniques.

Last but not least, I included three bonus tutorials covering freeze panes vs. split windows, techniques to show key data only and drop down menus.

By the time you complete this class, you’ll learn the renowned McKinsey way of formatting charts and tables, from basic to advanced.

This training is 100% job-focused and contains only practical knowledge of Excel to format data and charts. In contrast to books and 36-hour Excel courses, you won’t waste your time with 500 irrelevant Excel features that you’ll never use. Instead, you can put these new skills to use right away!

Who is the target audience?

  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career

Udemy course site Link : Click here

Get instantly update on : Click here

Categories
Office Productivity

Excel Conditional Formatting Basics – The built in Features Download


Views:
434

Learn how to make Excel format cells at your terms !

What Will I Learn?

  • Understand what conditional formatting in Excel is and how it works
  • Use conditional formatting built in features in Excel

  • Use the Highlight Cell Rules to highlight cells by comparing the cells’ value to another value

  • Use Conditional Formatting to Highlight dates based on their occurrence Yesterday, Today, Last Week, Last Month
  • Use Conditional formatting to Highlight Duplicates in a range of Cells
  • Highlight the top % or bottom % in a range of values
  • Highlight values above and below average in a range of values
  • Use Data Bars for conditional formatting and understand its different options
  • Use Icon sets (Traffic lights) for conditional formatting and understand its different options (Number, Formula, Percent, and Percentile)

Requirements

  • The will to learn !
  • Students will need to have Excel 2007/2010/2013/2016 installed on their computer
  • Students will need to be familiar with the Excel user interface and need to have written a few formulas

Description

Conditional formatting is one of the best ways to visualize your data by coloring the cells that meet a certain criteria or add different shapes to those cells and allows you to see the different colors of the rainbow in your data.

In this course, you will learn the basics of conditional formatting in Excel and how to use the built in features.

The course is designed to get you up and running with conditional formatting in 1 hour.

If you want to learn the basics of conditional formatting, then this course is for you.

Course doesn’t include conditional formatting using formulas as this is an advanced topic in conditional formatting.

So Let’s see what you’ll learn from this course:

  • Introduction to conditional formatting, what it is and what it does.
  • Highlight Cell rules : Highlighting cells based on the comparison of their value to another value, highlighting dates, and highlighting duplicates in a data set.
  • Top/Bottom Rules: Conditionally formatting the top or bottom % of the data and values above or below average.
  • Using Data Bars in conditional formatting.
  • Using Icon sets (Creating Traffic Lights conditional formatting).
  • Using Color scales for conditional formatting.

Who is the target audience?

  • Excel users who want to understand conditional formatting in Excel and use Excel’s built in features for conditional formatting
  • If you’re an intermediate user in conditional formatting then you might learn some new things on this course
  • If you’re an experienced user in conditional formatting then this course is NOT for you.

Udmey course site Link : Click here

Get instantly update on : Click Here

Categories
Office Productivity

MIS Professional – Excel + Macro + Access + SQL Download


Views:
667

MIS Training – Complete Data Management and Automation Training

What Will I Learn?

  • Expert MIS Level Excel, Macro, Automation, Database and queries knowledge

Requirements

  • Basic Computer Knowledge is must

Description

management information system (MIS) provides organisation with the information they require in an organised manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.

This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology , which is MACRO -Automation.

Who is the target audience?

  • MIS Aspirants
  • Management Graduates
  • Want Data Management Expertise

Udemy course site Link : click Here

Get instantly update on : Click here

Categories
Office Productivity

Master Microsoft Excel Macros and Excel VBA Download


Views:
600

Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros

What Will I Learn?

  • Learn how to automate daily routine tasks within Excel
  • Learn best practices when creating macros and streamline your VBA code

  • Determine when it’s best to use the Macro Recorder versus VBA

  • Learn how to write custom VBA Macros to create more robust automation
  • Learn VBA programming concepts to create dynamic, re-usable code
  • Complete real world Macro/VBA projects from beginning to end

Requirements

  • In order to complete the projects detailed in this course, you will need Microsoft Excel loaded on you computer. Any version of Excel will work.
  • Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.

Description

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.

Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.

Below are a few samples of the projects you will complete by enrolling and participating in this course.

  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel Worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
  • Automate the creation of Excel Formulas to SUM data up in your Report
  • Working with Excel VBA User Forms
  • Importing Data from External Text Files

Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.

So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.

Who is the target audience?

  • This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

Udemy course site Link : click Here

Get instantly update on : Click here

Categories
Office Productivity

Excel Formulas & Functions – Find Answers In Your Excel Data Download


Views:
569

Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016

What Will I Learn?

  • Identify formulas and functions and know the difference between the two.
  • Locate and use any of the functions in Excel using various methods, such as the Formula Tab.

  • Use the 7 most important Excel functions in common spreadsheet computations.

  • Understand the important difference between Absolute and Relative cell references to increase your computing power.
  • Identify the various parts of an Excel formula so you can create or modify formulas to fit your needs.
  • Use the SUM function in Excel
  • Use AVERAGE and AVERAGEA functions in Excel
  • Use COUNT and COUNTA functions in Excel
  • Use IF functions in Excel
  • Use SUMIF and SUMIFS functions in Excel
  • Use COUNTIF and COUNTIFS functions in Excel
  • Use VLOOKUP in Excel
  • Use LEFT, RIGHT and MID functions in Excel

Requirements

  • A basic knowledge of how to use Excel is needed. I recommend first taking my beginning course called Easy Excel Basics for Beginners – Learn Quickly and Easily. That will give you enough background to be ready to learn more about Formulas and Functions.
  • This course was created using Excel 2010, but all of the information is suitable for other versions of Excel as well, such as Excel 2013 or Excel 2016.

Description

Do you want to learn how to use Excel Formulas and Functions but find it all a bit overwhelming?

Do you need Excel to succeed at work, but wonder where to even start?

If so, you’re in the right place. In this course I’m going to teach you how to use Excel Formulas and Functions without any tears or pulling your hair out.

I’m so confident that this course will increase your efficiency and understanding of Excel formulas and functions that I guarantee it! If you aren’t 100% satisfied with ANYTHING that you’ve learned or you don’t see the results in your work within 30 days of signing up, you get a FULL REFUND.

Why should you take this course?

  1. I make learning Excel as simple as possible. Excel can seem extremely complex and overwhelming at times. But I break every function down into simple, manageable steps. I also use easy, realistic examples that you can follow along with.
  2. I get right to the point in every lecture. I know you’re busy so I don’t waste a lot of time on tangents, personal stories or filler like many instructors do. If the lecture is about VLOOKUP, I’m going to get straight to teaching you how to use VLOOKUP so you can put it to use right away.


Who is this course for?

This course is designed for beginning or intermediate Excel learners who are new to using formulas and functions to make calculations in Excel. It is also appropriate for anyone who wants to learn to use functions but feels intimidated or overwhelmed.

What’s included in the course?

  1. What is a formula? What is a function?
  2. The anatomy of a formula and how to create one.
  3. How to use the SUM function.
  4. How to use the AVERAGE and AVERAGEA functions.
  5. How to use the COUNT and COUNTA functions.
  6. How to use the IF function.
  7. How to use the SUMIF and SUMIFS functions.
  8. How to use the COUNT and COUNTIFS functions.
  9. How to use the popular VLOOKUP function.
  10. How to use RIGHT, LEFT and MID to sort data easily.
  11. A complete demonstration of how to use each function and what to use if for.

Thanks for taking the time to check out my course. I can’t wait to help you take your Excel Formulas and Functions to the next level!

To learn more now, watch one of the FREE preview lectures.

Remember, If you aren’t 100% satisfied with ANYTHING that you’ve learned or you don’t see the results in your work within 30 days of signing up, get a FULL REFUND.

If you’re ready to get started, click on the “Take This Course” button and in just a couple of hours you’ll be amazed at what you can do with Excel.

Who is the target audience?

  • This course is suitable for any level of Excel user from beginning to advanced but it is mostly geared toward beginning and intermediate level learners.
  • This course is for you if you are looking for a clearer understanding of how to use common functions, where to find them and some tips and tricks to make your work with functions easier.

Udemy course site Link: Click Here

Get instantly update on: Click here

Categories
Office Productivity

MIS Professional – Excel + Macro + Access + SQL

  • Basic Computer Knowledge is must

Description

management information system (MIS) provides organisation with the information they require in an organised manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.

This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology , which is MACRO -Automation.

Who is the target audience?

  • MIS Aspirants
  • Management Graduates
  • Want Data Management Expertise

Created by Himanshu Dhar
Last updated 7/2018
English
English [Auto-generated]

Size: 7.49 GB

Download Now

https://www.udemy.com/mis-professional-excel-macro-access-sql/.

Categories
Office Productivity

TallyERP9: Become Expert in Tally by Veer Tutorial

TallyERP9: Become Expert in Tally by Veer Tutorial

Learn all feature of tally and become various industry expert and handle all business transactions independently.

What Will I Learn?

  • Become industry level expert in world’s most used Accounting software TallyERP9
  • You can independently handle all business transaction such as accounting, inventory, taxation, payroll and MIS

Requirements

  • You should have basic understanding of computer. That’s it you need to know!

Description

After completion of this course you can handle complete accounts of any business / company independently.

Whether you are fresher or an expert, this course is for you because we included live examples of all industries such as manufacturing, trading, contracting, construction and service industry. We includes all business transactions such as sales, purchase, contra, receipt payment manufacturing voucher payroll voucher.

We have covered all the topics of any business such as accounting, inventory, taxation (VAT & CST, Excise, Service Tax, Payroll, Job Costing, Cost Center and many more..

Kindly check the course content for complete list of topics covered. I hope you will learn a lot in this course!

Who is the target audience?

  • Everybody wants to handle accounts can join, whether a fresh student or already working but wants to become expert in TallyERP9

Created by Veer Tutorial
Last updated 9/2015
Hindi

Size: 3.64 GB

Content From: https://www.udemy.com/tally-erp-basic-to-advance-course/.

Categories
Office Productivity

Ultimate Guide to Microsoft PowerPoint for All Levels

  • Paper and pen to take notes
  • Microsoft PowerPoint 2007 or later
  • Microsoft Excel 2007 or later to generate table data for some sections
  • Access to a computer and Internet
  • No prior knowledge required

Description

WHAT’S YOUR STORY?

  1. Are you a business professional needing to up-skill?
  2. Are you struggling to get a pay-rise and/or promotion?
  3. Are you a recent graduate with an empty looking resume and no job experience?
  4. Have you recently been laid off, fired or had a contract end?

If you answered ‘yes’ to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here’s why.

The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself.

A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics.

This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory.

 

ONLINE TRAINING AND THE MOST COMMON PROBLEMS

One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time.

Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy.

 

COURSE DELIVERY STYLE

I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing.

WHAT YOU’LL LEARN IN THIS COURSE

I built this course so that you can immediately use PowerPoint once you finish the first section. It contains all the basic elements you need to build and present your presentation. Following that section, each section will get progressively harder until you become an expert. I will show you:

  1. All basic elements of PowerPoint slide design
  2. Image Control and Manipulation, Artistic Effects, Shapes and SmartArt
  3. How to help yourself when you encounter a specific problem
  4. Standard Printing, PDF Printing Options, Email and Sharing
  5. Quick Access Toolbar Setup, Productivity Techniques and Keyboard Shortcuts
  6. Slides Transitions, Object Animations and Complete Effect Customization
  7. Post Review Functions including Spell Checking, Thesaurus, Researching, Window Duplication and Password Protection Protocols
  8. Video Uploading from your Computer and YouTube, Video Trimming, Audio Recordings and Screen Casting
  9. Presentations Do’s and Don’ts which teaches you Slide Design and Structure, Sequencing, Logistics and Communication Tips
  10. Table Design, Object Linking and Excel Connections
  11. Complete Chart Design including Elements, Styling and Control
  12. Header and Footer Design for Document Tracking
  13. Master Views for Template Control
  14. And much more……

ABOUT ME

  1. Member of the Udemy Council
  2. Co-Founded Paperclip Learning which teaches Microsoft Office
  3. Over 60,000 students and over 17,000 students for this course alone
  4. Over 130,000 enrollments
  5. Over 5,000 Positive Reviews and over 1,000 Reviews for this course
  6. Over 20 courses on Udemy

Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics.

TESTIMONIALS

Yu Hui Jun Yu – The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the ‘mini-lesson’ format. Fast and efficient. The instructor’s direction is very detailed and easy to understand. I can immediately start using this program. Thanks!

Narayanan Krishnamoorthy – Perfect and to the point…the instructor doesn’t waste time and gets to the point quickly!!

Lala Darchinova – I’ve been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing.

Spencer Berkman – Extremely knowledgeable and clear on instructions.

E Frank – Simple to learn techniques and instructor made it all really easy. Thank you!

Parth Gandhi – I learned techniques in a very short time…no need to google and waste time finding the perfect approach.

Who is the target audience?

  • This course has content for all levels. It has been designed to take you from complete beginner to mastery
  • People from any country
  • People of all ages
  • Professionals who work in teams

Created by Jed Guinto
Last updated 7/2017
English
English [Auto-generated]

Size: 1.04 GB

Download Now

https://www.udemy.com/shortest-powerpoint/.

Categories
Office Productivity

Excel Conditional Formatting Basics – The built in Features

  • The will to learn !
  • Students will need to have Excel 2007/2010/2013/2016 installed on their computer
  • Students will need to be familiar with the Excel user interface and need to have written a few formulas

Description

Conditional formatting is one of the best ways to visualize your data by coloring the cells that meet a certain criteria or add different shapes to those cells and allows you to see the different colors of the rainbow in your data.

In this course, you will learn the basics of conditional formatting in Excel and how to use the built in features.

The course is designed to get you up and running with conditional formatting in 1 hour.

If you want to learn the basics of conditional formatting, then this course is for you.

Course doesn’t include conditional formatting using formulas as this is an advanced topic in conditional formatting.

So Let’s see what you’ll learn from this course:

  • Introduction to conditional formatting, what it is and what it does.
  • Highlight Cell rules : Highlighting cells based on the comparison of their value to another value, highlighting dates, and highlighting duplicates in a data set.
  • Top/Bottom Rules: Conditionally formatting the top or bottom % of the data and values above or below average.
  • Using Data Bars in conditional formatting.
  • Using Icon sets (Creating Traffic Lights conditional formatting).
  • Using Color scales for conditional formatting.

Who is the target audience?

  • Excel users who want to understand conditional formatting in Excel and use Excel’s built in features for conditional formatting
  • If you’re an intermediate user in conditional formatting then you might learn some new things on this course
  • If you’re an experienced user in conditional formatting then this course is NOT for you

Created by Abdelrahman Abdou
Last updated 8/2018
English
English [Auto-generated]

Size: 93.51 MB

Download Now

https://www.udemy.com/excel-conditional-formatting-color-cells-at-your-terms/.

Categories
Office Productivity

How To Dominate Excel Formatting & Charting

  • Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
  • Following the step-by-step instructions of this training

Description

Excel is a key skill for virtually every office employee today, but because the software provides what seems like an infinite number of functions, it can become confusing.

If you struggle with Excel, know that you’re not alone. Even though Excel is designed to make your life easier, 82% of users report that Excel causes them stress.

This course is for you if you:

  • Struggle to find online tutorials that make using Excel formulas easy
  • Make mistakes in Excel and feel disappointed with the results
  • Become angry and frustrated because Excel actually reduces your productivity

Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:

  • Work in Excel in a simple yet professional way
  • Create Excel spreadsheets that are clear and uncluttered
  • Make elaborate charts that even average workers will understand

Content & Overview

First, we’ll cover the foundations of Excel formatting and charting. You’ll discover the basics of cells, data and charting, which includes a comprehensive tutorial on how to build charts.

Next comes how to format cells and data the McKinsey way. I’ll explain 8 Excel cell formats with practical examples and how to effectively navigate large data sheets. Plus, you’ll learn how to never lose overview by using five uncommon shortcut functions.

Moreover, I’ll show you step-by-step how to build a chart the McKinsey way and combine stacked column charts with normal column charts to enable advanced data labeling techniques.

Last but not least, I included three bonus tutorials covering freeze panes vs. split windows, techniques to show key data only and drop down menus.

By the time you complete this class, you’ll learn the renowned McKinsey way of formatting charts and tables, from basic to advanced.

This training is 100% job-focused and contains only practical knowledge of Excel to format data and charts. In contrast to books and 36-hour Excel courses, you won’t waste your time with 500 irrelevant Excel features that you’ll never use. Instead, you can put these new skills to use right away!

Who is the target audience?

  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career

Created by Sandor Kiss, Matthias Bellmann
Last updated 1/2016
English
English [Auto-generated]

Size: 442.64 MB

Download Now

https://www.udemy.com/how-to-dominate-excel-formatting-charting/.

Categories
Office Productivity

Master Microsoft Excel Macros and Excel VBA

  • In order to complete the projects detailed in this course, you will need Microsoft Excel loaded on you computer. Any version of Excel will work.
  • Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.

Description

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.

Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.

Below are a few samples of the projects you will complete by enrolling and participating in this course.

  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel Worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
  • Automate the creation of Excel Formulas to SUM data up in your Report
  • Working with Excel VBA User Forms
  • Importing Data from External Text Files

Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.

So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.

Who is the target audience?

  • This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

Created by Kyle Pew
Last updated 2/2018
English
English [Auto-generated]

Size: 1.14 GB

Download Now

https://www.udemy.com/master-microsoft-excel-macros-and-vba-with-5-simple-projects/.

Categories
Office Productivity

Complete Excel 2016 – Microsoft Excel Beginner to Advanced

  • You should have basic computer skills.
  • You should have a PC (you can get by with a Mac, but this course is not specifically designed for Mac users)

Description

Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

Excel is one of the most important skills in today’s job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

If you need to know Excel, you’re in the right place. 

This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

This course was created using Excel 2016, but it is good for versions 2013 and 2010 as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn’t cover Mac-specific keyboard shortcuts and interface.

We’ll start at the very beginning, with opening and saving a worksheet in Excel.

I’ll show you what all the tools do and walk you through each Excel skill that you need to know.

I’ll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I’ll teach you amazing keyboard shortcuts to make your work faster and more productive. You’ll learn how to record macros so you can do a whole series of actions with the just click of a button.

We’ll keep going until you’re a pro at Excel. When you finish this course, you’ll know more than most people who use Excel at their job every day.

Here’s some of what you’ll learn.

  • Creating spreadsheets in Excel
  • Saving your work where you can find it
  • Working with multiple workbooks in Excel
  • Formatting and printing
  • Importing data from CSV files, Access and the web
  • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others
  • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more
  • Creating tables
  • Sorting and filtering your data
  • Creating pivot tables
  • Creating pivot charts from your pivot tables
  • Fun New features for Excel 2016
  • Keyboard shortcuts to make your work go faster
  • How to record basic macros to automate repetitive tasks
  • A whole lot more

The course comes with a certificate of completion, a full 30-day money back guarantee, and I’m always available to answer questions or share additional resources if you get stuck.

Thanks for checking out my Biggest Excel Course to date.

I’ll see you in there!

Who is the target audience?

  • Anyone who wants or needs to learn Microsoft Excel for their work.
  • Anyone who wishes to improve their job or career prospects in an office environment.
  • Designed for beginners who are brand new to Excel (also suitable for intermediate Excel users who want to improve).

Created by Steve McDonald
Last updated 9/2018
English
English [Auto-generated]

Size: 2.34 GB

Download Now

https://www.udemy.com/microsoft-excel-2016-complete-beginner-to-advanced-excel-course/.

Categories
Office Productivity

Excel Formulas & Functions – Find Answers in Your Excel Data

  • A basic knowledge of how to use Excel is needed. I recommend first taking my beginning course called Easy Excel Basics for Beginners – Learn Quickly and Easily. That will give you enough background to be ready to learn more about Formulas and Functions.
  • This course was created using Excel 2010, but all of the information is suitable for other versions of Excel as well, such as Excel 2013 or Excel 2016.

Description

Do you want to learn how to use Excel Formulas and Functions but find it all a bit overwhelming?

Do you need Excel to succeed at work, but wonder where to even start?

If so, you’re in the right place. In this course I’m going to teach you how to use Excel Formulas and Functions without any tears or pulling your hair out.

I’m so confident that this course will increase your efficiency and understanding of Excel formulas and functions that I guarantee it! If you aren’t 100% satisfied with ANYTHING that you’ve learned or you don’t see the results in your work within 30 days of signing up, you get a FULL REFUND.

Why should you take this course?

  1. I make learning Excel as simple as possible. Excel can seem extremely complex and overwhelming at times. But I break every function down into simple, manageable steps. I also use easy, realistic examples that you can follow along with.
  2. I get right to the point in every lecture. I know you’re busy so I don’t waste a lot of time on tangents, personal stories or filler like many instructors do. If the lecture is about VLOOKUP, I’m going to get straight to teaching you how to use VLOOKUP so you can put it to use right away.


Who is this course for?

This course is designed for beginning or intermediate Excel learners who are new to using formulas and functions to make calculations in Excel. It is also appropriate for anyone who wants to learn to use functions but feels intimidated or overwhelmed.

What’s included in the course?

  1. What is a formula? What is a function?
  2. The anatomy of a formula and how to create one.
  3. How to use the SUM function.
  4. How to use the AVERAGE and AVERAGEA functions.
  5. How to use the COUNT and COUNTA functions.
  6. How to use the IF function.
  7. How to use the SUMIF and SUMIFS functions.
  8. How to use the COUNT and COUNTIFS functions.
  9. How to use the popular VLOOKUP function.
  10. How to use RIGHT, LEFT and MID to sort data easily.
  11. A complete demonstration of how to use each function and what to use if for.

Thanks for taking the time to check out my course. I can’t wait to help you take your Excel Formulas and Functions to the next level!

To learn more now, watch one of the FREE preview lectures.

Remember, If you aren’t 100% satisfied with ANYTHING that you’ve learned or you don’t see the results in your work within 30 days of signing up, get a FULL REFUND.

If you’re ready to get started, click on the “Take This Course” button and in just a couple of hours you’ll be amazed at what you can do with Excel.

Who is the target audience?

  • This course is suitable for any level of Excel user from beginning to advanced but it is mostly geared toward beginning and intermediate level learners.
  • This course is for you if you are looking for a clearer understanding of how to use common functions, where to find them and some tips and tricks to make your work with functions easier.

Created by Steve McDonald
Last updated 4/2016
English
English [Auto-generated]

Size: 243.81 MB

Download Now

https://www.udemy.com/excel-2010-formulas-and-functions-how-to-use-excel-tutorial/.

Categories
Office Productivity

Access 2016: Complete Microsoft Access Mastery for Beginners

  • You just need to have a PC, basic computer skills and an installed copy of Microsoft Access on your computer.
  • You don’t need any previous experience with MS Access or Excel.
  • This course starts at the very beginning.

Description

Welcome to the Access 2016 course.

Thank you so much for joining me.

  • Do you need to learn Microsoft Access, but feel intimidated or
    overwhelmed by the thought of it?
  • Are you ready to learn a ton of practical, hands on Access skills?

If so, you found the right course!

This course is designed to get you feeling comfortable and confident using Access. It’s designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.

Is it the Right Fit?

Will this course be a good fit for you? Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you’re ready to fine tune and expand your skills in an easy, stress-free way.

Skills to Impress Your Boss

While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.

Start at the Very Beginning

We’ll start out with a complete tour of Access and it’s tools. Then, I’ll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.

Create a Database from Scratch

  • I’ll walk you through creating a complete Access database from scratch.
  • I’ll show you how to create tables and connect those tables to each other using relationships.
  • I’ll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss.
  • I’ll also share insights and productivity tips along the way.

Let’s Get Started!

Are you ready to take your productivity and hopefully even your job prospects to the next level? Let’s get started with Access 2016.

Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.

Who is the target audience?

  • Anyone who needs to learn Microsoft Access, but might be intimidated or feel overwhelmed by it.r
  • This course is for students brand new to Access.
  • This course is also for students who have some experience with Access or Excel and need to learn more about Access.

Created by Steve McDonald
Last updated 9/2017
English
English [Auto-generated]

Size: 830.09 MB

Download Now

https://www.udemy.com/microsoft-access-2016-for-beginners/.

Categories
Office Productivity

Google Searching Ninja!

  • No experience is needed. The course is from scratch

Description

Konnichiwa aspiring Google Ninja!

In this course, you will be able to inquire knowledge about The Google Search Engine (GSE). You will learn how to use a specialized query, different operators to aim your perfect searching solution.

This course is created in a minimalistic way to save your priceless time but extremely compressed with knowledge.

I will also show you how GSE can be dangerous for your website if you allow Google Robots to index all your site. You will learn how to use Google for Ethical Hacking purposes. How do download almost everything in no time, how to get access to admin panel without password.

Why are we using GSE?

GSE is so famous that there is practically no competition for it. It is not surprising, because it is an excellent product. Search algorithms are currently very well developed, and in most cases, we do not have to bother to find information that interests us. However, not everyone knows the capabilities of this tool, and there are quite a lot of them. It is worth to see how to look for information on the web more effectively.

This course can be helpful for:

  • SEO experts
  • Scientists
  • Data diggers

… and all the people who are using Google for information finding to make this process more efficient.

Who is the target audience?

  • Advanced google searching methods
  • How to hack using google
  • How to safe time when you are struggling with google results
  • Google tips and tricks

Created by Marcin Stasko
Last updated 9/2018
English

Size: 539.70 MB

Download Now

https://www.udemy.com/google-searching-ninja/.

Categories
Office Productivity

Microsoft Excel – Data Analysis with Excel Pivot Tables

  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
  • Mac users are welcome, but note that the Pivot Table interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)

Description

*** Course access includes project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee!***

__________

Hear why this is one of the TOP-RATED Excel courses on Udemy:

“This is a great course. You can feel confident putting this skill on your resume after taking this course. The lectures are in-depth and easy to follow. I would highly recommend this course to anyone who wants to not just learn PivotTables, but become a true expert

-Monique Chin

“Chris provides clear, detailed explanations and shows how to use PivotTables to extract hidden details and facts using raw, real-life data sets. 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. Thanks, Chris!”

-Paul Marriott

“One of the very best Udemy classes I’ve taken – great instructor, awesome production, very comprehensive and exceptionally useful. I have added other Excel courses with the same instructor and look forward to viewing them as well.”

-Ernie Atkins

__________

FULL COURSE DESCRIPTION:

Pivot Tables are an absolutely essential tool for anyone working with data in Excel.

Pivots allow you to quickly explore and analyze raw data, 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 Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fastaccurate and intuitive solutions to even the most complicated questions.

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Pivot Charts. I’ll show you whenwhy, and how to use Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and 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
  • Table layouts & styles
  • Design & formatting options
  • Sorting, filtering, & grouping tools
  • Calculated fields, items & values
  • Pivot Charts, slicers & timelines
  • Interactive dashboards

__________

We’ll then explore and analyze 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 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. I’m here to help you become an analytics ROCK STAR.

See you there!

-Chris (Founder, Excel Maven)

__________

NOTE: Full course includes downloadable resources and project fileshomework and course quizzeslifetime access and a 30-day money-back guarantee. Compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, or Office 365

Who is the target audience?

  • ANYONE who works with Excel on a regular basis
  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis
  • Students looking for a comprehensive, engaging, and highly interactive approach to training

Created by Chris Dutton
Last updated 11/2018
English
English

Size: 1.13 GB

Download Now

https://www.udemy.com/data-analysis-with-excel-pivot-tables/.

Categories
Office Productivity

Inside Excel – Learn 23 Essential Excel Skills the Pros Know

  • Basic Excel knowledge is recommended before taking this course. This course focused on advanced Excel skills.
  • You need to have Excel installed on your computer. Excel 2010, 2013, 2016 or Office 365 with Excel will work.
  • You should have a PC. You can get by with a Mac, but this course is not specifically designed for Mac users.

Description

You don’t have to know everything there is to know about Excel. But, there are a few things the pros know that you’ll want to know, too.

Most of these skills are easy to learn and they will enable you to use Excel in a much more powerful way.

If you use Excel regularly but you don’t feel the sense of confidence and efficiency that you wish you did, this course is for you. It’s designed to teach you the 23 Excel skills that will give you the biggest advantage with the least amount of effort when you use Excel.

Based on my research and experience, these 23 Excel skills are the most important and useful skills you can learn beyond the basics of creating a spreadsheet.

Most of them are easy to learn, and offer huge returns in efficiency for the small time they take to learn.

A few of them will take a little more practice, but I’ve included them because they can be immensely powerful in ways that many experienced Excel users don’t realize.

You know how to use Excel. You’ve get the basics down. Now it’s time to learn the 23 essential skills the Excel Pros know!

Who is the target audience?

  • This course is for the experienced Excel user who wants to get more out of their Excel experience.

Created by Steve McDonald
Last updated 10/2018
English
English [Auto-generated]

Size: 1.59 GB

Download Now

https://www.udemy.com/learn-microsoft-excel-skills-the-excel-pros-know/.

Categories
Office Productivity

Microsoft Excel – Become an Excel Guru

  • This course was created with Excel 2013. However it will also work with Excel 2010, 2013 and 2016 for Windows
  • You’ll need a basic working knowledge of Excel, including things like SUM formulas, entering data, adding sheets etc. If you’re not yet at this level, check out my ‘Getting Started with Excel 2013’ course.

Description

Welcome to Microsoft Excel – Become an Excel Guru, where you are going to learn everything you need to know to become an Excel expert. After working for a decade of training in some of the biggest UK companies and over 13,000 students online, I am here to teach you how to excel with Microsoft Excel. From using Excel formulas and Pivot tables you will learn the fundamentals of data analysis but also how to automate tasks using Excel VBA and some great data presentation tips and tricks.

Here is what students said about this Excel course:

“Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!”

 Mary J. de Guzman

“This is a really great course. He started at what I would definitely consider an intermediate level–and I even learned some things during that part–and then took us well into the advanced usage of Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course.”

 Randy Crane 

“Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion.”- Kaushal Vyas

I’ve split course into 4 modules and here is what they cover:

The first module covers working with data in Excel, where you’ll learn all about how to structure your data, clean it and enrich it using Excel formulas and how to get the best out of the Excel tools such as adding styles and dropdown options to cells. It’s the first step on your way of working faster and more effectively!

The second module is all about data analysis in Microsoft Excel. In this module we take a deep dive onExcel pivot tables – a powerful way to slice and dice your data and really uncover the key trends and insights.

Module three covers presenting your data analysis, with the key focus on learning how to create great looking management reports and Excel dashboards. Being able to present data analysis in a succinct Excel dashboard is a skill that can really take your career to another level.

In the final module, we’ll cover Excel VBA, automation in Excel using Microsoft’s coding language sometimes called Excel Macros. One of the easiest coding languages you can possibly learn can help you automate away repetitive and boring tasks you do in Excel.

Are you ready to take your Microsoft Excel skills to the next level?

Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee!

Who this course is for:

  • This course will take your Excel skills from beginner to advanced level
  • This Microsoft Excel courses will take you through 4 of Microsoft Excel topics (Data, Analysis, Presentation & Automation).

Created by Martyn Blythin
Last updated 12/2018
English
English

Size: 395.81 MB

Download Now

https://www.udemy.com/become-an-excel-guru/.

Categories
Office Productivity

Microsoft Excel – Getting Started With The Basics

  • This course was created with Excel 2013. However it will also work with Excel 2010, 2013 and 2016 for Windows

Description

Welcome to Getting Started with Excel 2013 – a series of Excel video tutorials for beginners. If you’re new to Excel, I recommend taking this course now to learn more about how to get the most out of the Microsoft Excel, get your job done faster and improve your resume. If you have already used Excel but want a comprehensive knowledge of the basics, then you’re in the right place.

This is based on the original getting started with Excel course that I have been teaching in person in the UK banking industry since 2007. Now fully updated for Excel 2013, this course has been used by students all around the globe.

So if you’re looking how to get started with Excel quickly and easily, Getting Started with Excel 2013 will transform the way you work!

Here is what students said about this Excel course:

“This course is exactly as described: a beginner’s tutorial on the most basic and fundamental aspects of Excel. I haven’t used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect “Basics” course!”
–  Vivian P.Welcome to Microsoft Excel – Getting Started With The Basics, where you can learn how to get the most out of Excel, even if you are a complete beginner!

You will learn all about Excel cells, Excel rows & columns, how to speed up your work with Excel sheets and easiest ways of sorting & filtering data in Excel. We will explore some of the most popular Excel charts and Excel functions and from there we will dive into best practices to make sure you know how to effectively use Microsoft Excel.

Here is what students said about this Excel course:

“Useful and easy to follow. Great teacher. I’m self-taught on excel and have used for 17 years…. learning so much from this course that is already speeding up my work!
–  G Wilkinson

“This course is exactly as described: a beginner’s tutorial on the most basic and fundamental aspects of Excel. I haven’t used Excel in almost a decade and needed a refresher to see if I still remembered the most important aspects, and while I definitely do, I also learned a lot of new and interesting tips and techniques (like different ways to force a worksheet to print on a single page). The instructor was articulate, friendly, and concise. This was a perfect “Basics” course!”
–  Vivian P.

“The pace of tutoring and interactivity made the information easy to understand.
– G Parker

As your instructor, I will use my experience of Excel training in some of the biggest UK companies to guide you step by step on your way of mastering the basics of Microsoft Excel.  Whether you’re looking to do your job faster, wow your boss, step up your data analysis game using Microsoft Excel or to improve your resume, you are in the right place.

Course access includes comprehensive workbook with examples, 1-on-1 tutor support, lifetime access and a 100% money-back guarantee!

“The pace of tutoring and interactivity made the information easy to understand.”
– Garith Parker

  “Useful and easy to follow. Great teacher. Im self taught on excel and have used for 17 years…. learning so much from this course that is already speeding up my work!”
–  Graham Wilkinson

Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation – they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it’s full of holes. Eventually they hit a point where their wall can’t sustain any more weight and it collapses. What a waste of time!

This course takes a step-by-step approach to working with Excel. Each lesson builds upon the previous one, so your wall is solid. So whether you’re looking to do your job better, or if you’re looking to improve your resume, you are in the right place.

A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board.

Who this course is for:

  • If you’ve never used Excel before or you want to get a comprehensive knowledge of the basics, this course is for you

Created by Martyn Blythin
Last updated 12/2018
English
English [Auto-generated]

Size: 94.66 MB

Download Now

https://www.udemy.com/getting-started-with-excel-20132/.

Categories
Office Productivity

Microsoft Excel – Advanced Excel Formulas & Functions

  • Microsoft Excel 2007 – 2019 or Office 365 (Some features may not be available in earlier versions)
  • Experience with formulas is recommended, but not required (we’ll review some of the fundamentals)

Description

*** Course access includes project files, quizzes & homework exercises, 1-on-1 expert support, LIFETIME access and a 100% money-back guarantee ***

Hear why this is one of the TOP-RATED Excel courses on Udemy:

“One of the best courses I’ve ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, count me in for the next ones!”

-Julio Garcia

“I have just completed the course and can honestly say that this is the best course I have taken in my life so far. Chris has a real gift of explaining the more difficult Excel functions and making them accessible and understandable. I thought I already knew Excel well but I have learnt so much throughout each section of the course and have already put a lot of it into practice at work. The homework exercises were really beneficial and made sure that each section was fully understood. I love Chris’s teaching style so much I have already purchased his other courses and can’t wait to get started!

-Jon Knights

“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 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 examplesdesigned 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 formatting rules
  • Join datasets from multiple sources in seconds with 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 analytics 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
  • Powerful analytics tools and formulas like INDIRECT, HYPERLINK, 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 I’ve been lucky enough to teach 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 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)

__________

NOTE: Full course includes downloadable resources and project fileshomework and course quizzeslifetime access and a 30-day money-back guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013 or Excel 2016.

Who this course is for:

  • Excel users who have basic skills but want to get really, REALLY good
  • Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

Created by Chris Dutton
Last updated 12/2018
English
English

Size: 1.49 GB

Download Now

https://www.udemy.com/excel-for-analysts/.

Categories
Office Productivity

Excel 2016 – The Complete Excel Mastery Course for Beginners

  • All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning.

Description

Your Excel skills could land your next job.”

– Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don’t.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics and beyond of Excel 2016. It’s perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

Note: This course is specifically designed for learning on a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You’ll start at the very beginning by opening and saving your first Excel document. Then you’ll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.
  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.
  3. Create professional looking pie charts, bar charts, column charts and more.
  4. Create a table and a range and sort your data.
  5. Create pivot charts and tables to do lightening fast analysis of your data.
  6. Learn to use new features of Excel 2016 including 1-click forecasting and 3D maps.
  7. Take your Excel skills to a whole new level to impress your boss and (although it’s ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you’ll learn in this course:

  1. VLOOKUP
  2. COUNT & COUNTA
  3. COUNTIF & COUNTIFS
  4. AVERAGE & AVERAGEA
  5. SUM, SUMIF & SUMIFS
  6. IF
  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets
  2. Tables
  3. Ranges
  4. Pie, Column, Bar and Line charts
  5. Pivot tables
  6. Pivot charts
  7. Tons of tips and tricks to make using Excel 2016 easier every day.

So if you’re ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the TAKE THIS COURSE button or check out one of the free preview lectures to see if it’s the perfect fit for you.

Who is the target audience?

  • This course is perfect for a first time beginner who needs to learn much more than just the basics.
  • This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
  • This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
  • This course would not be useful for an Excel user who has already reached the advanced or expert stage.

Created by Steve McDonald
Last updated 9/2018
English
English

Size: 1.22 GB

 

Categories
Office Productivity

MASTER MICROSOFT WORD BEGINNER TO ADVANCED


MASTER MICROSOFT WORD BEGINNER TO ADVANCED – Download Udemy Courses For Free | freetutorials.us

























Please disable your adblock and script blockers to view this page

Advertisement

Bestseller

English

This course includes

  • 7 hours on-demand video
  • 1 article
  • 30 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

What you’ll learn

  • You will learn how to take full advantage of Microsoft Word
  • Begin with the basics of creating Microsoft Word documents

  • Various techniques to create dynamic layouts

  • Preparing documents for printing and exporting
  • Format documents effectively using Microsoft Word Styles
  • Control page formatting and flow with sections and page breaks
  • Create and Manage Table Layouts
  • Work with Tab Stops to Align Content Properly
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Build and Deliver Word Forms
  • Manage Templates
  • Track and Accept/Reject Changes to a Document

Requirements

  • Microsoft Word 2010, Word 2013 or Word 2016 installed on your computer
  • No prior Microsoft Word Knowledge needed

Description

Material was recorded using Microsoft Word 2013/2016 on a Windows machine, but is relevant to Word 2010, 2013 and 2016. MAC users, since the videos are recorded with the Windows version of Microsoft Word, the interface will be a bit different.

This Course Includes 3 Sections

  • Microsoft Word 101 – Introductory Level
  • Microsoft Word 102 – Intermediate Level
  • Microsoft Word 103 – Advanced Level

Enroll now to go from beginning Word to Advanced user. This course will take you through a comprehensive understanding of the most popular word processing tools on the market. As your instructor I will use my 15+ years of Microsoft Office training to guide you step by step as you further develop your skills in Microsoft Word. Even if you are a seasoned Word users you will be amazed at the techniques and tools you pick up to help you become more productive and efficient in Word.

At completion of this course you will have mastered the most popular and sought after Microsoft Word tools and come away with confidence to complete many Word tasks with efficiency and grace. Below are just a few of the topics you will master:

  • Creating Dynamic Microsoft Word Documents
  • Effectively Formatting a Document with Styles
  • Prepare Documents for Printing and Exporting
  • Manage Large Documents
  • Working with Page and Section Breaks
  • Control Page Orientation
  • Create and Manage Table Layouts
  • Work with Tab Stops to Align Content Properly
  • Insert Media and Images
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Build and Deliver Word Forms
  • Manage Templates
  • Protect Documents from Edits
  • Track and Accept/Reject Changes to a Document
  • Build Dynamic Table of Contents
  • and much, much more…

So, what are you waiting for, enroll now and take the next step in mastering Word and go from Word Newb to Word Guru!

————- COMING SOON —————-

Who this course is for:

  • This course is intended for students who wish to expand their skill set within Microsoft Word

all 106 lectures 06:57:45

 

Size: 2.49GB

 

Friendly Websites

Related Posts