Microsoft Excel Advanced with Certificate - Onsite/In-Company-3035530865
Description
Course
Content
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic
1A: Use 3-D References
Topic
1B: Use Links and External References
Topic
1C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic
2A: Collaborate on a Workbook
Topic
2B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic
3A: Apply Data Validation
Topic
3B: Work with Forms and Controls
Topic
3C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic
4A: Use Lookup Functions
Topic 4B:
Combine Functions
Topic
4C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic
5A: Trace Cells
Topic
5B: Search for Invalid Data and Formulas with Errors
Topic
5C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic
6A: Determine Potential Outcomes Using Data Tables
Topic
6B: Determine Potential Outcomes Using Scenarios
Topic
6C: Use the Goal Seek Feature
Topic
6D: Activate and Use the Solver Tool
Topic
6E: Analyse Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Topic
7A: Use Advanced Chart Features
Topic
7B: Create Sparklines
Course
Objectives
Upon successful completion of this course, students will
be able to:
- Work with multiple worksheets and workbooks simultaneously.
- Share and protect workbooks.
- Automate workbook functionality.
- Apply conditional logic.
- Audit worksheets.
- Use automated analysis tools.
- Present your data visually.
Who is this course for?
This course was designed for students desiring to gain
the skills necessary to create macros, collaborate with others, audit and
analyze worksheet data, incorporate multiple data sources, and import and
export data.
Requirements
Before taking this course, students are recommended to
take the following courses, or have equivalent knowledge:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
Career path
Being proficient in Excel can open the door to many
career opportunities such as:
- Administrative Assistant
- Data Analyst
- Accountants
- Financial Analyst
- Retail Store Manager
- Project Manager
- Business Analyst
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Excel PivotTable-3035530865
Description
Pivot Table Fundamentals
What
is a Pivot Table?
When and why use a Pivot Table?
Anatomy of a Pivot Table
Limitations of Pivot Tables
When and why use a Pivot Table?
Anatomy of a Pivot Table
Limitations of Pivot Tables
Creating Basic Pivot Tables
Preparing
your data
· Tabular Layout
· Removing Section Headings
· Removing Repeated Column Groups
· Eliminating Gaps
· Type Formatting
Creating Pivot Tables
· Adding Fields
· Adding Layers
· Altering Structure
· Report Filters
Managing Changes in Your Source Data
· Dynamic Named Ranges
· Dealing with Zeroes
Subtotals
Summary Calculations
· Running totals
· Differences (year on year, month on month)
· Percentages of Rows, Columns, Totals and other fields
Running Totals and Top 10 reports
Pivot Table Tools
· Layout Updates
· Refreshing & Restarting
· Moving Pivot Tables
· Tabular Layout
· Removing Section Headings
· Removing Repeated Column Groups
· Eliminating Gaps
· Type Formatting
Creating Pivot Tables
· Adding Fields
· Adding Layers
· Altering Structure
· Report Filters
Managing Changes in Your Source Data
· Dynamic Named Ranges
· Dealing with Zeroes
Subtotals
Summary Calculations
· Running totals
· Differences (year on year, month on month)
· Percentages of Rows, Columns, Totals and other fields
Running Totals and Top 10 reports
Pivot Table Tools
· Layout Updates
· Refreshing & Restarting
· Moving Pivot Tables
Pivot Table Views
Conditional
formatting
Sorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views
Sorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views
Pivot Table Calculations
Calculated
Fields and Items
Managing & maintaining Pivot Table calculations
Managing & maintaining Pivot Table calculations
Pivot Charts
What
is a Pivot Chart?
Creating a Pivot Chart
Pivot Chart Rules
· Managing the underlying data
· Adding Layers
· Altering Structure
Pivot Chart Alternatives
· Dynamic Charts
· Transition tables
Creating a Pivot Chart
Pivot Chart Rules
· Managing the underlying data
· Adding Layers
· Altering Structure
Pivot Chart Alternatives
· Dynamic Charts
· Transition tables
Working with Data Sources
Consolidating
multiple sheets or ranges of data
Using external data sources (Access)
Using external data sources (Access)
Automating Pivot Tables with Macros
Introducing
Macros
Recording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)
Recording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel Introduction-3035530865
Description
This course
contains the following modules:
Getting Started with Microsoft Excel
- Starting Out
- About Workbooks
- Exploring your Workbook
- Getting Help with Excel
The Excel Interface
- The Quick Access Toolbar and File Menu
- The Home Tab
- The Insert Tab
- The Page Layout Tab
- The Formulas Tab
- The Data Tab
- The Review Tab
Microsoft Excel Basics
- Working with Excel
- Basic Excel Features
- Moving your Data
- Smart Tags and Options Buttons
- Editing Tools
Editing your Workbook
- Enhancing a Worksheets Appearance
- Cell Formatting
- Conditional Formatting
Printing and Viewing your Workbook
- Using the View Tab
- Managing a Single Window
- Managing Multiple Windows
- Printing your Workbook
- Print Page Layout options
Working with Charts in Excel
- Using Recommended and Standard Charts
- Chart Elements
- Chart Tools - Design & Format
'
Getting Started with Microsoft Excel
- Starting Out
- About Workbooks
- Exploring your Workbook
- Getting Help with Excel
The Excel Interface
- The Quick Access Toolbar and File Menu
- The Home Tab
- The Insert Tab
- The Page Layout Tab
- The Formulas Tab
- The Data Tab
- The Review Tab
Microsoft Excel Basics
- Working with Excel
- Basic Excel Features
- Moving your Data
- Smart Tags and Options Buttons
- Editing Tools
Editing your Workbook
- Enhancing a Worksheets Appearance
- Cell Formatting
- Conditional Formatting
Printing and Viewing your Workbook
- Using the View Tab
- Managing a Single Window
- Managing Multiple Windows
- Printing your Workbook
- Print Page Layout options
Working with Charts in Excel
- Using Recommended and Standard Charts
- Chart Elements
- Chart Tools - Design & Format
'
Who is this course for?
The course is intended for new users of Microsoft Excel
2007, 2010, 2013 or 2016 who want to become productive in the shortest possible
time. Delegates should be proficient in using a PC with the Microsoft Windows
operating system, but no prior experience with Excel is required.
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel - Macros and VBA-3035530865
Overview
Learn to automate your most repetitive tasks at the push
of a button with Microsoft Excel Macros and VBA. In this online course, you
will learn to create powerful Excel Macros using VBA (Visual Basic for
Applications) to really make Excel work for you. With no prior programming
experience required, you'll have your daily spreadsheets running like clockwork
to save you hours of time and boost your productivity.
Description
- Understand the differences between Excel Macros and
VBA.
- Run your macro from the Macro dialog, a keyboard
shortcut or worksheet button.
- Understand the syntax and structure that make up a
valid Excel macro.
- How VBA Objects and the Objects model relate to each
other.
- Using step vs run in entry level debugging.
- How to create variables and assign strings, values or
objects.
- Implementing logic tests in VBA.
- Set up looping with Do loops and Do While loops.
- Create a VBA Message Boxes.
- Set up an error trap in VBA to handle errors.
- Create a User Defined Function (UDF).
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Advanced Microsoft Data
Analysis Toolkit-3035530865
The courses this bundle will cover:
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!
Advanced Microsoft Access:
- How to effectively link to other
data sources.
- How to split a database by splitting
the frontend and backend.
- To create and maintain macros.
- The use of Visual Basic for
Applications (VBA).
- Advanced options for the use of
forms.
- Packaging your application for
distribution.
Advanced Microsoft VBA:
- Advanced methods for automating tedious
Excel jobs.
- How to write and implement Excel
events.
- How to modify a variety of
standard behaviours, such as double-clicking, opening files and saving
files.
- How to design and implement
specialised classes of objects.
- How to customise the right-click
menu within cell ranges.
- External libraries, and how you
can extend VBA’s capabilities beyond standard Excel options.
- How to modify the Excel user
interface, including the “Ribbon” and context menus to interact with your
VBA code
Microsoft Power BI:
- How to use the Query Editor to
transform and morph data into the right format for your reporting
purposes.
- How to perform complex data
modelling operations using relationships, calculated columns, measures,
and DAX expressions.
- How to share dashboards and reports,
with colleagues, business partners and potential clients.
- How to use Power BI’s
sophisticated security features to control the exact content your audience
can view.
- How to use Power BI Desktop,
Service and Mobile Apps
- How to connect with a variety of
data sources
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel for Accountants Diploma Certification-3035530865
Description
Benefits
of studying the Microsoft Excel Course
There
are various advantages for those who work towards earning a Microsoft Excel
certificate online.
These include some of the following:
- Build
great charts. Excel allows business users to unlock the potential of their
data, by using formulas across a grid of cells
- Use
conditional formatting
- Help
identify trends
- Bring
data together
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
No comments:
Post a Comment