Monday, January 6, 2020

Excel For Accountants (Intermediate) -3035530865

In this course you’ll learn:
  • Perform calculations using Time and Date functions
  • Lookup information using HLOOKUP and VLOOKUP
  • Perform more complex lookups using INDEX and MATCH
  • Make decisions with IF Statements
  • Incorporate logical operators into formulas
  • Create a Loan Amortization table using the PMT function
  • Clean and prepare raw data
  • Create PivotTables and PivotCharts
  • Analyse large datasets using Power Pivot
  • Use Goal Seek, Data Tables and Scenarios to analyse data
  • Automate common tasks using Macros
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel PivotTable Course-3035530865

Sample content: More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

Business, Data and Financial analysts that want to crunch data from any source, quickly and easily. Excel users that want to supercharge their data analysis skills.

Requirements

Microsoft Excel 2007/10 or 2013

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

Microsoft Excel - Beginner & Advanced Bundle-3035530865

Description

Why Excel Matters:
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
What you get with this Microsoft Excel duo:
  • 280 modules of training, covering the most business-relevant areas of Microsoft Excel.
  • 190+ videos and over 130 downloadable exercises.
  • Tailored learning. If you have some Excel knowledge, you can use the filter to show only what you most need to learn.
  • You’ll be an advanced level user after taking this Microsoft Excel course.
What you will learn in these courses:
Microsoft Excel:
  • How Excel works, how to navigate and design a spreadsheet
  • The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
  • To use PivotTables, Pivot Charts and Basic Macros
  • To create beautiful looking graphs and charts
  • Formatting, including; conditional, cell and number formatting
  • How to print what you want
Advanced Microsoft Excel:
  • Use advanced graphs in minutes instead of wasting hours trying to figure them out
  • Increase interactivity by automating your spreadsheets with macros and VBA
  • Solve complex problems with superpower functions
  • Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
  • And more!
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.
About the author:
Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Data Analysis In Excel-3035530865

Description

In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.
What you get with this Data Analysis in Excel course:
  • 15 brand new demo videos with professional voiceovers
  • 11 modules with text, that is relevant and easy to understand
  • 10 downloadable exercises
  • Quiz questions in every module
  • Specific objectives and condensed accelerators
In this course you’ll learn:
  • Clean up data ready for analysis
  • Create PivotTables and PivotCharts
  • Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
  • Make decisions using IF Statements
  • Highlight information using Conditional Formatting and Rules
  • Build a basic Interactive Dashboard
More about us:
  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

 

Microsoft Excel Complete Course - Beginner, Intermediate & Advanced- SPTTC-3035530865

Description

MS Excel Beginners Course
The MS Excel beginners course will give you a full overview of all of the most common features of Excel and how to use them.
Some of the highlights of this course include:
  • A basic overview of Excel
  • Calculating sums, averages, and totals
  • Counting cells
  • Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
  • Pivot tables
  • Inserting, editing, and deleting comments
  • Creating borders
  • Wrapping text
  • Merging cells
  • Pasting, sorting, and converting columns to rows
  • Creating graphs and charts
  • Using hyperlinks
This beginners course is recommended for anyone who might use Excel at home or at work for uncomplicated reasons, such as tracking simple expenditures or for calculating sums or totals.
MS Excel Intermediate Course
The MS Excel Intermediate Course will take what you learnt in the beginners course and expand upon it. Additionally, this course will teach you more advanced concepts than those that were presented in the beginners course.
Some of the highlights of the intermediate Excel course include the following:
  • Learning more about intermediate Excel functions including ABS, SUMIF, HLOOKUP, VLOOKUP, COUNTIF, AVERAGEIF, AVERAGEIFS, and AVERAGEA
  • Data validation with date, list, time, and numbers
  • Functions such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
  • How to remove duplicates in Excel
  • Creating random numbers
  • Changing text case
  • Adding passwords
  • Sending emails from Excel
  • Adding custom backgrounds
  • How to auto fill data
  • Adding special characters
  • Changing border colour and theme
Before jumping into the MS Excel Intermediate course, one should have a good basic overview of the beginner Excel functions. Those with experience in Excel might feel as if they can skip the beginner course, but it is best to at least go through the course and review it before starting the intermediate curriculum.
The curriculum in the intermediate course is designed for those who work with Excel in the workplace, and it is primarily for those who want to improve their skills with this program.
MS Excel Advanced Course
The MS Excel Advanced Course is the longest and the most intense of the three Excel courses presented here. However, if you have successfully passed the beginner and the intermediate courses, you should consider yourself fully prepared to begin the advanced course.
Some of the concepts that you will learn in the MS Excel Advance Course include the following:
  • VLOOKUP Advanced formula options and manipulations
  • Other advanced functions including OR, AND, CHOOSE, INDIRECT, REPLACE, LEN,      LEFT, FIND
  • Functions including CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE
  • Colouring a column and row with a formula
  • Highlighting a cell with a formula
  • Functions including ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK
  • Functions including DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM
  • Calculating loan IPMT and EMI
  • Functions including DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX
  • Full explanation of the INDEX and MATCH functions, covering several modules
  • Looking up data
  • Selecting only cells containing comments
  • Hiding formulas
As you can see, the information you will get from the MS Excel Advanced Course will fully prepare you for virtually any career path, including those that require advanced skills with this software. Though this course is the longest and most involved of the three, once you complete it, you will have the knowledge and skills that most can only dream of.

Beginners Course Modules/Lessons
Module 1: Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : Average
Module 14 : AVERAGEIF
Module 15: SUMIF Formula
Module 16: IF Formula
Module 17: VLOOKUP
Module 18: HLOOKUP
Module 19 : Countif Formula
Module 20 : CountBlank
Module 21 : Counta Formula
Module 22 : Count Formula
Module 23 : Concatenate
Module 24 : Transpose
Module 25: Date Formula
Module 26: Month Formula
Module 27: Pivot Tables
Module 28: Pie Charts
Module 29: Doughnut Charts
Module 30: Line Charts
Module 31: Column Charts
Module 32: Bar Charts
Module 33: Number Formatting
Module 34: Create Borders
Module 35: Conditional Formatting
Module 36: Comments FAQ's
Intermediate Course Modules/Lessons
Module 1: SumProduct Formula
Module 2 : Data Validation With Date
Module 3 : Data Validation with Whole Numbers
Module 4 : Data Validation with List Feature
Module 5 : ABS Function
Module 6 : CHAR Function
Module 7 : CLEAN Function
Module 8 : CODE Function
Module 9 : EXACT Function
Module 10 : AVERAGEA Function
Module 11 : AVERAGEIF
Module 12 : AVERAGEIFS Function
Module 13 : CELL Function With 10 Variations
Module 14 : LARGE Function
Module 15: MAX Function
Module 16: MEDIAN Function
Module 17: MIN Function
Module 18: MODE Function
Module 19 : N Function
Module 20 : RANDBETWEEN Function (Insert Random Numbers)
Module 21 : RANK Function
Module 22 : Remove Duplicate Values
Module 23 : ROUND Function Up/Down
Module 24 : Add Custom Background Image
Module 25: Change Text To Lower Case
Module 26: Change Text To Upper Case
Module 27: Change Text To Proper Case
Module 28: Insert Special Character
Module 29: Use Autofill : A Time Saving Trick
Module 30: Treemap Chart
Module 31: Sunburst Chart
Module 32: Use Tables
Module 33: Use Templates
Module 34: Use Themes
Advanced Course Modules/Lessons
Module 1: Add a Password
Module 2 : AND Function
Module 3 : Auto Updating Drop-down Lists
Module 4 : CEILING Formula
Module 5 : Charts that Update Automatically
Module 6 : CHOOSE Formula
Module 7 : Compare 2 Lists with VLOOKUP Function
Module 8 : CORREL Function
Module 9 : Create an Advanced Calculator
Module 10 : Create a Combo Chart
Module 11 : Create a Custom Tab
Module 12 : Create a Pivot Chart
Module 13 : Create Visual In-cell Indicators
Module 14 : Create Visual In-cell Indicators with Icon Sets
Module 15: Customise the Status Bar
Module 16: DATEDIF Function
Module 17: DATEVALUE Function
Module 18: DAVERAGE Function
Module 19 : DCOUNT Function
Module 20 : DCOUNTA Function
Module 21 : Depreciation Formula
Module 22 : DGET Function
Module 23 : DMAX Function
Module 24 : DPRODUCT
Module 25: DSUM Function
Module 26: EDATE Function
Module 27: EOMONTH Function
Module 28: Find and Replace
Module 29: FIND Function
Module 30: INDEX Function
Module 31: Index and Match Formula
Module 32: Indirect Formula
Module 33: Insert Serial Number Automatically
Module 34: IPMT Formula
Module 35: Isblank Formula
Module 36: Iserr Formula
Module 37: Islogial Formula
Module 38: Isnon Text Formula
Module 39: IsNumber Formula
Module 40: Isodd Formula
Module 41: Isolate First Name
Module 42: ISTEXT Formula
Module 43: Left Formula
Module 44: Len Formula
Module 45: Match Formula
Module 46: Vlookup Multiple Results at Once
Module 47: OR Formula
Module 48: PMT Formula
Module 49: Replace Formula
Module 50: Select all Cells with Comments
Module 51: Sparkline Charts in Excel
Module 52: Straight Line Depreciation
Module 53: Strikethrough
Module 54: Sum of Years Depreciation
Module 55: Timeline in Pivot Table
Module 56: Vlookup with 2 Criteria
Module 57: Vlookup with DropDown List
Module 58: Vlookup with Max
Module 59: Vlookup with Min
Module 60: Watch Window In Excel


Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad

No comments:

Post a Comment