Microsoft Excel 3 Course Bundle – Basic, Intermediate & Advanced Courses-3035530865
Description
The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.
Course Syllabus
Basic Level:
- Introduction to Spreadsheets
- Understanding Microsoft Excel
- Excel Workbook Windows
- Basic Spreadsheet Skills
- Excel Help System
- Opening and Closing Workbooks
- Understanding Workbook File Formats
- Creating New Workbooks
- Selecting Cells
- Auto Sum and Auto Fill Function
- Cell Referencing and Request
- Formatting Cells
- Formatting Numbers
- Placing Cell Alignment
- Cell, Rows and Columns
- Understanding Worksheets
- Editing, Copying and Moving Cells
- Page Layouts in Excel
- Proofing Workbooks
- Basic Options, Ribbons and Toolbar
- Final Assessment
Intermediate Level:
- Introduction to Excel Spreadsheet Intermediate Level
- Defining Names in Excel
- Sorting Data
- Using Excel Tables
- Filtering Data in Excel
- Understand Charts
- Chart Design Options and Tools
- Chart Format Tools
- Combo Charts
- Functions within Excel
- Understanding Date Function
- Information Functions
- Logical Functions
- Financial Functions
- Find and Replace
- Headers and Footers
- Adding Comments
- Conditional Formatting
- Final Assessment
Advanced Level:
- Introduction to Excel Advanced
- Using Text to Columns
- The Paste Special Function
- Data Validation
- Subtotals and Grouping
- Consolidating Data
- Scenario Analysis
- Data Tables in Scenario Analysis
- What-if Analysis
- Mats and Trig Functions
- Text Functions in Excel
- Using Lookup Functions
- Vlookups
- HLookups
- Using Statistical Functions
- Databse Functions
- Formaula Auditing and Error Tracing
- Hyperlinks in Excel
- Linking Data
- Understanding Pivot Tables
- Using Pivot Charts
- Workbook Properties
- Protecting and Sharing Worksheets
- Data Encrypting and Finalising Workbooks
- Understanding to Macros
- Custom Number Formats in Excel
- Using Custom Lists
- Working with Templates
- Tracking Changes in Excel
- Merging and Compare Excel Workbooks
- Final Assessment
- Microsoft Excel Software
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
Assessment
To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Basic, Intermediate & Advanced course, the course features a number of end of module interactive quiz questions.
Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice 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
Microsoft Excel – Intermediate Course -3035530865
Description
Some of the highlights of the intermediate Excel course include the following:
- Learning more about intermediate Excel functions including ABS, 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
- How to use Templates
- Insert Charts
- Adding custom backgrounds
- How to use Tables
- How to auto fill data
- Adding special characters
- Changing border colour and theme
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
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel - Advanced-3035530865
Description
Course Syllabus includes 24 intermediate/advanced level lessons
- Essential Formula Knowledge - Understand the most common and essential formula categories in Excel and how to use them.
- Understanding Dates - Understand how dates work in Excel using the TODAY, YEAR, MONTH, DAY and DATE functions.
- Understanding Time - Understand how time works in Excel, and how to change from whole numbers into time increments and back again.
- · Intermediate Formula Knowledge - Learn more advanced formulas and gain a deeper understanding of how Excel formulas work.
- Formula Auditing - Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.
- Temporal Functions - Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another.
- VLOOKUP with Approximate Match - Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column.
- VLOOKUP with Exact Match - Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.
- Other Lookup Methods - Learn to work with INDEX, MATCH and HLOOKUP, as alternatives to the VLOOKUP function.
- · Optimizing Data - Get your data into a usable form and unleash Excel's most powerful tools with it.
- Naming Ranges - Learn about creating named ranges, and the benefits of doing so.
- Excel Tables - Learn about creating Excel tables, and their advantages.
- Recording Macros - Learn to record basic Excel macros to automate your actions (instead of doing them manually).
- · Data Analysis - Analyze, summarize and highlight data quickly and easily using Excel's PivotTables.
- Creating PivotTables - Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).
- Formatting PivotTables - Learn to control formatting and other options in PivotTables.
- Calculated Fields in PivotTables - Learn to create and modify basic calculated fields for PivotTables.
- What-If Analysis - Learn to perform what-if analysis in Excel using the Scenario Manager and Goal-Seek.
- · Presenting and Reporting - Interpret your data and turn it into information using Excel's advanced formatting tools.
- Outlining - Learn about adding and working with Excel’s outlining tools to quickly hide irrelevant sections of your worksheet.
- Custom Number Formats - Learn to build your own custom number formats to display dates, values and variances how you want to see them.
- Conditional Formats with Built-In Rules - Learn to create top/bottom and highlight cell rules, as well as to apply icon sets and data bars.
- Conditional Formats with Custom Rules - Learn to create custom conditional formatting rules based on formulas.
- Building Combination Line and Area Charts - When you want to graph 3 line series, but only want 2 in focus most of the time.
- · Validating and Updating - Increase the integrity and longevity of your spreadsheet so that the right data is entered and can be easily updated.
- Data Validation - Learn how to use Data Validation to ensure that users enter valid data in input cells.
- Styles - Learn how to apply built-in number styles and create your own custom styles packages.
- Preparing to Deploy - Set up Excel's aesthetics, including preparing to print, and protect your spreadsheet's key components.
- Custom Views - Learn how to create and manage Custom Views in a worksheet.
- Page Setup Options - Learn about page setup options, fitting print jobs on a page, headers and footers, and other ways to customize print jobs.
- Security Considerations - Learn about the setup and weaknesses of Excel’s security systems.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel 2007 Intermediate-3035530865
Description
Learning Outcomes
- Learn how to summarise data and correct errors in calculation
- Learn formatting and calculation
- Learn how to customise appearance of charts
- Learn how to print charts separately from worksheets
- Learn how to create an outline, showcase different groups of data
Course Titles
- Module 01: Using Multiple Worksheets and Workbooks
- Module 02: Advanced Formatting
- Module 03: Outlining and Subtotals
- Module 04: Cell and Range Names
- Module 05: Lists and Tables
- Module 06: Web and Internet Features
- Module 07: Advanced Charting
- Module 08: Documenting and Auditing
- Module 09: Templates and Settings
Access Duration
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.
Method of Assessment
At the end of the Microsoft Excel 2007 Intermediate course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.
Certification
Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2007 Intermediate.
Awarding Body
The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.
Whatsapp: +923035530865, 03219606785, 3315145601,
03495021336 IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
No comments:
Post a Comment