1. Home
  2. Course
  3. Microsoft Excel 2013 Advanced

Microsoft Excel 2013 Advanced

  

About this Course

COURSE OUTLINE FOR MS EXCEL 2013 ADVANCED Create and use your own workbook template Consolidating data from different worksheets as well as different layout Using form for faster and safer data entry Applying basic and advanced sorting techniques Applying subtotals to your data for summary report Applying basic and advanced filtering techniques Using Table features to enhance your data Using Power View to customize the view of a huge database Creating drop list to speed-up data entry and improve accuracy Apply validation and create drop list to speed-up data entry and improve accuracy Using Excel auditing tools to audit worksheet formula Using What-If analysis tools to analysis the data Using Sparkline to visualize the data Recording and using macro Applying advanced functions to solve problems, search for data and making decision Using Pivot Table to easily generate reports and visualize the report using Pivot Chart

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: