Posted in #design,  #business, FoodMarketing, https://t.me/CAG_study_Center, Marketing

Introducing New FileMaker 17 features

Detailed Descriptions and Examples of the New FileMaker 17 Features

Introducing New FileMaker 17 features
Detailed Descriptions and Examples of the New FileMaker 17 Features

Covers new FileMaker 17 features like Found Set Portals, Multiple Email Attachments, Data Migration Tool, Universal Touch Theme, Modifying Grouped Objects, Default Fields, Copy and Paste Custom Menus, Calculated Perform Script, Get(ActiveRecordNumber) and More! Many example files are included so you can really pick apart this new version. Get ready for this exciting new version and start learning today!Who this course is for:

  • Intermediate to Advanced FileMaker Developers Interested in the New FileMaker 17 Features
  • Budding FileMaker Developers should look to other Courses for Guidance
Posted in #design,  #business, Development, FoodBusiness, udemy free course

Database Engines Crash Course

MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB

Database Engines Crash Course
MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB

Database engines or storage engines or sometimes even called embedded databases is software library that a database management software uses to store data on disk and do CRUD (create update delete) Embedded means move everything in one software no network client-server. In this video course I want to go through the few popular database engines, explain the differences between them and finally I want to spin up a database and change its engine and show the different features on each engineWho this course is for:

  • Software Engineers and Database Engineers
Posted in #design,  #business, cyber security, Development, FoodBusiness, udemy, udemy free course

Google Sheets: Pivot Tables + Data Insights For Beginners!

  • Do you have data in Google Sheets and not sure how to make it useful? Then this course is for you!
  • Do you want to get on the path to being Data-Savvy? Then this course is for you!
  • Do you want to grow your Google Sheets data skills? Then this course is for you!

This course has been *designed by a former Google Analytical Lead* so that you can get comfortable going from rows and columns of data in a Google Sheet to useful insights via pivot tables.

This course includes numerous hands-on examples and practice exercises that will get you feeling data-savvy.

As a bonus, practice exercises and lecture examples are included in a spreadsheet that you can keep as part of the course.

This course is broken out into 8 key sections:

  • Section 1: Introduction (what are pivot tables and how they are used in the real-world to surface data insights)
  • Section 2: An Overview of the Data Insights Pivot Table Process
  • Section 3: Applying the Data Insights Pivot Table Process
  • Section 4: Practice Exercises: Set 1 (Titanic Dataset)
  • Section 5: Solution Videos for Practice Exercises: Set 1 (Titanic Dataset)
  • Section 6: Practice Exercises: Set 2 (Red Wine Dataset)
  • Section 7: Solution Videos for Practice Exercises: Set 2 (Red Wine Dataset)
  • Section 8: Course Wrap + Bonus Content

The content has intentionally been curated for practitioners who want to apply learnings right away.

This is NOT a long drawn out course that goes deep in the weeds on academic theory.

Make the transition from decisions based on gut feel to data informed decision making!

Use this efficiently designed course to level up your data skills. Get started today! 

#AlwaysBeLearningWho this course is for:

  • Data insights beginner who wants to learn to further explore data and surface insights that can inform business decisions.
  • Anyone not comfortable extracting insights from data using Google Sheets.
  • Professionals who are not satisfied with their job and who want to get on the path to building a data analytics career.
  • Any students in college who want to get started learning data skills.
  • This course is not for those who are already doing advanced data analysis with Google Sheets pivot tables.
Posted in #design,  #business, cyber security, Development, FoodBusiness

Batting Location Charts with Vagrant and MySQL

Use R and MySQL together to create batting location charts from large data sets.

Hello beautiful people out there!!!

This course is about working with large sets of PITCHf/x data to create batting location charts. We use R to scrape and visualize the data and MySQL to store the data. The course includes lessons on how to install a virtual Ubuntu machine, how to install MySQL, how to perform basic MySQL administrative tasks, and how to connect R and MySQL.

It would be best if you have some knowledge of R and gg plot. This can be obtained through my previous three courses in baseball analytics. However, it might be possible to follow along without this.

At a relaxed pace, the course should take about two weeks to complete.Who this course is for:

  • This course is for those who want to learn how to create a hit location chart from PITCHf/x data.
  • The course is also for those who wish to know a little about working with R and MySQL together.
  • The course is NOT for complete beginners in R.

Posted in  #business, Development, Office, udemy free course

Minitab: Complete Minitab Course Part 1 for Minitab Mastery

Minitab: Complete Minitab Course Part 1 for Minitab Mastery

In this course we have 6 different sections.

In Section 1 we have introduction where we will look at Agenda of course.

Next In section 2 we have graphical Analysis where we will look at different types of data types, different types of graphs with both theoretical concepts and how to plot those graphs using a hypothetical data sets.

Next in In Section 3 we will look at descriptive statistics. In this section we will look at what is mean, median, range, variance and standard deviation with formulas, once theoretical concepts are understood then we will look at how to calculate descriptive statistics in Minitab.

Next in section 4, we will look at inferential statistics. In this section we will look at concepts like inferential statistics, what is meant by random sampling, sampling distribution, central limit theorem and t-distribution introduction concepts.

Next in section 5, we will look at hypothesis testing, in this section we will look at concepts like confidence intervals, hypothesis testing, null hypothesis, alternate hypothesis, type I and type II errors and we will look at hypothesis tests like, 1 sample t-test, 2 sample t-test, 2 variance test, paired t test, 1 proportion test, 2 proportion test, chi-square test etc.

Next in section 6, we will look at statistical process control charts. In this section we will look at horizontal lines in control charts like mean, upper control limit, lower control limit, and we will look at the pre-requisites for a process to be a stable process.

Sections 7 to 10 are discussed in part 2 of this Minitab complete course from beginner to advanced part 2 / 2.

Tags: minitab, minitab 18, minitab software, minitab 17, minitab free, minitab 19, minitab online, minitab 16, gage r&r minitab, minitab for students, minitab statistical software, minitab 15, minitab cost, minitab free student, minitab full, minitab online free, minitab 2020, minitab 2019, six sigma, minitab six sigma, lean six sigma, minitab training, minitab training courses, minitab online training, minitab classes, minitab certification course, minitab software trainingWho this course is for:

  • The ideal student for this course is anyone who wants to learn and understand data analysis using Minitab or a professional who wants to expand on their current skills. There are no requirements necessary to enroll. I only ask to come open-minded and ready to learn.
Posted in #design, cyber security, Marketing, Office, office productivity, udemy free course

How to Find a Winning Products For Dropshipping

How to Find a Winning Products For Dropshipping

Use my proven step-by-step guide to find the exact products you can dropship to start making 10k/month on your Shopify store. Hi I’m Aviv, when I was first starting out; I used to waste countless hours and dollars testing out product after product just to see if I was lucky enough to find a winner. This led to nothing but deeper debt. After countless money spent and a lot of failed products, I found my first successful product, then the next, and the next. I realised that there was a pattern between the failed products and the winners. Below is a sneak peek at two categories of successful products you can use for online success.

Trending products, and Universal products.

Trending products are sudden products that consumers find interesting enough to purchase for an event, movement, or season. As the name states, these products don’t last forever. They can make you thousands of dollars in a short amount of time however. In my course I’ll show you how I made my first $10,000 through these products and show you how you can do it too.

Universal products are products which have a continuous stream of consumers who are always looking to purchase this product every month. You won’t be able to scale this product to thousands of dollars in a day; however, you can generate a steady profit off them each month. The more universal products you discover the longer your store can remain profitable.

Get my guide now, and watch your online marketing dreams come true.Who this course is for:

  • Anyone who sell products online
Posted in #design,  #business, Development, Marketing, Office, office productivity, udemy, udemy free course

Tally ERP9 With GST Step By Step Guide From Basic to Advance

Tally ERP9 With GST Step By Step Guide From Basic to Advance

What you’ll learn

  • What is Accounting?
  • What are the Accounts types?
  • What are the Methods of Accounting Entry System Use?
  • How to install the Tally?
  • How to create the Company in tally?
  • Introduction to Tally
  • What are the Accounts Groups of Tally?
  • How to create the Ledgers in tally?
  • How to Enter the opening balance in to Tally?
  • How to Work with Ledger & Trail balance?
  • What are the Types of Vouchers use in Tally?
  • How to enter the transactions in to the vouchers?
  • How to Work with Ledger, Vouchers & Transactions?
  • What Is Bank Reconciliation Statement?
  • How to Reconciliation Bank Statement?
  • Why Company’s Bank Accounts Balance Differ from Bank Statement?
  • How to reconciliation company’s bank accounts with bank statement?
  • What Is Inventory?
  • What are The Process of Inventory Creations?
  • How to Work with inventory creation with Company Accounts?
  • How to check company’s Stocks in tally?
  • What Is Godown?
  • How to activate Godown?
  • How to Create Godown?
  • How to Work with Godown creation with Company Accounts?
  • How to check stock balance based on Godown wise?
  • What Is Payroll?
  • How to activate payroll?
  • What is the Process for payroll in Tally?
  • How to calculate Payroll for each employee?
  • How to obtain payment advise for Employee’s payroll?
  • What Is GST?
  • What are the Models of GST?
  • What is the Common GST Rate?
  • How to work with GST in tally?
  • What Is the Top 25 Shortcut Keys In Tally?
  • How to Export The Tally Report as a Excel Format?
  • How to Export The Tally Report as a Html Format?
  • How To Backup And Restore The Data From Tally?

Show moreThis course includes:

  • 8 hours on-demand video
  • 14 downloadable resources
  • Full lifetime access
  • Access on mobile and TV

Requirements

Description

Tally is widely use ERP Systems in the world and more than 1.6 Million users are used around the world and it helps to maintenance our Daily company’s transactions with prefect and Easy manner. it is assist to maintenance Accounting transactions, inventory management, tax management, payroll management and GST with Little Effort.

Welcome to Tally ERP9 With GST Step By Step Guide From Basic to Advance Course , The Course is Most Essential for Who are working as An Accountant in a Company, Future Tally Users, Commerce Students and Financial Managers. I Hope You Will Learn Lot about TALLY ERP 9 From Basic to Advance and It Will Help to improve Your Career Path.

WHAT ARE THE BENEFITS OF THE COURSE ?

  • Become a Master in Tally ERP9 In Multiple areas such as Ledger creation, Voucher Creation, Bank Reconciliation, Inventory Management, Payroll Management , GST
  • 14 Real world Practical Example Demonstrate by Instructor
  • 8 Hours Complete Demonstration Course including GST
  • 14 Downloadable Resources for Practice with TALLY ERP9

In this course, I have covered Tally ERP 9 From Basic Concepts to Advanced Concept Including GST and The Course Designs to Learn Tally ERP 9 Step by Step with Real World Practical Examples. The Course Divided 14 Chapters and The Details as Below.

CHAPTER-01 INTRODUCTION TO ACCOUNTING

CHAPTER-02 TALLY INSTALLATION AND COMPANY CREATION

CHAPTER-03 INTRODUCTION TO TALLY

CHAPTER-04 LEDGER CREATION WITH TRAIL BALANCE

CHAPTER-05 TYPE OF VOUCHERS IN TALLY

CHAPTER-06 TRAIL BALANCE WITH TRANSACTION

CHAPTER-07 BANK RECONCILIATION IN TALLY

CHAPTER – 08 INVENTORY CREATION IN TALLY

CHAPTER – 09 GODOWN CREATION IN TALLY

CHAPTER -10 PAYROLL IN TALLY

CHAPTER -11 TALLY WITH GST

CHAPTER-12 TOP 25 SHORTCUT KEYS IN TALLY

CHAPTER-13 EXPORT REPORT IN TALLY

CHAPTER-14 BACKUP & RESTOREWho this course is for:

  • Tally ERP 9 Users
  • Accountants
  • Financial Managers
  • Tally Learners
  • Commerce Students
  • Non Accounting background students
Posted in cyber security, Internet Security, Marketing, udemy, udemy free course

Robust Qt & C++ Gui Programming 2D Graphics App Tutorial

Robust Qt & C++ Gui Programming 2D Graphics App Tutorial

This course will help you upgrade your C++ software development skills today!

You will learn how to build an application using Qt and C++, from the ground up.

**This course is now FREE as a token of gratitude to my Udemy followers; Enjoy!**

As I’ve put my heart and soul into producing this course, I understand it’s no longer up to date with the Qt platform.

But it does still have valuable insights into robust app design, so I believe you’ll find quite a bunch of useful stuff in here

Here’s what others have to say about this course:

“Great course. Instructions are clear and accurate. Dan logically teaches how to build an app from the simplest parts to the harder ones. Tasks for you to complete are getting a little bit bigger every time and you don’t feel lost between instructions and the tasks as they are connected to each other (unlike in many other courses). Even though for me this course wasn’t hard it was useful and I enjoyed it very much. After finishing the course I found out that there are new videos and new tasks! That’s awesome! I like that course is being improved! ” – Kateryna Brylliantova

“One of the best courses I ever had. Very well structured, very good program structure and complexity of the application. The explanation should be an example for many ohter teachers. A big and real triple-A. Thank You, Dan.” – Matthias Kunka

“Well thought out and paced, I have learned quite a few interesting points on robust code.”  – Asad Raja

“I felt this was a very good course for intermediary C++ programmers. It has some easy to follow for the novice sections, but also plenty for the seasoned programmer.” – Gino Manifred

C++ is a very powerful and versatile programming language.

Qt is multi-platform framework, the perfect choice for open source GUI development with C++.

Before investing in this course, please watch the FREE lectures (30 minutes) to: 

  • see the final app in action (check out the Final App DEMO lesson)
  • decide if this course is really the right one for you

With this course, you will design and create your own C++ program for the Windows platform.

You will add new features to the app, step by step.

You will learn how to write good source code, at professional-level.

You can learn programming in C++ from anyone you wish to, there are many teachers and a lot of free know-how out there.

But if you want to learn to code like a professional, here’s my advice to you:

  • Choose to learn from someone who has already done professional level coding
  • Choose a teacher who has a proven track record working experience with C++ and Qt
  • Choose a mentor who has done this for years, and knows what it takes to create industry-level software

Here’s how the course is structured. Each lecture prepares the groundwork for the next one. You will:

  • write code in C++ (standard ’03)
  • use the Qt toolkit’s UI elements to create the GUI (Graphical User Interface)
  • set up the main application window
  • drag and drop the required user interface elements (buttons, widgets, labels, spinners…) on the main window
  • connect UI elements to UI events (mouse clicks, value changed)
  • write custom event handling code that updates the painted graphic

You need to have a good understanding of OOP (Object Oriented Programming) fundamentals, as you will be adding and working with:

  • class member variables
  • class member functions
  • setters / getters
  • private / public / protected access modifiers
  • encapsulation to protect the data
  • constructors and destructors
  • overriding virtual base class functions for Qt objects
  • pointers to objects

You will organize the C++ program logic into header (.h) and implementation (.cpp) source files.

You will design a simple GUI (Graphical User Interface) with QtCreator (part of the Qt toolkit) and use the signal and slots mechanism to make the buttons (and other UI elements) respond to mouse clicks or value changed events.  

You will setup a custom rendering area widget that integrates flawlessly with the Qt5 framework, by inheriting from the QWidget base class and overriding abstract class methods.  

You wil learn how to fix compiler errors that can occur during development.

You will also learn to fix linker errors caused by missing function implementations.  

You will use a bottom-up approach to develop robust software.  

Notice the key word here – robust.  

That means professional-level C++ code.  

You will learn to design reusable programs with programs will be designed with reusability in mind. And will be written with future upgrade capabilities in mind.  

You will also use Math and Geometry in an unexpected way, to create unusual 2D graphics shapes.  

You will also get some hands-on experience by taking the course assignments.

The assignments are designed to get you comfortable with the code and teach you to extend the application on your own, after you have completed the course.

Should I go on or do you want to start learning now?  

I’ve invested around 10 years into learning software development and have worked 7 years in the IT industry.

Ok, here are a few more things you will get from it:

  • How to create an online repository (with BitBucket)
  • How to use source versioning (with GIT) to save intermediary code changes and revert back to them anytime if you make a mistake  
  • Tips and tricks for good coding practices  

So come on, let’s start creating some 2D graphics with Qt5 And C++ Gui Programming!Who this course is for:

  • You have a solid understanding of C++ syntax
  • You want to learn basic C++ app development with Qt
  • Preferably you are an intermediate developer or programming enthusiast
  • You want to learn how to design and create software from scratch
  • You love software development (especially with C++)
  • You want hands-on coding experience
  • You are a 2D graphics amateur or passionate
Posted in Development, FoodBusiness

Public Speaking: You Can Speak to Large Audiences

Public Speaking: You Can Speak to Large Audiences

Public Speaking – Imagine yourself speaking confidently and authoritatively to hundred or even thousands of people in the audience. Wouldn’t t be great to know you can speak to 1000 people just as easily and as confidently as when you speak to one person?

In this How to Speak to Large Audiences Public Speaking course, you will learn the following:

*How to appear relaxed and confident, even if you shaking on the inside

*How to avoid the common mistakes most people make when they are speaking to a large audience

*How to move around the stage effectively

*How to be clearly understood and remembered

This Public Speaking course is delivered primarily t

hrough spoken lecture. Because the skill you are learning is speaking related, it only makes sense that you learn through speaking.

The Public Speaking skill you will learn in this class is not primarily theoretical or academic. It is a skill that requires physical habits. That is why you will be asked to take part in numerous exercises where you record yourself speaking on video, and then watching yourself. Learning presentation skills is like learning how to ride a bicycle. You simply have to do it numerous times and work past the wobbling and falling off parts until you get it right.

This Public Speaking course contain numerous video lectures plus several bonus books for your training library.

TJ Walker has bhttps://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-8253381108375445&output=html&h=300&slotname=4104667591&adk=3336960072&adf=1363165500&w=360&ebfa=1&lmt=1590991164&rafmt=1&psa=1&guci=2.2.0.0.2.2.0.0&format=360×300&url=https%3A%2F%2Fcoursemania.xyz%2Fcourse.html%3Fid%3D982588&flash=0&fwr=1&fwrattr=true&rpe=1&resp_fmts=3&sfro=1&wgl=1&adsid=ChEI8Nuh9wUQ2_iX0KOLwqDeARIvANFCouv7IN22Z1QS27wZ2k69RSRl3Z-yUsWj4lp-qkAqUB1xQe8g_wir7lOArUI&dt=1592341788376&bpp=7&bdt=5804&idt=7&shv=r20200609&cbv=r20190131&ptt=9&saldr=aa&abxe=1&cookie=ID%3D43bd4ebb70f01db5%3AT%3D1592081475%3AS%3DALNI_MZt3J0-5en-QtSImQDx1OEmR13Hrg&crv=1&prev_fmts=0x0%2C360x300%2C360x300%2C360x300%2C360x300%2C360x300%2C360x300%2C360x300&nras=1&correlator=1427389359866&frm=20&pv=1&ga_vid=912387327.1592081474&ga_sid=1592341784&ga_hid=1070309391&ga_fc=0&iag=0&icsg=3002399751929855&dssz=46&mdo=0&mso=0&u_tz=180&u_his=1&u_java=0&u_h=740&u_w=360&u_ah=740&u_aw=360&u_cd=24&u_nplug=0&u_nmime=0&adx=0&ady=3217&biw=360&bih=612&scr_x=0&scr_y=0&oid=3&psts=AGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw%2CAGkb-H9mMwfR81lOVUiXLuv5hyHlFBgFYtOWGkjZ_VEbo2UgPBrdA8RyvE3ViEdS5KBw&pvsid=4059458150979975&pem=362&ref=android-app%3A%2F%2Forg.telegram.messenger%2F&rx=0&eae=0&fc=1924&brdim=0%2C0%2C0%2C0%2C360%2C0%2C360%2C612%2C360%2C612&vis=1&rsz=%7C%7CeEbr%7C&abl=CS&pfx=0&fu=8336&bc=31&jar=2020-06-14-23&ifi=8&uci=a!8&btvi=7&fsb=1&xpc=jqFfy8QJ7y&p=https%3A//coursemania.xyz&dtd=84een coaching and training people on their Public Speaking skills for 30 years. Now, through the power of Udemy’s online platform, he is able to give you the same high quality training that he gives in person to CEOs, Fortune 500 executives, and Presidents of countries. Only you can now receive the training at a tiny fraction of the normal fee for in-person training.

How long this course takes is up to you. The longest part of the course involves you speaking on video, critiquing yourself, and doing it over until you like it. But if you get to the point where you love how you look and sound when you present it will be well worth the time spent. And having this skill will save you time for all future presentations in your life.

You can begin imp

roving your Public Speaking skills right now. You may have an opportunity to speak out as soon as tomorrow, so why waste another day worried that your presentation skills are not up to high standards. Please enroll today.

“5 Stars! Short sweet and crystal clear instructions this guy is talking out of experience. love it.” Udemy student Youcef(Joe) seyyedi

There is a 100% Money-Back Guarantee for this Public Speaking course. And the instructor also provides an enhanced guarantee.

What others say:

“TJ Walker’s single-minded devotion to presentation has made him the #1 expert for executives seeking guidance on speaking to the public and media.” Bob Bowdon, Anchor/Reporter, Bloomberg Television

Posted in FoodBusiness, Office, office productivity

Zero to Hero in Microsoft Excel: Complete Excel guide 2020

Zero to Hero in Microsoft Excel: Complete Excel guide 2020

6 Reasons why you should choose this Excel course

  1. Carefully designed curriculum teaching you only the most used functionalities of Excel in business environment
  2. Concise – you can complete this course within one weekend
  3. Business related examples and case studies
  4. Ample practice exercises because Excel requires practice
  5. Downloadable resources
  6. 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 Excel, or you’ve played around with it but want to get more comfortable with Excel’s advanced features. Either way, this course will be great f

or you.

Verifiable Certificate of Completion is presented to all students who undertake this 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. We know that your time is important and hence we have created this fast paced 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.

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:

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

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.

What is covered in this course?

This course covers everything you need to crack 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, CONCA
  • TENATE, 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 Excel will soar. You’ll 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