Best Office Productivity Courses

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365

Microsoft Excel all in One Package

This Microsoft Excel course combines 4 different courses.

• Microsoft Excel 101 - An Introduction to Excel

• Microsoft Excel 102 - Intermediate Level Excel

• Microsoft Excel 103 - Advanced Level Excel

• Master Microsoft Excel Macros and VBA in 6 Simple Projects

Material recorded with Excel 2013 but works in 2010, 2013, 2016, 2019 (Office 365)

Recent Student Review

• "You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don't doubt it, buy it. I've learned so much in this course. Hope more courses are on the way because I'd buy every single one of them. Thanks again bro. God bless you and your family."

• "Happy to say that I now "know" excel. I realize there is so much more to learn, but it's a start! Thank you for being such a great instructor... now on to the next class."

• "Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them."

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

• Creating effective spreadsheets

• Managing large sets of data

• Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

• Create dynamic report with Excel PivotTables

• Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

• Audit Excel Worksheet formulas to ensure clean formulas

• Automate your day to day Excel tasks by mastering the power of Macros and VBA

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

Learn the basics of Microsoft Excel and become an effective user

      Welcome to the Useful Excel for Beginners course. 

     In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course are those who have never used Excel before and those who are beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply. 

     As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along the videos while practicing. 

     The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. 

Since this is a free course, Udemy does not offer certificates anymore.

A Beginner's Guide to Microsoft Excel - Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

6 Reasons why you should choose this Excel course

1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

2. Concise - you can complete this Microsoft Excel course within one weekend

3. Business related examples, data analysis and case studies solved using Advanced Excel.

4. You will learn various data analysis techniques using MS Excel

5. Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice

6. Downloadable resources comprising important MS Excel techniques and functionalities

7. Your queries will be responded by the Instructor himself

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel which can be completed within 6 hours. This course will help you learn advanced Excel and various data analysis tools associated with Microsoft excel. We know that your time is important and hence we have created this fast paced MS Excel course without wasting time on irrelevant Excel 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. They have an in-depth knowledge in advanced MS Excel and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,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 on basic Excel features, or advanced Excel functions or maybe on data analysis tools; practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Assignments are aimed at enhancing your skillsets on Microsoft Excel at an advanced level and at analysing data. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack advanced MS Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

• Introduction - In this video, the structure and contents of the course are discussed.

• Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

• Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

• Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

• Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

• Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

• Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

• Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

• Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

• Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

• Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.

• Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

• Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.

• Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool charts

• And so much more!

By the end of this course, your confidence in using MS Excel will soar. You will learn how Microsoft Excel can play a pivotal role in data analysis and related field. You'll also have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

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

Cheers

Start-Tech Academy

FAQ's

Why learn Microsoft Excel?

1. Microsoft Excel helps solve Business Problems

2. MS Excel has some extremely relevant and important data analysis tools.

3. Advanced MS Excel will give you an edge over other candidates in the competitive environment in schools, colleges or workplaces.

4. Microsoft Excel helps you get stuff done

5. Microsoft Excel will make you better at your job (no matter what that is)

6. Microsoft Excel know-how can instantly increase your job prospects as well as your starting salary

How much time does it take to learn Microsoft Excel?

Microsoft Excel is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Microsoft Excel quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn Microsoft Excel quickly.

What are the steps I should follow to learn Microsoft Excel?

1. Start learning from the basics of Microsoft Excel. The first 3 sections of the course cover the basics.

2. Once done with the basic try your hands on advanced MS Excel. Next 7 sections cover Advanced Excel topics

3. Next section will help you some cool new tricks of Microsoft Excel.

4. Practice your learning on the exercise provided with every lecture.

What is the difference between basic and advanced level of Excel?

At Basic level of MS Excel a person

1. Can build excel formulas using: SUM, IF, AVERAGE, COUNT, ROUND

2. Is comfortable building excel formulas to manipulate text and dates

3. Understands and can use the Filter and Sort feature of Microsoft Excel.

4. Can create basic charts like Line chart, bar chart and pie chart

At Advanced level of MS Excel a person

1. Can implement Excel LOOKUP Formulas like VLOOKUP, HLOOKUP, Index and Match

2. Can use conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND etc.

3. Knows what a Pivot Table is and how to build one.

4. Knows what an add-in is and how to install one.

5. Can record a macro and use it later.

6. Can successfully edit/modify simple recorded macros.

7. Can create advanced charts like Waterfall chart and overlay chart in Microsoft Excel

8. Can create solve analytics problem using excel solver.

Start working proficiently on Microsoft Excel and increase your office productivity.

The Authors of this Microsoft Excel course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of advanced MS Excel in today's corporate world.

Microsoft Excel for Business - Excel Formulas and Functions, Excel Charts, Excel Analytics, Shortcuts & Excel Macros

7 Reasons why you should choose this Excel course

1. Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment

2. Concise - you can complete this Microsoft Excel course within one weekend

3. Business related examples, data analysis and case studies solved using Advanced Excel.

4. You will learn various data analysis techniques using MS Excel

5. Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice

6. Downloadable resources comprising important MS Excel techniques and functionalities

7. Your queries will be responded by the Instructor himself

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this MS Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel which can be completed within 6 hours. This course will help you learn advanced Excel and various data analysis tools associated with Microsoft excel. We know that your time is important and hence we have created this fast paced MS Excel course without wasting time on irrelevant Excel 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. They have an in-depth knowledge in advanced MS Excel and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,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 on basic Excel features, or advanced Excel functions or maybe on data analysis tools; practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Assignments are aimed at enhancing your skillsets on Microsoft Excel at an advanced level and at analysing data. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack advanced MS Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

• Introduction - In this video, the structure and contents of the course are discussed.

• Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

• Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

• Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

• Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

• Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

• Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

• Formatting data and tables - This Excel lecture covers data formatting options such as coloring, changing font, alignments and table formatting options such as adding borders, having highlighted table headers, banded rows etc.

• Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

• Charts - This Excel lecture covers charts such as, Bar/ Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Statistical Chart - Histogram, Waterfall, Sparklines

• Excel Shortcuts - This lecture will introduce you to some important shortcuts and teach you how to find out the shortcut for any particular excel operation.

• Analytics in Excel - This Excel lecture covers the data analytics options available in Excel such as Regression, Solving linear programming problem (Minimization or Maximization problems), What-if (Goal Seek and Scenario Manager)

• Macros - This lecture covers the process of recording a Macro, running a Macro and creating a button to run a Macro.

• Bonus Lectures - Waterfall chart in Excel 2016 and previous versions of Excel, Infographics 1: Cool charts, Infographics 2: Cool charts

• And so much more!

By the end of this course, your confidence in using MS Excel will soar. You will learn how Microsoft Excel can play a pivotal role in data analysis and related field. You'll also have a thorough understanding of how to use Microsoft Excel for study or as a career opportunity.

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

Cheers

Start-Tech Academy

FAQ's

Why learn Microsoft Excel?

1. Microsoft Excel helps solve Business Problems

2. MS Excel has some extremely relevant and important data analysis tools.

3. Advanced MS Excel will give you an edge over other candidates in the competitive environment in schools, colleges or workplaces.

4. Microsoft Excel helps you get stuff done

5. Microsoft Excel will make you better at your job (no matter what that is)

6. Microsoft Excel know-how can instantly increase your job prospects as well as your starting salary

How much time does it take to learn Microsoft Excel?

Microsoft Excel is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn Microsoft Excel quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn Microsoft Excel quickly.

What are the steps I should follow to learn Microsoft Excel?

1. Start learning from the basics of Microsoft Excel. The first 3 sections of the course cover the basics.

2. Once done with the basic try your hands on advanced MS Excel. Next 7 sections cover Advanced Excel topics

3. Next section will help you some cool new tricks of Microsoft Excel.

4. Practice your learning on the exercise provided with every lecture.

What is the difference between basic and advanced level of Excel?

At Basic level of MS Excel a person

1. Can build excel formulas using: SUM, IF, AVERAGE, COUNT, ROUND

2. Is comfortable building excel formulas to manipulate text and dates

3. Understands and can use the Filter and Sort feature of Microsoft Excel.

4. Can create basic charts like Line chart, bar chart and pie chart

At Advanced level of MS Excel a person

1. Can implement Excel LOOKUP Formulas like VLOOKUP, HLOOKUP, Index and Match

2. Can use conditional and logical formulas like IF, SUMIF, COUNTIF, OR, AND etc.

3. Knows what a Pivot Table is and how to build one.

4. Knows what an add-in is and how to install one.

5. Can record a macro and use it later.

6. Can successfully edit/modify simple recorded macros.

7. Can create advanced charts like Waterfall chart and overlay chart in Microsoft Excel

8. Can create solve analytics problem using excel solver.

Start working proficiently on Microsoft Excel and increase your office productivity.

The Authors of this Microsoft Excel course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of advanced MS Excel in today's corporate world.

Master 75+ MS Excel formulas and learn data analysis with a top Microsoft Excel & business intelligence instructor

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

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*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.

Master Excel/microsoft Excel- Learn MS Excel - Excel formulas/Excel charts/Excel functions using Excel 2016/Excel 2019

Microsoft Excel is definetly not an easy application to learn and to use. This is why sometimes it's better to have someone that help us learning how to properly work with this amazing APP. Indeed, wether you are:

- A student looking to learn how to use this APP for a school project

- Looking to learn microsoft Excel for professional goals

- Want to improve your knowledge and learn new skills

- Understand microsoft Excel just for personal uses

Or any other reason this course is for you. By using this course to learn this Microsoft APP you will have access to many high quality examples tips and tricks. Also, you will get a complete introduction to all Excel basics and you will be able to work with this app on a daily basis with more confidence.

The structure of the course

​The course is created around a very simple concepte. To learn you need to practice as much as you can. This is why from the moment that you will enter the course and start your Excel journey you will have a lot of Examples and cases that are presented in the course to help you practice everything that you will learn. Not only this will help you become a better user of microsoft Excel but it will give the confidence to start using the App by yourself to be able to create way more andvanced Applications tat will be able to perform different tasks. Thoses App will be able to be used in your personnal life as well as in your professional fiel or at school.

Also, not only this course will help you learn a new skill that is the complete understanding of Microsoft Excel but you will also have a lot of practie inside of the course. So basically, in all the course you will be learning and practicing different concepts functions and formulas and at the end of this course you will have create your own project or small app that you will be able to later use for your personnal, proffessional life or simply for scool,

For who is this course designed

This course is designed for people who have no prior excel knowledge. Indeed, this course is really here to give you a complete introduction to microsfot Excel and give you all the basic knowledge to be able to use this amazing app by yourself. Also, this course can be useful for everyone that always wanted to start there Excel journey and to see the potential of Microsoft Excel. This means that even with no excel knoeledge you will be able to create your own Excel Apps by the end of this course and this a guarantee that I can give you.

Why should I take this course

​Yes, of course there is many other microsoft Excel courses that exist on the internet. But, my way of teaching you how to use this application is unique. Indeed, every concept in this course comes with an example. This will give you a lot of practice so you will be able to think very logically when you will create your own Excel apps. First of all, you will know the process of creating an excel basic app, know how create the plan for your app and then finally make all the creation of the app. This means that with just one course, you will be able to put your full potential into using microsoft Excel and having your own applications that can be used for different purposes.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concepte that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very usefull in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 100 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :)

Excel: learn how Excel can be used for data analysis by creating excel project-excel app-other excel tools

Whether you are interested in learning

- Different ways of how to properly use Microsoft Excel

- Learn the basics of Data Analysis

- Learn how to create different Excel Apps

- Just grow your Knowledge about this amazing Microsoft App

Or any other reason, this course is definitely for you. The way this class have been designed was to offer to the student an easy way to learn Microsoft Excel and the basics of Data analysis at the same time. Indeed, not only this course is teaching you all the basic concepts and functions of Microsoft Excel but at the same time you will have all the required knowledge to create basic Apps that can be used to analyze Data.

The structure of the course

​The way the course is structured is help you learn by practice. In other words, there is way more practice than theory. The main reason of why I structure my courses this way is that for me the best way to learn something is by practicing it enough. This means that if you want to learn how to properly use Microsoft Excel for Data analysis it will be through practice and not simply by learning the theory.

The course is divided in big projects. This way, each time that you learn a new concept you will create a project around it. This will help you not only have a better understanding of the concept but also be able to see in what real life situation a certain concept can be useful.

For who is this course designed

​My goal when I was creating this course was to help the maximum of people not only learn Data analysis but also Microsoft Excel. This means that if you wanted to learn how data is analyzed and at the same time learn the basics of Microsoft Excel then you will enjoy this course. It has been created for everyone who has interest in learning more about Excel, different ways to analyze Data or simply learn a new skill that can be very useful not only in the business world but also in your everyday life.

Why should I take this course

​There is a lot of Microsoft Excel courses that exist, but this course is very unique. Not only it offers you the possibility to learn how to properly use this App, but you will also learn the basics of Data analysis. Also, all the concepts are presented with clear examples and you will be able to learn them by creating your own projects around those concepts. This means that you will have a strong knowledge of Microsoft Excel but also will know and understand how to properly use this app to perform different simple but also more complicated tasks. The best part, is that the APPS that you will create in this course can be used in your business or in your every day life.

There is no risk involved in taking this course

​This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 75 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :) ​

Everything you need to know about Microsoft 365 for 2021

SO, YOU’RE LOOKING FOR A COURSE THAT WILL TEACH YOU OFFICE 365 QUICKLY & IN A FUN MANNER?

I’ve got just the course for you!

Welcome, my name is Josh Werner with Learn Tech Plus and I’ve put this course together to help people just like you quickly master Office 365...Whether you’re a beginner or experienced with Office 365!

If your goal is to become a master of Office 365, then this course is perfect for you. It will get you started on the right path and give you the knowledge and skills you need to master Office 365...

Learning Office 365 is Not only for Experienced users, but also everyone else. Because when you have mastered Office 365, you can get around Office 365 quickly and increase your productivity!

In short, a good understanding of Office 365 is tremendously beneficial.

Now, in this course, we'll go far beyond that. By the end of it, you'll have gained complete proficiency in Office 365 even if you're currently a complete beginner!

LEARN OFFICE 365 BY DOING!

We will go step by step and cover Office 365. The goal here is to help you

A) Setup a Free Account with Office 365

B) Work with Office 365

Here’s what we’ll cover in the course:

1. We’ll start from the very beginning and explain what Office 365 is, why & how it’s used.

2. Introduce you to Office 365

I’D LOVE TO SEE YOU INSIDE THE COURSE AND HELP YOU LEARN OFFICE 365!

Start analyzing data with Excel's most powerful data analysis tool, Pivot Tables. They're easier than you think!

What's this course about

Pivot Tables are one of the most powerful features in Excel. Once you learn how to use Pivot Tables, they'll change the way you use Excel.

If you're not familiar with Pivot Tables, they're a tool that allow you to summarize large sets of information quickly and easily. You can analyze thousands of rows in a matter of seconds that could otherwise take hours trying to figure out using complex formulas.

This is an introductory Pivot Table course and gives the information you'll need to start using Pivot Tables.

Who will benefit from this course

If you're somebody that uses Excel on a regular basis to track or maintain information, you will definitely benefit from learning Pivot Tables.

You don't have to be a master of Excel formulas to take this course, but you should have a sound understanding of how to navigate around Excel before you take this course.

This would be considered an intermediate Excel course and students should understand basic mathematical calculations (e.g. addition, subtraction, multiplication and division) and formulas in Excel.

What you'll learn in this course

• How to create a Pivot Table
• How to summarize information in different ways using Pivot Tables

By the end of this course, you'll be able to take your own information and leverage Pivot Tables to answer questions with ease!

Use Google Data Studio to create reports & data visualizations from Google Sheets| Google Analytics| Google Ads|BigQuery

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 Google Data Studio course within one weekend

• Business related examples and case studies

• Ample practice exercises because Data Visualization and Google Data Studio require practice

• Downloadable resources for learning Google Data Studio and Data Visualization

• Your queries will be responded by the Instructor himself

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

Either you're new to Data Visualization or Google Data Studio, or you've made some charts and graphs using some data 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 have in-depth understanding on and practical exposure to Google Data Studio and Data Visualization.

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, Google Data Studio, Data Visualization, 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 for data visualisation will soar. You'll have a thorough understanding of how to use Google Data Studio for creating insightful dashboards and beautiful reports.

Go ahead and click the enroll button, and I'll see you in lesson 1 of this Google Data Studio course!

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 Google Data Studio and Data visualization techniques in today's corporate world.

Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor

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

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*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.

Learn more than 80+ Excel function/Excel formulas/Excel tips for Excel 2007 to Excel 2019 with Excel examples

If you want to improve your Excel skills, learn to use new functions or simply interested in becoming better in this amazing Microsoft APP then this course is for you. My name is Yassin Marco and I have been lucky enough to have the privilege to teach more than 250 000+ students in more than 190+ countries around the world. Since teaching is my passion, I decided to design this course to help people achieve there full potential with Microsoft Excel. This means that by the end of this course your Excel knowledge will have significantly grown. Indeed, this course teaches you how to properly work with more than 80+ Excel functions and formulas. Also all of those formulas are presented with clear Examples so you will be able to use them to create your own programs. Still not convinced, well not only you will receive a course and support for lifetime but if you are not satisfied you get your money back with no questions asked in the next 30 days.

So if you are looking for THE Excel course you will definitely not be disappointed by this one.

Finding the right Excel course can be really complicated, especially if you have almost no knowledge of this APP and want to learn all the basics. Indeed, whether you are looking to

- Understand the basics of Microsoft Excel

- Learn how to properly work with Microsoft Excel

- Get different Tips and Trick of this amazing Excel app

- Learn new functions and formulas and be able to use them every time that you work with Microsoft Excel

or any other given reason. The way this course have been designed will not only give a compete understanding of this Microsoft App but will also give a complete knowledge of more than 80+ Microsoft Excel functions and formulas​. This is why this course is your best choice to learn this amazing App

The structure of the course

The way this course have been designed is here to help you learn all the basics of Microsoft Excel by practicing them. In other words, this course is divided into categories of functions and each categories will teach you different functions that can be used in a certain field. Each class of the course is strictly reserved in teaching new functions. Also, the way each function in presented will help you learn it much easily. Indeed, not only you will learn the theory around each function but you will also have the chance to practice it. In other words, in each class you will be able to use the function in different real life scenarios. Since there is a lot of practice this is the best way to learn something and be able to master it.

Also, not only you will master new skills, you will also have all the required knowledge to be able to perform different tasks and many fields such as finances, mathematics and statistics. Not only this but you will also be able to put everything you have learned together and use all the functions that you have learned to create your own advanced Excel apps.

For who is this course designed

This course can be very useful for new Excel users that are seeking ways to learn more about this app. Indeed, not only you will learn different ways to use Microsoft Excel with different formulas and functions but you will also have a complete understanding of more than 80+ Formulas. This means that it can be perfect for anyone trying to learn this app. Also, This course could be very good for people who already have experience with Microsoft Excel and who want to push there knowledge of this app a bit further. Indeed, the formulas teached in this course can be perfect for any experienced Excel user that want to learn new Excel functions/formulas and practice them.

Why should I take this course

​This is definitely not the only Microsoft Excel course out there. But, this course is very unique. Indeed, there is almost no course that focus really on teaching you how to properly work with more than 80+ Formulas and functions. Not only you will have the theoretical side of each function/Formula but you will also learn how to use it with different Examples. In other words, each function is at first presented theoretically then you can practice it with different Examples that are given inside of the course ! This is exactly what makes this course so unique, no other courses will give you so much knowledge with practice in only a 5H course. Also, this course is frequently updated, this means that the information will be updated in the future months.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

This is why more than 15 000 students have already took the course !! Don't wait anymore

ENROL NOW and start learning today :)

Microsoft Excel Beginner to Advanced w/ Data Analysis, & Dashboards. Learn Pro Tips, Shortcuts, Formulas and Functions.

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.

Microsoft Excel is one of the most powerful data management, data analysis and dashboarding tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

1. Students

2. Professionals, especially those who have to work with numbers.

3. Daydreamers who wish to bring financial sense to their dreams.

4. Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee: 

Nothing to lose! If you won't be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years

Excel Course: Microsoft Excel From Beginner to Advanced, Ms Excel Formulas, Chart Tips & Tricks in Excel 2019/Office 365

In this special Microsoft Excel - Excel From Beginner to Advanced course you can learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with Ms Excel 2010, 2013, 2016 versions.

If you're a beginner, in the first section you can learn Excel basics in 30 minutes.

Topics covered in the 30-min Getting Started With Excel lecture:

• quick overview of the user interface

• how to save your excel worksheet

• drag & drop gesture

• excel rows, columns, cells

• how to move between cells quickly

• excel data entry

• excel data types

• excel formulas & references

• excel operators

• how to select cells, ranges, columns, rows in excel

• copy & paste data

• AutoComplete feature

• AutoFill feature

• what is function

• define Name

• how to sort & filter your data in excel

• how to create a simple chart with a few clicks

• multiple worksheets

• zoom function

Then we're going to go through several data visualization techniques which you can use to create Excel charts that will impress your audience.

Projects covered:

• highlight max value dynamically on an Excel chart

• discover Excel's conditional formatting feature to highlight key data in your table

• how to create a map chart that reads well by the viewer

• how to use icons in your bar charts to make it exciting

• how to create a progress chart in infographic style

I dedicated an entire section to Excel shortcut keys showing you over 100 Excel shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and more productive you can be.

Shortcuts covered in seven categories:

• general shortcuts

• shortcuts for navigation

• shortcuts for data entry

• Excel formatting shortcuts

• selection shortcuts

• shortcuts for formulas

• miscellaneous shortcut keys

I created a section for the most frequently used Excel formulas/functions. You will find lots of real-world examples in these topics:

• Relative vs Absolute cell references explained

• working with date functions

• SUM(), SUMIF(), SUMIFS() functions

• MIN(), MAX(), AVERAGE(), COUNT() functions

• VLOOKUP(), HLOOKUP() functions examples

• INDEX(), MATCH(), XLOOKUP() functions to search data

In the last section we're getting into an advanced Excel topic. I explain how one of the most valuable Excel features works, the PivotTable. Many people are afraid to use it, but I'll make it simple for you. We're going to build several reports, and create a PivotChart too. I will also talk about database design principles. We will create a Data Model, and I will show you how to use PivotTable with multiple tables. So, you'll be able to use Excel as a real database.

By taking this course you can really take your Excel skills to way above the average.

Don't worry if you're an absolute beginner. I'll explain everything step by step.

If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.

Please watch the Intro video to see what you can expect from this course. Enjoy learning!

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams.

In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

"10 minutes in and I feel like I can save hours" - Alex

"I consider myself quite good at Excel, but your mastery of it leaves me in the ashes. The dashboard presentation was dazzling." - Ben

"Wow! I am so excited to try this myself! Thank you so much for sharing your skills." - Lyn

Very dense information that in just one hour you represented what I have spent days reading books about this subject. - Khalid

"I've been using Excel for over 10 years and I'd like to take the time to say thank you. That was definitely one of the best courses I've ever taken.

It was
incredibly informative, insightful and taught me a few tips and tricks
that will surely aid me in producing automated dashboards. Thank you for
sharing the course materials.

Nothing short of excellent! " - Amanta

You too can master the creation of Interactive Excel Dashboards and learn to build Dashboard Reports from the ground up.

• Design and Display Principles
• Interactive Controls
• Automating your Dashboard so it updates in seconds

Impressive Content that Will Provide Insight, Analysis and Alerts Dashboards are fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard. 

Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets, among a host of other tips that can be used in day to day Excel work.

Automate Complex Tasks with Microsoft Excel VBA & Excel Macros (Real-World Projects included). Achieve More. Save time.

Go from Beginner to Microsoft Excel VBA Expert!

I'll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects. 

What differentiates this course from the other Microsoft Excel VBA & macros courses? It includes:

1. Over 50 Microsoft Excel VBA & macro examples. These are solutions my clients have needed through the years. They are likely to be useful for you too.

2. Using the right VBA syntax is the most difficult part. An important topic which isn't covered enough in other VBA courses. In this course you understand why you write things in certain ways.

3. Create 3 Complete Excel VBA Tools. We go from idea to final product and cover each step.

4. Over 100 pages of documentation (including useful code) so you can easily refer to it when in need.

5. Simple explanations for complex concepts.

6. High quality video and different delivery methods to keep things interesting.

7. Lots of ideas to automate your current tasks.

Learn from Google or from this Course?

I've been there! I first learnt VBA from Google.

It was truly a light-bulb moment, when I realized that Google has some answers - it could give me some of the code I was looking for - but there two things missing:

1. The WHY - why does the code work in one situation but not another.

2. Structure - topic sequence, real-case examples, workbooks, documentation.

Don’t waste your time

Don't waste your time on poor quality videos and confusing explanations. In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing. 

"I have already tried some VBA classes but so far I was never able to apply what I learnt to my own work. This course is different. I have already used some of the techniques Leila is teaching and applied it to my work files. I was able to reduce manual work for me and my colleagues by creating my own macros from scratch. Highly recommended!!!" -- Randy Taylor

"Leila is the real deal... there are many VBA courses on Udemy (some of which I've taken) that merely demonstrate the functionalities. Leila explains the important foundation concepts and how the model is set up allowing you to truly create VBA code from thought rather than copying and pasting from various places. Her class is professionally constructed, with resources and content for each lecture, practice content for you to try things yourself and good Q&A opportunities to answer specific questions. Trust me, this is the course you want to take."  -- Justin Fazzio

What you can look forward to in this course:

• Understand how to use the right syntax in VBA

• Useful Excel VBA codes you can directly use for your work

• Use the macro recorder for simpler tasks and improve the code

• Working with the Visual Basic Editor

• Debugging tools and error handling methods

• Different ways to reference ranges and cells

• Different methods to loop

• How to work with data types

• PivotTables in Excel using VBA

• Importing data from other files and exporting data to text files

• Interacting with other applications (Word, PowerPoint, Outlook)

• ActiveX and Userforms to enhance the Excel interface

• Basically all the knowledge you need to automate tasks in Excel

Spark your skills in Excel! Go from a blank worksheet to pivot tables in 36 minutes. Great for interview prep!

Here's what some students are saying about the course in the Reviews!

"Really concise quick summary and foundation in Excel" - Clare B.

"Instruction was very easy to follow. It was like having a friend show you what to do." - Patrick M.

"Very clear and easy to understand" - Fiona M

 "Great introduction to pivot tables and good examples too."  - John P. 

"Needed this to get ready for a new job, feeling more confident already!" - Daniel H.

"I have been using Excel for years but only in very specific ways. This course gave a good overview of major functions I have never used and didn't know existed. Will be making some accounting pivot charts right away." - Kyrie

The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. You’ll learn how to enter and edit data and formulas. How to format text and numbers. How to filter and sort large tables of data and calculate totals.

Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. You’ll learn how the functions work, and you’ll learn when, and why, to use them in business analytics. Full disclosure: plan for another 45 minutes or so to work through the case studies yourself. I provide all of the files. 

And it’s free! Even though free, it includes all of the features of the standard course: downloadable files, closed captions and quizzes, to help you learn and make it stick. 

This course is designed for people who are preparing for an interview. Starting a new office job. Looking to jump-start their career. And even for those people who are thinking about a longer Excel course, but who aren't sure that Excel is right for them. 

But let’s make something clear: you won’t be an expert. This course is a starting point, the first step on your journey to learn business analytics. It may be as far as you need to go. Let’s find out! Click the button “TAKE THIS COURSE” and get started. 

This Microsoft Excel class will make you a master of Microsoft Excel. The training uses Excel 2013 for Windows.

This training provides you everything you need to know about Microsoft Excel.

From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Microsoft Certified Master Instructor, this course provides comprehensive coverage on Microsoft Excel. A university professor with over twenty years of experience teaching individuals of all ability levels "how to use" Microsoft Excel, Todd McLeod has designed, refined, and perfected this course to make it easy for you to master Microsoft Excel.

In only five hours of videos, provided to you in 75 separate video lectures so that no one online video is too long, you will learn all of the following about Microsoft Excel:

• Learn how to navigate around Excel
• Learn how to enter and edit data in Excel
• Learn how to adjust the way data and information are displayed in Excel
• Learn how to write formulas quickly and easily with the point-and-click method
• Learn how to use relative, absolute, and mixed references in Excel
• Learn how to create powerful calculations with Excel functions
• Learn how to visually represent your data with charts and graphs in Excel
• Learn how to use Excel data tools like sorting, subtotaling, and filtering
• Learn how to "freeze columns and rows" with freeze panes in Excel
• Learn how to remove duplicates from data in Excel
• Learn how to "transpose data" - switching the columns and rows in Excel
• Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts
• Learn how to format worksheets in Excel for impact and appeal
• Learn how to automate Excel tasks with time-saving macros
• Learn how to integrate Microsoft Excel with Microsoft Word
• Learn how to use passwords in Excel to protect your work in multiple scenarios
• Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
• Learn how to use printing and sharing in Excel

As bonus material, you will also learn two very incredible, and super valuable, skills:

• how to harvest data from the web
• how to create online forms which allow you to gather data from individuals

As an additional bonus, you can download all of the Excel project files that are used in the videos so that you can get a “hands-on” approach to learning the material. You will also be shown how to find and download free "Excel templates" which are spreadsheet templates that you can use like "budget templates" or a "calendar template" or a "schedule template."

Another great aspect of this course is that, at the end of this Excel class, you will be given a CERTIFICATE OF COMPLETION. This course has a quiz after every video so if you need to prove that you have learned the material, or if you’re an employer or supervisor that needs to ensure that someone has actually done the work, this is easily done by looking at the results of these quizzes.

This class is guaranteed to teach you Microsoft Excel. Once enrolled, you will have access to this Excel course for the rest of your life. You will always be able to come back to this Excel class to review material or to learn new material about how to use Excel. Described as “fun” and “amazing” and “life changing,” Todd McLeod’s Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can learn Microsoft Excel.

Everything you need to know about Google Workspace (G Suite)

Have you always wanted to learn Google Workspace but don't know where to start?

Would you like to manager accounts and bring your ideas to life?

Then Google Workspace 2021 Ultimate Course is for you!

Hi, I’m your instructor Josh Werner and I’ll be leading you through this course.

Google Workspace is an in-demand skill in 2021.

The course begins with the basics. 

I'll take you through everything you need to know to start adding accounts like an expert with Google Workspace.

You'll learn all the fundamentals of Google Workspace.

This is great for students starting or for IT Personal that need a refresher course on Google Workspace.

There are no requirements necessary to enroll I only ask that you come open minded and ready to learn

Feel Free to look through the course description and checkout some of my preview videos

The course is packed with over 15 hours of hands-on tutorials

Here is What You Will Learn:

01. Introduction

  001. Overview

02. Google Workspace

  002. Overview

  003. What's Included

  004. Pricing

  005. Enterprise

  006. Resources

  007. Summary

03. Get Started

  008. Overview

  009. Setup Account

  010. Summary

04. Google Admin

  011. Overview

  012. Home

  013. Dashboard

  014. Directory

  015. Devices

  016. Apps

  017. Security

  018. Reporting

  019. Billing

  020. Account

  021. Rules

  022. Summary

05. Gmail - Settings

  023. Overview

  024. General

  025. Labels

  026. Inbox

  027. Accounts and Import

  028. Filters and Blocked Addresses

  029. Forwarding and POP/IMAP

  030. Add-ons

  031. Chat and Meet

  032. Advanced

  033. Offline

  034. Themes

  035. Summary

06. Gmail - Account

  036. Overview

  037. Home

  038. Personal Info

  039. Data & Personalization

  040. Security

  041. People & Sharing

  042. Payments & Subscriptions

  043. About

  044. Summary

07. Gmail - Main Menu

  045. Overview

  046. Inbox

  047. Starred

  048. Snoozed

  049. Important

  050. Sent

  051. Drafts

  052. Categories

  053. Chats

  054. Scheduled

  055. All Mail

  056. Spam

  057. Trash

  058. Manage Labels

  059. Create New Label

  060. New Meeting

  061. Join A Meeting

  062. Hangout Contacts

  063. Hangout Conversations

  064. Phone Calls

  065. Summary

08. Gmail - Side Panel

  066. Overview

  067. Show/Hide Side Panel

  068. Get Add-Ons

  069. Summary

09. Gmail - Google Apps

  070. Overview

  071. Search

  072. Maps

  073. YouTube

  074. Play

  075. News

  076. Gmail

  077. Meet

  078. Chat

  079. Contacts

  080. Drive

  081. Calendar

  082. Translate

  083. Photos

  084. Duo

  085. Chrome

  086. Shopping

  087. Finance

  088. Docs

  089. Sheets

  090. Slides

  091. Books

  092. Blogger

  093. Hangouts

  094. Keep

  095. Jamboard

  096. Classroom

  097. Earth

  098. Collections

  099. Arts and Culture

  100. Google Ads

  101. Podcasts

  102. Stadia

  103. Google One

  104. Travel

  105. Forms

  106. More From Google

  107. Summary

10. Google Drive - New

  108. Overview

  109. Folder

  110. File Upload

  111. Folder Upload

  112. Google Docs

  113. Google Sheets

  114. Google Slides

  115. Google Forms

  116. Google Drawings

  117. Google My Maps

  118. Google Sites

  119. Google App Scripts

  120. Google Jamboard

  121. Connect More Apps

  122. Summary

11. Google Drive - Main Menu

  123. Overview

  124. My Drive

  125. Computers

  126. Shared With Me

  127. Recent

  128. Starred

  129. Trash

  130. Buy Storage

  131. Summary

12. Google Drive - Account

  132. Overview

  133. Home

  134. Personal Info

  135. Data & Personalization

  136. Security

  137. People & Sharing

  138. Payments & Subscriptions

  139. About

  140. Summary

13. Google Docs - Main Menu

  141. Overview

  142. Docs

  143. Sheets

  144. Slides

  145. Forms

  146. Settings

  147. Help & Feedback

  148. Drive

  149. Summary

14. Google Docs - Template Gallery

  150. Overview

  151. Blank

  152. Resume

  153. Letters

  154. Personal

  155. Work

  156. Sales

  157. Legal

  158. Human Resources

  159. Freelancer Engagement

  160. Education

  161. Summary 

15. Google Docs - Project

  162. Overview

  163. Project

  164. Summary

16. Google Sheets

  165. Overview

  166. Create Blank Sheet

  167. Create Sheet with Template

  168. File

  169. Edit

  170. View

  171. Insert

  172. Format

  173. Data

  174. Tools

  175. Add-ons

  176. Help

  177. Comments

  178. Share

  179. Summary

17. Google Slides

  180. Overview

  181. Create Blank Presentation

  182. Create Presentation with Template

  183. File

  184. Edit

  185. View

  186. Insert

  187. Format

  188. Slide

  189. Arrange

  190. Tools

  191. Add-ons

  192. Help

  193. Comments

  194. Present

  195. Share

  196. Summary

18. Google Calendar

  197. Overview

  198. Today

  199. Search

  200. Support

  201. Settings

  202. Day

  203. Week

  204. Month

  205. Year

  206. Schedule

  207. 4 Days

  208. Summary

19. Google Keep

  209. Overview

  210. Notes

  211. Reminders

  212. Edit Labels

  213. Archive

  214. Trash

  215. Summary

20. Google Jamboard

  216. Overview

  217. New Jam

  218. Pen

  219. Eraser

  220. Select

  221. Sticky Note

  222. Add Image

  223. Circle

  224. Text Box

  225. Laser

  226. Summary

21. Google Forms

  227. Overview

  228. Create Blank Form

  229. Create Form with Template

  230. Add Question

  231. Import Questions

  232. Add Title and Description

  233. Add Image

  234. Add Video

  235. Add Section

  236. Responses

  237. Customize Theme

  238. Preview

  239. Settings

  240. Send

  241. Make a Copy

  242. Move to Trash

  243. Get Pre-Filled Link

  244. Print

  245. Add Collaborators

  246. Script Editor

  247. Add-Ons

  248. Preferences

  249. Summary

22. Conclusion

  250. Summary

So what are you waiting for? I look forward to going through course with you I’ll see you inside!

Everything you need to know about Google Drive Productivity from Beginner to Advanced Master Google Drive Today!

01. Introduction

  001. Overview

02. Gmail Account Setup

  002. Overview

  003. Setup Gmail Account

  004. Summary

03. New

  005. Overview

  006. Folder

  007. File Upload

  008. Folder Upload

  009. Google Docs

  010. Google Sheets

  011. Google Slides

  012. Google Forms

  013. Google Drawings

  014. Google My Maps

  015. Google Sites

  016. Google App Scripts

  017. Google Jamboard

  018. Connect More Apps

  019. Summary

04. Main Menu

  020. Overview

  021. My Drive

  022. Computers

  023. Shared With Me

  024. Recent

  025. Starred

  026. Trash

  027. Buy Storage

  028. Summary

05. Account

  029. Overview

  030. Home

  031. Personal Info

  032. Data & Personalization

  033. Security

  034. People & Sharing

  035. Payments & Subscriptions

  036. About

  037. Summary

06. Google Apps

  038. Overview

  039. Search

  040. Maps

  041. YouTube

  042. Play

  043. News

  044. Gmail

  045. Meet

  046. Chat

  047. Contacts

  048. Drive

  049. Calendar

  050. Translate

  051. Photos

  052. Duo

  053. Chrome

  054. Shopping

  055. Finance

  056. Docs

  057. Sheets

  058. Slides

  059. Books

  060. Blogger

  061. Hangouts

  062. Keep

  063. Jamboard

  064. Classroom

  065. Earth

  066. Collections

  067. Arts and Culture

  068. Google Ads

  069. Podcasts

  070. Stadia

  071. Google One

  072. Travel

  073. Forms

  074. More From Google

  075. Summary

07. Conclusion

  076. Summary

SO, YOU’RE LOOKING FOR A COURSE THAT WILL TEACH YOU GOOGLE DRIVE QUICKLY & IN A FUN MANNER?

I’ve got just the course for you!

Welcome, my name is Josh Werner with Learn Tech Plus and I’ve put this course together to help people just like you quickly master Google Drive...Whether you’re a beginner or experienced with Google Drive!

LEARN GOOGLE DRIVE BY DOING!

Here’s what we’ll cover in the course:

1. We’ll start from the very beginning and explain what Google Drive is, why & how it’s used.

2. Install some of the software we’ll be using all throughout the course.

3. Introduce you to Google Drive

Master 20+ Excel charts, build advanced Excel visuals & learn data analysis with a top Excel instructor (Excel 2016+)

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Data Visualization course:

"Absolutely great stuff. I really enjoyed it! Chris is truly a Excel guru. I strongly recommend this course to all users looking to improve their skills with Excel charts & graphs."

-Nirav M.

"Excellent from start to finish! I picked up a bunch of Excel data visualization tips that will be useful in the workplace, including some very cool advanced Excel visuals and custom charts & graphs. Loved all of it, and hope I can learn more from this wonderful individual!"

-Robert C.

"At the first part I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then at the second part I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel and data visualization courses!"

-Judit B.

__________

FULL COURSE DESCRIPTION:

Ask people what comes to mind when they think of Excel, and odds are they'll say "spreadsheets". The truth is, Excel is an incredibly powerful and dynamic data visualization platform for those willing to think beyond rows, columns, and primitive pie charts -- and I'm here to prove it.

This course gives you a deep, 100% comprehensive understanding of Excel's latest data visualization tools and techniques. I'll show you when, why, and how to use each Excel chart type, introduce key data visualization best practices, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

__________

We'll kick things off by exploring each of the 20+ charts & graphs introduced in Excel 2016, including: 

• Bar & Column charts

• Histograms & Pareto charts (Office 365, Excel 2016 or Excel 2019)

• Line charts & trend lines 

• Area charts

• Pies & Donuts

• Scatter plots & Bubble charts

• Box & Whisker charts (Office 365, Excel 2016 or Excel 2019)

• Tree Maps & Sunbursts (Office 365, Excel 2016 or Excel 2019)

• Waterfall & Funnel charts (Office 365, Excel 2016 or Excel 2019)

• Radar & Stock charts

• Heat maps, 3-D Surface & contour charts

• Chloropleths & Geospatial maps

• Custom combo charts & graphs

• Sparklines

• And more...

__________

From there we'll dive into a series of 12+ advanced Excel demos guaranteed to turn you into an absolute data viz rockstar. These aren't "textbook" demos that you can find on Excel YouTube channels; these are projects adapted from actual, award-winning work featured by Microsoft, MIT, and the New York Times. I've built my analytics career around data visualization, and I can help you do the same.

We'll cover advanced Excel data viz topics that you won't find anywhere else, including:

• Custom image overlay charts

• Automation with named ranges and OFFSET/COUNTA functions

• Scroll & Zoom functionality with Excel form controls

• Animated charts to visualize changes over time

• Dynamic, custom Excel dashboards

• Value-based chart formatting

• Custom gauge charts & pacing charts

• Grid visuals using Excel array formulas

Whether you're looking for a quick primer, trying to diversify your Excel skill set, or hoping to step up your Excel data visualization game in a major way, this course is for you.

See you there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*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 2016, Excel 2019 or Office 365.

Learn the basics to become an Expert of Microsoft Dynamics 365 (CRM) Enterprise Solution and Boost Your Career Growth.

***Updated the entire course to the latest version of Microsoft Dynamics 365 Customer Engagement (CRM)***

This Microsoft Dynamics 365 course has the highest numbers of students and positive reviews IN THE WORLD!
(Seriously, thank you so much for your Love :) )

If you are a Programmer or Business Analyst or Existing non-Microsoft Solutions Consultant or want to be a Dynamics 365 Consultant, this is the best course to start your learning journey to earn more.

***************************************************

HERE'S WHAT STUDENTS ARE SAYING:

"Overall, this course has been very helpful. I went from not even knowing what Microsoft CRM was to having a good basic understanding of the interface and features of the software. This course has definitely been worth doing and the instructor is great!" - Tyler Martin

"Before starting this course I never heard about Microsoft Dynamic 365 (CRM), one of my friend suggested me to just dirty your hands with MS Dynamic 365 (CRM). Actually I am coming development background so initially its look boring for me but after understanding about Dynamic 365 (CRM), I enjoyed this course very much. Looking forward to join another course. Thanks a lot Abhay. Great work." - Ram Thakkar

"As a complete beginner in this Software this has been very helpful and informative so far. Thank you!" - Aleksander Penev

"It is a very sweet lecture, despite being free. He took his time to explain every details you need to know about MS Dynamics. I am SugarCRM certified developer and willing to dive into MS Dynamics. I will Surely register for more of your courses in future. Thanks Abhay Sharma." - Aremu Habibullahi

"This was a very good course, I am just starting to use Dynamics CRM and this course was very helpful." - Orlando Sanders

"With no experiences in CRM, attending this course was really huge benefits. It guide you trough everything and I like the bonus in end of this course. I will recommended this course to anyone who would like to get into CRM." - Ahmad Hassan

"Thank you so much for creating the course. I enjoyed the learning about the CRM platform. I hope to take more courses in the future to further my career in ICT. Much appreciated" - Seraz Khan

And thousands of positive reviews...

***************************************************

Microsoft Dynamics 365 (CRM) is a Enterprise Business Solution by Microsoft.

It includes:

• Microsoft Dynamics 365 For Sales to help companies improve Sales.

• Microsoft Dynamics 365 For Customer Service to help companies improve their customer support & experience.'

• Microsoft Dynamics 365 For Project Service Automation for managing end to end projects and

• Microsoft Dynamics 365 For Field Service to manage Mobile workforce of the companies.

By the end of this course, you will have complete understanding of all four apps and much more... plus, this is a complete practical course.

The average salary of the Dynamics 365 Consultant is $85,000 - $100,000 Per Annum which will continue to grow...

***************************************************

HERE'S WHAT YOU WILL LEARN:

Module 1: Get Started With Microsoft Dynamics 365

• What Is Microsoft Dynamics 365?

• Microsoft Dynamics 365 Deployment Types

• Microsoft Dynamics 365 Sign Up Process

• Microsoft Dynamics 365 Application Navigation

Module 2: Microsoft Dynamics 365 For Sales Overview

• Dynamics 365 For Sales Important Terms

• Dynamics 365 For Sales Demo

Module 3: Microsoft Dynamics 365 For Customer Service Overview

• Dynamics 365 For Customer Service Important Terms

• Dynamics 365 For Customer Service Demo

Module 4: Microsoft Dynamics 365 For Project Service Automation (PSA) Overview

• Dynamics 365 For Project Service Automation Important Terms

• Dynamics 365 For Project Service Automation Demo

Module 5: Microsoft Dynamics 365 For Field Service Overview

• Dynamics 365 For Field Service Important Terms

• Dynamics 365 For Field Service Demo

Module 6: Microsoft Dynamics 365 Other Important Features

• Dynamics 365 Records And Activities Creation

• Dynamics 365 User Creation And Security Model

• Dynamics 365 Settings And Administration

• Dynamics 365 Customization

• Dynamics 365 Reporting Overview

Quick Recap :)

• Course Quick Recap

I look forward to teaching you this amazing technology.

To Your Success,
Abhay Sharma

#1 Udemy Best-Selling Instructor for Microsoft Dynamics | Microsoft Certified Trainer (MCT)

Learn automation of tasks with Excel Macros and Excel VBA With different Excel Projects

Working with microsoft Excel is not always easy and learning to automate your work with the use of VBA is even harder. Indeed, VBA is a programming language that is really useful in Microsoft Excel especially if you want to be able to automate all the tasks that you want to accomplish. If you :

- Are in school and want to learn how to program With VBA

- Need to learn Excel VBA for work or task automation

- Want to start a personal project that requires you to have Excel VBA knowledge

- Simply want to learn a new skill and improve your Excel knowledge

Then you will love this course. Not only you will by the end of this course have a complete understanding of how the VBA programming language works but you will also be able to use it on a daily basis to improve the quality of the projects that you are creating on Microsoft Excel for work school or any other personal reason.

The structure of the course

The way this course has been created is to help you learn all the Basics that are around the use of VBA with Microsoft Excel. Indeed, with this course you will at first learn the power of Macros with Microsoft Excel. This will already allow to automate the majority of the task that you are currently doing on Microsoft Excel. Then, When you will understand how to properly record your own macro you will learn all the programming behind a macros and write with the use of VBA your own macros. This way you will be able to autome every task that you are doing with microsoft Excel and make every program that you create way more efficient.

Also, another really important aspect about this course is that it will help you learn by practice. In other words, for each element that you will learn you will have a lot of practice. This goes for the macro recording part as well as for the macro creation part. Also, this course has plenty of small projects that are integrated. This will allow you to be able to use all the theoritical knowledge that will will learn and put it into application with this course.

For who is this course designed

If you have a passion for Microsoft Excel and always wanted to learn how to use this program in an efficient way, then this course is definetly for you. Indeed, this course have been created in order to help everyone that start it get all the information you need to be able to work efficiently with excel. Not only you will be able to create more advanced applications by integrating VBA and macros in your spreadsheet but you will also be able to make your life way easier by automating all your tasks. Also, all the futur programs or apps that you will create with Excel will have more advanced features and will become more easier to use.

Why should I take this course

If you want to learn how to properly work with VBA programming language and Microsoft Excel then you should definetly take a look at this course. Not only you will learn all the basics of Macros but you will also learn how to effectively write your own programs directly on microsoft Excel. This will alow you to be way more effective at work since you will know how to automate the majority of the tasks that you are currently doing on microsoft Excel.

There is no risk involved in taking this course

This course comes with a 100% satisfaction guarantee, this means that if your are not happy with what you have learned, you have 30 days ​to get a complete refund with no questions asked. Also, if there is any concept that you find complicated or you are just not able to understand, you can directly contact me and it will be my pleasure to support you in your learning.

This means that you can either learn amazing skills that can be very useful in your professional or everyday life or you can simply try the course and if you don't like it for any reason ask for a refund.

You can't lose with this type of offer !!

ENROL NOW and start learning today :)

Automate reporting tasks with a mapping table

In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table.

Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we'll discuss these special properties in the course.

Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications.

Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different.

The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Recording Macro, Creating Excel VBA form, Fetching data from MS Access, Working with multiple sheets and workbook

Understand what you are going to achieve through the VBA by seeing demo and then see step by step explanation of VBA code. Learn about Excel VBA syntax, Excel VBA form and control, methods of  using forms and controls, several workout examples to see usage of Excel VBA for automation.

In this course, you will learn following stuff in step by step manner

Level 01 – start without coding – Automate tasks using Excel Macro recording

• Demo of an excel macro

   

• What is excel macro

   

• When to use it

   

• How to record a macro/create a shortcut action

   

• How to run a recorded macro

   

• How to create a shortcut for a macro action

   

• How to run a recorded macro on a new dataset (excel workbook)

   

• How to record a relative macro

   

• What is the difference between a relative macro and a general macro.

   

• How to understand what was recorded as macro.

   

• How to delete a macro

   

Level 02 A – Understand Excel VBA integrated development environment

• How to reach VBA window

   

• What are different component of the window

   

• What is use of those components

   

• How to use breakpoint, properties window, edit tools etc.

   

Level 02 B – Understand Excel VBA syntax

• How to define a variable

   

• Different types of variables

   

• How to write a for loop

   

• How to display output in an interactive way

   

• How to write output in a different worksheet

   

• How to take user input through a prompt

   

• How to use user input

   

• How to use record macro to know VBA syntax

   

• How to use breakpoint

   

• How to run macro through click of a button

   

• When you need to write do while / do until loop

   

• Syntax of do while / until loop

   

• How to take input from excel sheet for program execution

   

• How to ensure variable names are correct before execution of program

   

• If else command, If elseif else command

   

• Using mod function (for remainder)

   

• Showing status bar

   

Workout Examples 01 – Using Forms for user entry, chart display etc.

• See a worked out example of a VBA form

   

• Learn about various control, design aspects of Excel VBA form

   

• Learn about why will need form, and such controls

   

• Hide Data sheet and format other sheet to make it look professional

   

• Ensure proper data type

   

• Ensure value selection from combo box only

   

• Learn to define level, text, combobox and button command

   

• Learn to pass dropdown data in combobox

   

• Learn to use form entry into VBA

   

• Learn to write back on Excel form

   

• Learn how to load form while getting excel started

   

• Learn to change properties of control through VBA

   

Workout Examples 02 – fetching data from MS Access using Excel VBA

• How to use Excel as front end and fetch data from microsoft Access database

   

• Where to use this à Greatly useful when many users have Excel but don't have MS access database in the PC

   

• Where Reference is needed

   

• Watch window - how to use it

   

• How to edit the code for many fields and different databases

   

Workout Examples 03 – One sheet per product or agent

• How to use do while loop to let it run for as many records as it has got

   

• How to find block size (starting and ending row for each product)

   

• How to add sheet using VBA and give it a name

   

• How to ensure that the tool remains intact with multiple runs and even a mistake can't cause issue

   

• How to repeat header in each tab or worksheet

   

Workout Examples 04 – Inventory management, coupon assignment and customer communication using Excel VBA

• Traverse through various sheets and workbooks using VBA          

   

• Formatting date              

   

• Writing derived information from one sheet to another 

   

• Passing several parameters to VBA for conditional traversal         

   

  • 3 should mean three coupons to get reserved

     

  • [Coupon code : Validity] will need comma if there are multiple vouchers

     

• Error handling : alert, if there are no coupons     

   

• Protecting Excel tool for further usage   

   

Workout Examples 05 – Reading data from a microsoft access database and writing it into a text file

• Reading Microsoft Access data using VBA

• directly writing output into a text file

• Making the output comma separated 

Workout Example 06 - Designing survey form in Excel VBA with option buttons / list box etc.

Workout Example 07 - Insert Excel VBA form data in MS Access database 

Workout Example 08 - Using pivot table, vlookup and several other formula for a sampling work 

Workout Example 09 - Windows based user authentication and Voice notification of execution of VBA

Workout Example 10 - Running SQL command through VBA. Read Excel sheet as a table inside VBA

You will learn

• Reading complete worksheet data into a table

• Managing named as well as unnamed headers

• Running SQL command inside VBA

• Little advance SQL coding as well (by product)

  • A-B

  • B-A

Workout Example 11 - Voice based reminder tool

You will learn how to remind speaker about how much time is left through automated announcement.

Workout Example 12 - Running VBA code in automated manner

You will learn what is takes to used Windows scheduler to schedule the VBA code to run in automated manner with desired frequency.

Workout Example 13 - Recursive file and folder size within a folder

Many a times we need a tool, which should recursively put file names and file sizes within a folder.

I mean to say that, if you pass name of a folder and say in that folder, it has

1. 11 files

2. 2 folders

   Then it should again go into the 2 folders and if it finds a folder again say in any of the folder, it should go within that folder too and should create result, with name and size of all the files & folders.

Workout Example 14 - Combine all the files inside a folder through VBA

Tasks

1. Combine Multiple files - having same layout (same number of fields and fields are always in the same column) but not neessarily same number of rows

2. Also put file name as first column in the final data set

Assumption:

1. All the data files are in the same folder

2. There is nothing other than data files in that folder

3. Usually data files should have a way to know, which file was referred

4. All the data files are excel files only

Learn Excel formulas and functions from scratch. Download Excel formulas and functions cheat sheet for your daily use.

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Formulas and worksheet functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating and obtaining useful information and insight from your data.

Without formulas and functions, Excel spreadsheet is simply a fancy word-processing document. Welcome to my Excel Formulas and Functions for Beginners course!

I designed this course for beginner level Excel users. But are you an intermediate level Excel user? Want to have a broader, deeper and in-depth knowledge in building Excel formulas and functions? This course is also for you!

I am Kawser Ahmed, your instructor with this course. I am a full time Excel, Excel VBA and Data Analytics blogger. And I am a corporate Excel trainer in my own country. Monthly more than 15,000 Excel users visit my Excel blog ExcelDemy and read my Excel and data related articles and tutorials.

Let’s discuss now what you will learn from this course.

1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them very details.
2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the formulas using Insert Function and Function Arguments dialog box.
3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your Finance related jobs. So this function is covered in details at the start of the course.
4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.  
6. Circular Referencing: Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with formulas, and so on.
7. DATEDIF() and Date related Excel Functions: And I will finish this course with DATEDIF () and other Date related Excel functions!

I am assuring you that what you will learn in this crash course is priceless. I designed this course keeping in mind, to give you a solid base in Excel formulas and function. Thanks for watching. Enjoy the course!

Learn Microsoft PowerPoint, Presentation Skills, PowerPoint 365, and become a Master at Creating/Delivering PowerPoint

This is the only PowerPoint course you will need if you want to learn how to design PowerPoint Presentations AND Create Compelling PowerPoint slides AND Deliver PowerPoint Presentations in a compelling, memorable and engaging manner. Most Important: You will learn how to communicate effectively with ever aspect of your visual and verbal tools.

TJ Walker is the #1 Bestseller of public speaking, presentation skills, communication skills, media training and storytelling courses here on Udemy. He will lead you through every aspect of who to accomplish your primary goal: successful communication.

Imran Afzal is a leading technology expert and trainer and the instructor of many top selling courses on Udemy in the fields of Linux and other IT specialties.

The course is divided into two main parts.

Part One covers all aspects of PowerPoint 365 ProPlus slide design and creation.

Imran Afzal will be your instructor here.

Message from the instructor:

I am going to teach you how to create impressive PowerPoint presentation that will be your guide for effective presentation.  I have covered every single detail about PowerPoint in this course and it is very simple to navigate through.

Course Overview

Section 1 - Introduction

• Quick PowerPoint Refresher

Section 2 – Creating your first PowerPoint Slide

• Download and Install PowerPoint 365

• Access or Start the PowerPoint 365 ProPlus Application

• Selecting Your Slide

• Creating First PowerPoint Presentation

Section 3 - Editing Objects in Slides - Home Menu

• Cut, Copy, Paste, Duplicate Text Objects

• Selecting New Slides, Duplicate and Reuse a Slide

• Slide Layout, Resetting and Adding Sections

• Font Size, Bold, Italic, Underline etc.

• Clear formatting, Highlighting text, Changing text color

• Bullets, Numbering, List Levels, Line spacing, Alignment and Justify

• Add or Remove Columns, Text Direction, Align Text, and Convert to Smart Art

• Drawing Shapes - Text, Circles, Squares and Arrows

• Order, Group and Position Object

• Shape Fill and Outline

• Find, Replace and Select (Editing)

• Insert Shapes and Styles (Shape Format Menu)

• WordArtStyles and Accessibility (Shape Format Menu)

• Arrange and Size Text Objects (Shape Format Menu)

Section 4 - Adding Objects to Slides - Insert Menu

• Inserting Through Slide Themes

• New Slide Options

• Inserting a Table

• Table Styles, WordArt Styles and Draw Borders (Table Design)

• Add Row & Columns, Merge, Size & Align Cells, Table Size & Arrange (Table Layout)

• Insert or Import Excel Table

• Inserting Images (Pictures, Online Pictures, Screenshots, Photo Album)

• Illustrations (Shapes, iCons, 3D Models, SmartArt and Charts)

• Add-Ins (Get Add-ins and My Add-ins)

• Zoom (Insert - Link)

• Creating Links within Insert Menu

• Add Action to Objects (Insert --> Links)

• Add Comments (Insert --> Comment)

• Text, Header & Footer, WordArt, Date & Time, Slide and Object (Insert --> Text)

• Add Equations and Symbols (Insert --> Symbols)

• Add Videos to Slides (Insert --> Media)

• Insert Audio to Slides (Insert --> Media)

• Screen Recording (Insert --> Media)

• Remove Picture Background (Picture Format Menu)

• Picture Corrections, Color Artistic Effects & Transparency (Picture Adjust Menu)

• Compress, Change and Reset Pictures (Picture Format --> Adjust Menu)

• Picture Border, Effects and Layout (Picture Format --> Picture Styles)

• Picture Accessibility and Arrangement (Picture Format --> Arrange)

• Crop, and Change Picture Size (Picture Format --> Size)

Section 5 - Designing Slides - Design Menu

• Selecting Themes

• Variants

• Customize Slide (Standard vs. Widescreen) and Format Background

• Designer View of Slide

Section 6 - Transitions

• Transition from one Slide to Another

• Timing Slides with Sounds and Duration

Section 7 - Animations

• Different Type of Animations (Entrance, Emphasis and Exit)

• Different Type of Animations (Motion Paths and Additional Effects)

• Motion Path Animation for Shapes

• Animation of Pictures and Videos

• Timing Animated Objects

• Objects Sequence or Reorder

• Deleting Animation From Objects

• Adding Multiple Animation to an Object (Advance Animation)

• Animation Pane, Trigger, Animation Painter (Advance Animation)

Section 8 - Slide Show

• Starting the Slide Show

• Setting Up Slide Show

• Rehearse Timings (Set Up Slide Show)

• Record Slide Show

• Play Narrations, Use Timings, Show Media Controls (Slide Show)

• Monitors and Presenter View (Slide Show)

Section 9 - Review

• Proofing, Accessibility and Insight (Review)

• Language (Review)

• Adding and Deleting Comments (Review)

• Comparing Presentations (Review)

• Hide or Delete Ink (Review)

Section 10 - View

• Changing Presentation and Slide Views (View)

• Master Views (View)

• Ruler, Gridlines and Guides (View)

• Zoom (View)

• Color and Grayscale your Presentation (View)

• New Window, Arrange All, Cascade, Move Split and Switch Window

Section 11 – Help

• Get Online Help

• Contact Support

• Feedback

• Show Training

• What’s New

Section 12 - File Menu

• PowerPoint 365 ProPlus Information (FILE --> Info)

• Saving Presentation

• Print, Share, Export and Close

• Account and Feedback

• General Options

• Proofing Options

• Save, Language and Ease of Access Options

• Advance Options

• Customize Ribbon, Quick AccessToolbar, Add-in and TrustCenter (Advance Options)

Part Two will cover all aspects of PowerPoint Presentation delivery

TJ Walker will be your instructor here.

Message from the instructor:

"I am going to teach you how to deliver an effective and memorable presentation while using PowerPoint slides. Remember, any fool can stand up and read off of slides and put everyone in the room to sleep. Then Pat himself on the back that he did a professional job and didn’t make any mistakes and covered all the material. This is shortsighted thinking.

I’m going to teach you the following:

How to start every PowerPoint presentation in a compelling engaging way.

How to not rely on the PowerPoint presentation as your notes or Teleprompter.

A 100% Reliable means of testing The effectiveness of everyone of your PowerPoint slides before showing it to your real audience.

The fastest and easiest way of rehearsing every PowerPoint presentation.

A full proof way to completely eliminate all nervousness before giving a PowerPoint presentation.

The ultimate way of testing the effectiveness of your entire PowerPoint presentation before and after every Delivery." TJ Walker

Excel: The WHOLE Excel Mastery Series In One! From Excel Novice To VBA Programmer - Excel 2013, 2016, 2019 & Excel 365

Over 120,000 students in 201 countries are becoming Excel masters with THIS series. Check out the FREE PREVIEW LECTURES and SEE WHY!

This COMPLETE* course is one of the HIGHEST RATED courses anywhere on Excel, with over 9000 5 STAR REVIEWS:

*Why buy 5 individual Excel courses, when this one complete course will give you everything you'll ever need?

What other students are saying:

"This may be the single, greatest course on Excel in existence. It is that good. Concise, yet comprehensive and informative. The instructor has a gift for teaching in an old-world, grade school type of way, which I find particularly useful. He explains each new concept quite clearly and then builds upon the concepts to establish a very strong foundation. Remarkable class and presentation. I highly recommend this instructor. Brilliant." - Kevin Ward (May 2020)

“Course is more than I expected. Instructor provides in depth knowledge of Excel and is effective at communicating it. This course, practice and effort are making me an Excel WIZ ! Thanks Alan.” – Tom Howard (April 2020)

“This course is by far the best course on Excel. Alan is a great instructor and has an art of teaching from the grassroots level and gradually building up to the advanced level which I think is a great way for the concepts of Excel to sink in the brain.” - Kshipra Jawdekar (April 2020)

Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.

If you run a business, being proficient in Excel can help you see your business in a completely different light.

Congratulations!

If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to super user, to being part of the few Excel Elite, and being able to program your very own full blown applications using VBA (including automating not only Excel, but Outlook, Word, Powerpoint and even Windows itself!).

This complete course contains all the lectures, quizzes, projects, and downloadable resources contained in Levels 1, 2 and 3. In fact, everything you will need to go from novice to coder! There's no need to buy one course after another to become an Excel master...it's all here!

Yes, but 27 hours, Alan?

Don't worry! We have a very (very) active student forum, so new lectures are regularly added in the SQA Sections (Student Questions Answered). If I can't explain something in a post, or I get a particularly interesting question, I'll make a video for you to walk you through your own specific sticking point!

You can find the detail of each section below, but here's a summary of how it breaks down:

Level 1 Beginners: Base course - 3 hours, SQA - I hour

Level 2 Advanced: Base course - 6.5 hours, SQA - 2 hours

Level 3 VBA Programming: Base course - 11.5 hours, SQA - 3 hours

The course is structured so you can dip in and out whenever you want...you don't have to do it all at once :)

Here's what you get inside...

In Excel Essentials: Level 1 Basics - Master Excel Step-By-Step

• Average review HIGHER than the other Microsoft courses on Udemy!

• Average minutes viewed 27% HIGHER than other Microsoft course!

• New students join THIS Excel course EVERY DAY!

Great news! I have added a new bonus section to this course "Student Questions Answered"!

In this section you will find custom made tutorials to answer YOUR specific questions! Just drop a message in the discussion board, and if I can't answer it in a simple message, I'll make a video just for you!

What other students are saying:

"This is the most comprehensive course I've seen on Udemy..." - Renato Ferreira

"This course is a must and it could be the only one you need, if you want to master Excel for any reason. It is well organized, it covers all topics of Excel, from the fundamentals (formatting, writing data, put that data to use, etc...), continuing to a more advance use of the program, like applications for the formulas included in the app. But the part that outstands in the course, is the macro-programming part. It helps you to start programming in VBA in a step by step fashion. The instructor explains every lesson quite well, he is easy to follow, and you can notice he knows the app and have lots of experience with it. He is also very responsive and will reach you as soon as he can in case you have any doubt about the topics covered in the course. For me is a five stars course, thumbs up for a well roundup course." - David Garcia Silvarrey

"This is the best Excel course ever! I like that the topics are broken down into few minutes at a time". - Sheryl Blosel

"This course is wonderful. If you were and absolute beginner like I was, this is the course that you should take. This course starts at the absolute beginning and shows you in detail how to use the program and how to make it do what you need it to. I am almost through section 2 and I cant believe how much I have learned and I couldn't imagine taking an Excel course from anyone else. If you are thinking about getting an Excel course for refreshing your skills, or just starting from the beginning, this is the course for you" - Jake Rose

Next to soft skills, being able to use Microsoft Excel well is probably one of the most sought after skills employers are looking for in today’s competitive market. Make sure you can compete…

• Do you want to master one of the must have skills for any work place?

• Are you willing to invest a little time now for your own future?

• Want to learn powerful, little known tools most users don't know about?

• Do you want to get ahead of your competition?

If you are a complete beginner looking to master Excel, or you just want to brush up on the basics, you've come to the right place. If you want to earn more money by developing a skill set that today’s employers demand, this is the course is for you!

Getting to grips with Excel will give you a distinct advantage in whatever work you currently do, and can open the door to new opportunities.

Many of my students have gone on to get better paying jobs, change career, or even start their own businesses, using the very skills you will soon master.

“I spent over 30 years mastering Excel, so you don't have to!”

In this course we cover in detail all of the basic functions of Excel, and you will learn not only how to use it, but some powerful tools to allow you understand how it works. There is a difference between repeating something and understanding it.

Who is this course aimed at?

Complete beginners, and those who want to build a solid foundation upon which to build their skills.

How is it structured?

Together we concentrate on building a single complete project from beginning to end, using all the basic functions and give you a thorough understanding.

I know your time is valuable, so most lectures are between 3-5 minutes, allowing you to dip in and out when it's convenient for you. This also maximizes your learning, and makes it easy if you ever need to go back to refresh your memory...no need to click through a 40 minute lecture to find the part you're looking for!

There are screencasts, lots of quizzes, presentations, pdfs, downloadable files...all designed to optimize your learning.

What do I get with this course?

• Lifetime access to over 4 hours of HD content.

• Over 50 bite-size lectures, each covering a specific topic in detail. Some of which I have never seen taught before!

• Multiple quizzes to ensure you cement your learning!

• Downloadable source file, practice file, and pdf cheat sheets that you can take with you and quickly refer back to if you are away from home.

• Access to the Q&A forum, so if you have any questions, you can ask me!

What other students are saying:

"This course is exactly what I was looking for. Simply explained, and in a level of detail I could follow. I really enjoyed it, and will recommend it to all my friend"s – Beatrice

"This course [Level 1] gives a solid foundation for a beginner who wants to develop their skills...To sum up Folks, this is a HIGHLY RECOMMENDED course. I will be shortly enrolling myself in the next course with Alan of course" – Alex

"Fantastic course! The instructor is extremely knowledgeable and the way he organized the course makes it extremely easy to follow. I highly recommend this course to anyone looking to increase their knowledge of Excel." – Dan Hughes

So, Why take THIS course?

I have been using Excel for over 20 years, but there is a difference between being good at something and being able to teach it. In that time I have taught thousands of people how to master its power. Because I have taught so many people, I know not to assume you already understand something, and I have probably already heard every question you are likely to have.

This course took over 4 months to produce, and has been tested extensively with hundreds of people. If something didn't work, or wasn't clear, it was revised until it did, to make this the best possible course on Excel.

Of course, we never stop learning, and I will continue to develop this course, and your skills, with your feedback. And remember, if you have a question, post it in the Q&A and I will answer it for you personally.

***************************************************************************************************************

In Excel Essentials: Level 2 - Intermediate/Advanced:

THIS course will take your Excel skills to the next level!

• New "Student Questions Answered" added

• The HIGHEST RATED Excel Level 2 course on Udemy!

• Average minutes viewed almost triple that of other Microsoft courses!

So, you have an understanding of the basics, but would you like to use Excel like the professionals? If so, read on…

For students who have already completed Level 1 in this series, or already have a good basic understanding of Excel, what you will learn in this course will supercharge your skills... and your career.

So, What’s inside?

• Over 90 bite-sized lectures

• 8.5 hours of quality HD content

• 41 downloadable resources

• All the source files for each project

• Access to me (in case you have any questions)!

You will learn powerful and little known techniques to enable you to build your own powerful spreadsheet solutions. We will do this by creating multiple projects together, step-by-step, and in depth to guarantee your understanding. Each project builds on the last, so your skills develop cumulatively.

What other students are saying:

"This is a great course for anyone wishing to learn or brush up on the basics. The presentations are easy to follow!" – Pamela Reyna

"This is a very simple, clear and concise and easy to follow course that is perfect for beginners" – Sean Loftus

"The author of this course takes you through it one simple step at a time, and it is really easy to follow. I like that the lectures are short, and focus on one thing at a time, which was perfect for me. I actually now feel confident using Excel. Well done and thank you!"– Nickie Student

You will learn how to combine multiple functions in a simple way to create powerful solutions that most users believe can't be done in Excel!

Each project in the course is designed to introduce a range of concepts that showcase the true power of Excel, and show you what is really possible.

In Project One:

• The fastest way to create powerful dynamic templates (by cheating!)

• Custom formatting

• Manipulating calculations with time and dates

• Conditional formatting

• Simple and nested logical testing

• Building complex and dynamic text strings

• ActiveX controls (and how to customize them)

In Project Two:

• Building a fully functional complex relational database

• A Masterclass in Vlookups (WAY beyond the basics here!)

• Importing data from multiple sources

• Controlling user entry

In Project Three:

• Creating named ranges (and why you would want to)

• Building dynamic named ranges

• Getting Excel to create them for you!

• A powerful trick very few users know about!

In Project Four:

• Hyperlinking (so it ALWAYS works!)

• Creating Macros, and using them to automate your work!

• Executing Macros from buttons

• Dropdown lists

• Building dynamic formulas using Excel’s Indirect function

In Project Five:

• Project management made simple with Gantt charting!

• Have your chart timeline ALWAYS begin at the best date

• Nesting multiple logical tests (simply!)

• Making your timeline completely dynamic by changing a single cell!

This isn't just a course with a bunch of formulas, it's hands on guide through real life projects. You will learn how to build complex solutions using the very same methods I use.

***************************************************************************************************************

In Excel Essentials: Level 3 - VBA Programming:

If you really want to harness the full power of Excel, then learning how to program in VBA is ESSENTIAL!

If you got this far, it's because:

• You want to join the Excel elite, and program your own solutions?

• Maybe you want to automate most of your work, do more in less time with less effort?

• Could be you want to earn more money?

• Perhaps you may even fancy a career change?

If you answered yes to any of the above, I want you in my student community!

In this course you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before!

What other students are saying:

"This is a great course! ...I can't wait to start using it. I will certainly be using the emailing program! And reports. My mind is reeling!" - Nickie Student!

"Taught in easy bite size chunks makes the learning fun as well as informative" – Joe Long

"If you are serious about learning how to make excel work for you, you should take this course" - Beatrice

Introducing Visual Basic For Applications

Visual Basic for Applications, or VBA, is included with Excel, so there's nothing more to buy. If you have Excel, you already have access to VBA.

VBA is the powerhouse. It's the code that lives under the hood where the magic happens.

A lot of people can record a Macro, but being able to program in VBA is quite a different thing. It separates the good from the truly amazing, and I want you to be amazing!

Now, one of those words in "Visual Basic for Applications" carries more weight than the others. And no, it's not "Basic" (though coding the way I will teach you is simple!).

No, it's "Applications". In fact, it's the "s" at the very end. The significance is that VBA works across ALL MICROSOFT APPLICATIONS! Word, Outlook, Access, PowerPoint, Internet Explorer, and even WINDOWS ITSELF!

In this course I will not only teach you how to code for Excel, there are even THREE, no...FOUR Bonus Sections:

• Controlling Word

• Controlling Outlook

• Yes, even controlling Windows

• and now...Automating PowerPoint!

What Makes Me Qualified To Teach You?

Well, I'm a regular guy. I don't have a University degree, but what I do have is the drive to learn new things and never be beaten by a problem...a lot like you, I guess.

What I also have is over 20 years of experience in using Excel, and programming solutions with VBA.

I have built simple helper systems to make life easier for my colleagues. I've programmed complete MRP systems to run the procurement division of a £1.3b company, and everything in between.

So, I can do it, does that mean I can teach you?

You bet! I have taught hundreds of students one on one, and even more in groups. Many of my students have gone on to better paying jobs, start their own businesses, or at the very least made their work lives less stressful! One of my most recent students got a promotion and a 15% pay rise just 16 weeks after learning how to code! Not bad, hey?

Why Is Your Course Different, Alan?

I'm glad you asked!

If you got this far, you already know you get:

• Over 15 hours of HD video lectures

• 72 downloadable resources

• Quizzes

• All the source code for the course + more!

• Programming projects

There are lots of great courses on coding in VBA. There are even lots of free videos on YouTube. Many of them show you all the basics in kind of a "little bit of everything" approach. I looked at what was available, and I knew I had to create something different. Of course, I still cover all the basics, just like the other courses, but we will go beyond the basics, and cover in depth the "missing bits".

In addition, I will teach you my step-by-step process, the actual methods I use to build powerful solutions easily and quickly. I'm sure programming can be difficult, but not the way I do it!

You will learn how streamline your code for efficiency (and make it execute faster!) from the beginning. After we've covered all the basics, we will go on to create 6 separate projects using those very tools and techniques, where we will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!

What other students are saying:

"I'm coming close to finishing this course...This course has given me the knowledge and confidence to succeed, get promoted and think seriously about building a career based on what I can learn from great teachers like Alan." - Thomas Heaton

"Alan is an excellent tutor, goes very deep into every single thing, and he is not bothered to repeat even the smallest tricks and tips along the way. I feel like I got amazing new skill, this course has opened my eyes on how I should "see" excel from now on. Definitely the best course I have ever taken on Udemy" - Aleksandar Stankovic

With So Much Power, What Will You Create?

With the skills you will learn in this course you will be limited only by your imagination.

If you can describe it, you can most likely code it. What will YOU create?

Let's see. Enrol now, and I look forward to welcoming you to the course!

Create 5 PowerPoint Slides for any Presentation. Follow my PowerPoint Presentation & Animation Slide Tutorials

In the brand new 'PowerPoint Slide Design' series I am happy to invite you to its first release. In the #1 edition we will be designing 5 Casual Business Slides for any type of presentation! I will teach you interesting PowerPoint tricks, tell you how to lay out your slides so they are catchy and pleasant for the viewer and so much more! I will take you by hand and design the slides along with you, so you never have to worry anymore about comming up with ideas, because this class will set the tone for you to follow with even more slides afterwards! Take a short preview around this course.

Preview some of the animations:

Features:

• 5 Outstanding Slides
• On-Trend presentation design
• Brainstorm & ideas to follow-up
• Master PowerPoint in a quick fashion
• *.PPTX file included for personal usage
• Design tips, tricks & shortcuts for PowerPoint
• Confidence and intuition while designing presentations

There is no time to waste if you want to learn PowerPoint quick, efficient and become a better designer under an hour. I share years of my PowerPoint experience packed in tutorials in a concise manner. This series will be for everyone who would like to ramp up their Powerpoint skills in 1 day. It doesn't matter which version of PPT you use as the tips share will allow you to create powerful slides in PPT 2007 / 2010 / 2011 MAC / 2013 or 2016. 

Let's start....Enroll Now!

Everything you need to know about Microsoft Teams

SO, YOU’RE LOOKING FOR A COURSE THAT WILL TEACH YOU MICROSOFT TEAMS QUICKLY & IN A FUN MANNER?

I’ve got just the course for you!

Welcome, my name is Josh Werner with Learn Tech Plus and I’ve put this course together to help people just like you quickly master Microsoft Teams...Whether you’re a beginner or experienced with Microsoft Teams!

If your goal is to become a master of Microsoft Teams, then this course is perfect for you. It will get you started on the right path and give you the knowledge and skills you need to master Microsoft Teams.

LEARN MICROSOFT TEAMS BY DOING!

We will go step by step and cover Microsoft Teams. The goal here is to help you

A) Setup an Account free with Microsoft Teams

B) Be able to Download and Install Microsoft Teams Desktop App

Here’s what we’ll cover in the course:

01. Introduction

  001. Overview

02. Products - For Business

  002. Overview

  003. Plans and Pricing

  004. Small Business

  005. Summary

03. Business Premium Account

  006. Overview

  007. Setup Account

  008. Summary

04. Admin Center - Main Menu

  009. Overview

  010. Home

  011. Users

  012. Devices

  013. Groups

  014. Roles

  015. Resources

  016. Billing

  017. Support

  018. Settings

  019. Setup

  020. Reports

  021. Health

  022. Security

  023. Compliance

  024. Endpoint Manager

  025. Azure Active Directory

  026. Exchange

  027. SharePoint

  028. Teams

  029. Summary 

05. Teams - Web App

  030. Overview

  031. Launch Teams Web App

  032. Activity

  033. Chat

  034. Teams

  035. Calendar

  036. Files

  037. Apps

  038. Help

  039. Download Desktop App

  040. Settings

  041. Summary

06. Teams - Desktop App - Introduction

  042. Overview

07. Microsoft Teams Account

  043. Overview

  044. Setup Free Account

  045. Download Desktop App

  046. Summary

08. Activity

  047. Overview

  048. Feed

  049. My Activity

  050. Type to Filter

  051. Unread

  052. Mentions

  053. Replies

  054. Reactions

  055. Missed Call

  056. Voicemail

  057. Apps

  058. Trending

  059. Summary

09. Chat

  060. Overview

  061. Type to Filter

  062. Type a New Message

  063. Format

  064. Set Delivery Options

  065. Attach

  066. Emoji

  067. Giphy

  068. Stickers

  069. Praise

  070. Messaging Extensions

  071. Summary

10. Teams

  072. Overview

  073. Invite People

  074. Join or Create A Team

  075. Posts

  076. Files

  077. Wiki

  078. Add A Tab

  079. Open People Panel

  080. Channel Notifications

  081. Pin

  082. Manage Channel

  083. Get Link To Channel

  084. Add More People

  085. Create More Channels

  086. Open The FAQ

  087. Summary

11. Files

  088. Overview

  089. Views

  090. Cloud Storage

  091. Add Cloud Storage

  092. Summary

12. Apps

  093. Overview

  094. All

  095. Personal Apps

  096. Bots

  097. Tabs

  098. Connectors

  099. Messaging

  100. Top Picks

  101. Analytics and BI

  102. Developer and IT

  103. Education

  104. Human Resources

  105. Productivity

  106. Project Management

  107. Sales and Support

  108. Social and Fun

  109. Upload a Custom App

  110. Summary

13. Help

  111. Overview

  112. Topics

  113. Training

  114. What's New

  115. Suggest a Feature

  116. Give Feedback

  117. Summary

14. Conclusion

  118. Summary

I’d love to see you inside and help you learn and master Microsoft Teams!