1. Home
  2. Course
  3. Power Functions in Excel

Power Functions in Excel

  

About this Course

Target Audience: Course designed for business analysts, finance and accounting audiences, management, and general audiences. Pre-requisite: Preferably with Ex02-200 Course Outline • Fundamentals ? What is Microsoft Office Excel 2010 ? What’s New in Excel 2010? ? Opening Excel ? Interacting with Excel ? Closing Excel • Creating a New Workbook ? Opening a Workbook ? Saving a Workbook ? About Excel File Types ? Closing a Workbook ? Using Worksheets ? The Active Cell ? Selecting Cells ? Exploring a Worksheet ? Using Zoom ? Opening Help ? Using the Help Screen ? The Help Toolbar ? Searching for Help • Finding your data ? Using Find and Replace ? What Is an AutoFilter ? Creating a Custom AutoFilter ? Using an Advanced Filter ? Using an Advanced Filter with Logical Statements ? Copying Filtered Records ? Filtering with Wildcard Characters ? Using Automatic Outlining ? Displaying and Collapsing Levels ? Grouping Data Manually ? Creating Subtotals • Working with PivotTable Data ? Expanding and Collapsing Data ? Filtering Data ? Sorting Data ? Grouping Data ? Refreshing Data ? Editing the Data Source • Formatting a Pivot Table ? Modifying Fields and Labels ? Modifying Values ? Using the Layout Group on the Design Tab ? Applying a Style to a Pivot Table ? Changing PivotTable Style Options ? Manually Formatting a PivotTable ? Using the PivotTable Options Dialog • Using the Classic PivotTable Layout ? Creating an Empty (Classic) PivotTable Frame ? Switching an Existing PivotTable to a Classic Layout ? Adding Data ? Pivoting Data AVANTUS TRAINING PTE LTD 79 Robinson Road #15-04 CPF Building Singapore 068897 Sales Hotline: (65)64163078 Email: enquiries@AvantusTraining.com www.AvantusTraining.com Microsoft AVANTUS TRAINING PTE LTD 79 Robinson Road #15-04 CPF Building Singapore 068897 Sales Hotline: (65)64163068 Email: enquiries@AvantusTraining.com www.AvantusTraining.com • Advanced PivotTable Tasks ? Creating a PivotTable Based on External Data ? Refreshing External Data ? Creating a Slicer ? Using the Slicer Tools Tab • Exploring Excel Functions ? What are Functions? ? The Functions Library ? Finding the Right Functions ? Inserting Functions ? Some Useful and Simple Functions • Using Functions in Excel ? Using the IF Function ? Working with Nested Functions ? Breaking up Complex Formulas ? Using Functions and AutoFill to perform Difficult Calculations

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: