Advance Excel Professional Training in Lahore
Accountech is proud to announce professional Advance Excel Training in Lahore with up to date assignments on Microsoft Excel 2016.
Accountech is the best training institute offering Advance Excel Training in Lahore providing quality training which is equally beneficial for new entrants in the job market as well as professionals and corporate leaders. Our trainers have great command over various formulas and functions of Advance Excel Training in Lahore.
Why Advance Excel Training is important ?
As we all know that Microsoft Excel is most widely used spread sheet and data processing software around the world in office environment, homes, businesses and in every scenario where you need dashboard reporting, data analysis, complex calculations and automation. At Accountech you will learn the art of making your excel sheets fully automated with minimum effort and maximum efficiency.
Contact: 0331-8433334
Advanced Excel
CELL REFERENCING
- Relative cell referencing within in formulas
- Absolute cell referencing within formulas
- Usage of Cell references
- How Implement the cell references
NAMING RANGES
- Defining a Range Name
- Using a Range Name in a Formula
- Moving to a Named Range
- SUM,AVERAGE,MIN,MAX
- LARGE,SMALL,
- COUNT,COUNTA,COUNTBLANK
- COUNTIF ,COUNTIFS
- SUMIF,SUMIFS,AVERAGEIF,AVERAGEIFS
- IF ,NESTED IF, IF USING LOGICAL OPERATOR LIKE AND ,OR
- SUBTOTAL
- Consolidation the excel sheets,workbooks using formulas
- Date Functions TODAY,WEEKDAY,YEARFRAC,NOW,NETWORKDAYS,DAYS360
- Text formulas
- PROPER,UPPER, LOWER, CONCATENATE, LEFT, RIGHT,
- MID,LEN,REPT,TRIM,SUBSTITUTE,LEN,ISTEXT,EXACT
- Using the Office Clipboard
- Using Paste Special
- Using Paste Special with content from Excel
EXCEL FUNCTIONS
Practical Assignments
COPYING DATA
- Using Paste Special with content from other application
CONDITIONAL FORMATTING
- Using conditional formatting
- Changing conditional formatting
- Deleting conditional formatting
- Condition formatting using formulas
USING AUTOFILTERS
- Filtering data
- Filtering data with AutoFilter
- Specifying a conditional filter with AutoFilter
- Using the Top 10 AutoFilter
- Removing all AutoFilters
USING ADVANCED FILTERS
- Using Advance Filters
- Filtering the records using specified criteria
WORKING WITH FILTERED DATA
- Manipulating Filtered Data
- Totaling fields within a filtered database list
- Creating Subtotals
- Remove Subtotals
CHARTING IN EXCEL
- Charts Refresher
- Moving, Sizing & Copying Charts
- Formatting Charts
- Formatting a Series
- Exploring the Home & Format Ribbons
- Deciding What Chart Format to Use
- Show a Time Series with Column or Line Charts
- Using Combination Charts
- Using Line Chart Accessories
- Using Bar Charts to Show Comparisons
- Using Component Charts
- Using Correlation Charts
- Exploring Other Charts
- Chart Lies Revealed & Advanced Chart Types
- Creating a Custom Layout
EMBEDDING AND LINKING OBJECTS
- Embedding data
- Embedding an existing document
- Linking data
- Creating a link to an existing file
- Linking data from Microsoft application
USING HYPERLINKS
- Using Hyperlinks
- Creating a Hyperlink
REFRESHING DATA
- Refreshing external data without losing the formatting
- Refreshing external data automatically
Practical Assignments
ADVANCED EXCEL FORMULAS
- Array formulas
- LOOKUP,HLOOKUP,VLOOKUP,INDEX,MATCH
- ISERROR ,IFERROR
- Nested functions
Practical Assignments
USING DATA VALIDATION
- Setting data validation
- Creating the Input Message
- Displaying an Input Message
- Creating the Error Alert
- Displaying an Error Alert
- Validation using formulas
AUDITING
- Tracing precedent cells
- Tracing the dependants of a cell
- Displaying all formulas within a worksheet
- Adding comments
- Displaying comments
- Removing comments
- Editing comments
LINKING DATA
- Linking individual cells within a worksheet
- Linking charts to data within a worksheet
- Linking a cell range on one worksheet to another worksheet (within the same workbook)
- Linking data on one worksheet to a chart in another worksheet (within the same workbook)
- Linking data from one workbook to another
- Linking a chart from one workbook to another
- Copying data from Excel into a Word document
- Linking data from Excel into a Word document
- Copying a chart from Excel into a Word document
- Linking a chart from Excel into a Word document
WORKING WITH PIVOT TABLES
- Creating a Pivot Table
- Rearranging Fields in a Pivot Table
- Explaining the Report Layout Options
- Using the Report Filters Feature
- Using Top 10 & Date Filters
- Handling Blank Cells
- Drilling Down in the Pivot Table
- Sorting a Pivot Table
- Formatting a Pivot Table
- Creating Custom Formats
- Explaining the Grouping Options
- Adding Formulas to a Pivot Table
- Changing a Calculation in a Pivot Table
- Replicating a Pivot Table
- Counting with a Pivot Table
- Using Pivot Charts
PROTECTION AND SECURITY
- Specifying a password for opening a workbook
- Using the "read-only recommended" option
- Protecting a worksheet or worksheet elements
- llowing selective editing of a protected worksheet
MACROS
- Displaying the Developer tab
- Recording and running macros
- owering your macro security level
- Customizing the Quick Access Toolbar
- Changing the Quick Toolbar Macro icon
- Removing a macro icon from the quick access toolbar
- Raising your macro security level
Our Most Popular Courses:
Advance Excel Training in Lahore
QuickBooks Training in Lahore
PeachTree Training in Lahore
Tally ERP Training in Lahore
Xero Accounting Training in Lahore
Sage 50 training in Lahore
Myob Training in Lahore
Business Modeling Training in Lahore
Financial Modeling Training in Lahore
Advance Excel VBA Training in Lahore
Oracle training in Lahore
MS Office Training in Lahore
Note: Special discount offer for students of B.com & M.com, so get registered now to avail this golden opportunity.
Call us or visit our office to get registered!
Contact us now for a free consultation or visit our office.
Facebook: Accountech Training & Solutions
Website: Accountech Training & Solutions
Mobile: 0331-8433334
Address: 182, Sector Y DHA Phase 3, Lahore.
0 Comments