Legal Secretary and Office Skills Diploma - SPTTC Accredited-3035530865
Description
The Legal Secretary and Office Skills Diploma is taught through accessible, informative video lessons, online study materials, mock exams and automated assessments. You gain an overall understanding of what legal secretary and paralegal roles entail, along with developing specific skills in verbal and nonverbal communication, preparing legal documents and proofreading, along with broader transferable office administration skills in time management and the use of Microsoft Word.
Course Design
This course is designed with the following modules:
Legal Secretary
- Introduction to Legal Secretary
- Role of Legal Secretaries
- General Duties and Day-to-Day Operations of a Legal Secretary
- Record Keeping
- Legal Writing Skills & Proofreading
- Research Skills You Need to Know
- Transcription, Editing & Correspondence to Judges
- Legal System of UK
- UK Court System
Meeting Management & Minute Taking
- Meeting Management
- The Role of a Minute-Taker
- The Skills of a Minute-Taker
- Meeting Agreements
- Minute Styles
- What Do I Record?
- Techniques for Preparing Minutes
- Taking Minutes in an Interactive Meeting
- The Minute Book
- What to include/what to ignore
- Motions and Resolutions
- Method of recording minutes
- Reasons for Meeting
- What is a decision?
- Minute Taking tips
Other Secretarial Roles and Responsibilities
- Working with Your Manager
- Administrative Soft Skills
- Effective Time Management
- Tools of the Trade
- Being an Effective Gatekeeper
- Organizational Skills
- Confidentiality Guidelines
- Special Tasks
Customer Service Role
- The Power of Positive Thinking in Customer Service
- Types of Difficult Customers and How to Help them
- How to Deal with Difficult Customers
Telephone Etiquette
- Aspects of Phone Etiquette
- Using Proper Phone Language
- Eliminate Phone Distractions
- Inbound Calls
- Outbound Calls
- Handling Rude or Angry Callers
- Handling Interoffice Calls
- Methods of Training Employees
- Correcting Poor Telephone Etiquette
Organizing Work Using MS Word
- Opening
- Working with the Interface
- Your First Document
- Basic Editing Tasks
- Basic Formatting Tasks
- Formatting Paragraphs
- Advanced Formatting Tasks
- Working with Styles
- Formatting the Page
- Sharing Your Document
Proof Reading
- What does a Proofreader do?
- Proofreading
- Proofreading Symbols
- Proofreading on Paper & Screen
- Strategies to Check for Specific Errors
- Editing & Proofreading Strategies
- Proofreading an Essay
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Legal Secretary Diploma Distance Learning Course-3035530865
introduction: General Legal Secretary Procedures & Legal Terminology
Unit 1: English Legal System
Unit 2: Law of Contract & Law of Tort
Unit 3: Civil Litigation Practice
Unit 4: Land Law & Conveyancing Practice
Unit 5: Wills, Probate & Administration Practice
Unit 6: Family Law & Practice
Additional Benefits: Guidance to Secure Employment and a Tour of the Royal Courts of Justice in London. Plus a years free membership to The Institute of Legal Secretaries and PAs when you enrol.
Description
This online Legal Secretary Training course has been designed for 25 guided learning hours. Following course outline will provide you the idea about main topics areas are covered in this training course. The numbers of sub topics are covered under following each main topic:
Course Content (Course Outline):
Unit 01: Understanding the Legal Systems
- English Legal System
- Difference between civil law and criminal law UK
- Court system and structure in UK
- How laws are made
Unit 02: Developing General Secretarial Skills
- Answering telephone calls in a professional manner
- Dealing with enquiries from clients via email, fax and letter
- Using a diary management system and making appointments
- Keeping records of costs and controlling petty cash
- Delivering and collecting documents
- Keeping Records and Filing
Unit 03: Developing Legal Secretarial Skills
- Production of letters and legal documents such as wills, contracts and court papers
- Working from notes and digital dictation
- Preparing court forms and statements
- Importance of proof reading
- Dealing with fee processes
- Attending court or police cells with solicitors
Method of Assessment:
At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Best Selling - Ultimate Microsoft Excel Bootcamp-3035530865
The courses this bundle will cover:
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!
Microsoft PivotTable:
- The primary uses of pivot tables
- How to identify the best and worst data sets
- To filter, sort and group PivotTable™ data to maximise its usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
Business Analysis:
- How to turn buckets of data into sound business decisions
- Financial modelling theory
- Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
- How to effectively and clearly present your findings to relevant stakeholders
- Different forecasting techniques, including Moving Averages and Regression
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.
Who is this course for?
Beginner to Advanced levels of Excel User
Requirements
Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2013 PC, 2016 PC, 2019 PC, 2011 MAC, 2016 MAC
Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC
PivotTable is available in versions: 2007 PC, 2010 PC, 2013 PC
Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC
PivotTable is available in versions: 2007 PC, 2010 PC, 2013 PC
Career path
Microsoft Excel is an essential business tool used by organisations of all sizes across the globe. Our courses have taught individuals from an array of industries, learning experience and seniority – from IT professionals, marketing managers, accountants, teaching assistants, project managers, HR, nurses / healthcare workers, university students, financial analysts and many other professions.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Advanced Microsoft Excel Course (SPTTC Accredited) -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 Advanced Excel course. It’s split into five clear sections to get the results you want right away. Your teacher is Simon Hurst, an Excel expert and trainer for 20+ years; whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration.
What you get with this Advanced Excel course:
- 120+ modules of training, covering the most business-relevant areas of Microsoft Excel.
- 90+ videos and over 50 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.
In this course you will learn:
- 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.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
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
Microsoft Excel – Beginner Course-3035530865
Description
Introduction to the Microsoft Excel for Beginners Course
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. This course is ideal for anyone who has never used Excel or for those who have only a rudimentary understanding of the software.
It is also perfect for anyone who is familiar with the older versions of the software, but not the latest version. If you are re-entering the workforce, you will also find that this course will suit you well, and will certainly get you caught up with the rest of your peers.
The course begins with explaining concepts, such as ‘What is a cell?’ and how to tell the difference between a column and a row. The course continues by explaining basic Excel concepts such as how to create, copy, delete, and cut information from Excel cells. You will also learn how to edit information that is put into a cell and how to insert and edit comments when using Excel.
The second half of the beginner’s Excel overview, which is only a small part of the beginner’s course, will cover sheets, which is an entirely different concept than cells. In this section, you will learn how to rename a sheet, delete a sheet, hide and unhide a sheet, and move and copy a sheet. You will also learn how to change the colour of tabs.
After mastering the beginner’s overview, the rest of the beginner’s course will go further into these concepts, and then teach details on how to perform basic functions.
Each video in the course shows where one can learn more about the concept covered in the course, as well as the difficulty level of the concept. There is also a full explanation of the concept and the instructor of the course visually takes students through each concept step by step on the screen. If you have questions about the concept, the instructor also offers a message board, or you can download a list of the most common questions asked about Excel.
When you finish this course, you will have a basic understanding of how to use many of the functions of Excel, and can use the program with ease. You will then be fully prepared to move ahead to the intermediate course.
What you will learn
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 the dictionary
- Using hyperlinks
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
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel Online Course for Beginners--3035530865
What you get with this Microsoft Excel course:
- 22 modules of training (full syllabus below), covering the most business-relevant areas of Microsoft Excel.
- Taught via video, downloadable practice exercises and mini tests.
- You’ll have a basic understanding of Microsoft Excel after taking this course.
In this course you’ll learn:
- Data entry
- Text and number formats
- Basic mathematical functions (SUM, AVERAGE)
- Editing skills, including Flash Fill
- Basic data analysis skills through sorting and filtering.
- Printing spreadsheets
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?
Perfect for beginners through to those with intermediate levels of experience and anyone looking to brush up on their core Excel skills. This course is proven to save you time in the workplace and optimise your workflow across essential day to day Microsoft Excel tasks.
Requirements
Version: Excel 2013 used in examples but applicable to all PC Excel versions
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Excel For Accountants (Basic)-3035530865
In this course you’ll learn:
- Worksheet organisation and navigation tips
- Understanding Number and Date Formatting
- Conditional Formatting
- Constructing Formulas using Basic Functions
- The Importance of Absolute Cell References
- Sorting and Filtering Data
- Looking beyond simple Paste
- The advantages of naming Ranges
- Manipulating data with Text Functions
- The magic of Flash Fill
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?
The Excel for Accountants (Basic) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accountants, bookkeepers and accounting professionals and aims to provide learners with a solid foundation with which to build further skills.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
No comments:
Post a Comment