Materi Training Excel Advance

07.08.2019

You can learn Excel 365 ProPlus, 2019, 2016 or 2013 with training from ONLC. Demonstrating any level of skill in this program can be quite beneficial because Excel proficiency is in high demand by employers. Our Excel classes can also be used as preparation for Excel MOS certification .

If you want to add more page breaks, follow these steps: Place your cursor on the row or column where you want to create a new page break. Click the Page Layout tab on the ribbon interface. Click the Breaks button. In the dropdown that pops up, click Insert Page Break. . Menyesuaikan dan meningkatkan workbook dan lingkungan Microsoft Excel. Materi Pelatihan Advanced Microsoft Excel 1. Menghitung Data dengan Rumus Lanjutan. Mengelola Cell dan Range. Request for Training Venue: Semarang, Solo, Bandung, Jakarta, Balikpapan, Surabaya, Jogja, Lombok, Malang, Makassar and Batam In House Training Depend on.

Materi Training Excel Advance Formula

Microsoft Excel is part of the Microsoft Office suite. It's a powerful tool you can use to create and format spreadsheets and analyze and share information to make more informed decisions. ONLC has classes for those new to Excel on up through advanced training like Excel Programming with Visual Basic for Applications (VBA), Business Intelligence (BI),and our exclusive Excel Power User course.

Instructor-led Training (ILT)

ILT classes are live and hands-on training. Training is fully interactive via remote instructor . Attend ILT classes at any of ONLC's more than 300 sites or from your own location .

On-Demand Training

On-Demand classes are self-study, self-paced you take using your own equipment. You have 24/7 access to your course for 6 months. On-Demand classes include video tutorials, live labs and assessments.

By the Course or Bundle

Free Advanced Excel Training Online

Just need one course? See our Excel class list .
Need multiple courses or MOS certification prep? Our Excel Bundles are discounted and have optional value-adds.

Excel Classes

Classes are live, hands-on, training via remote instructor (FAQs), except for “On-Demand” titles which are self-study.

** We've crammed 8 courses into this amazing Microsoft Office bundle. Unlock the secrets of Office 2016 or 365 with this 60+ hour mega-course. Practice exercises included**

Free advanced excel training


Master the Ins and Outs of Microsoft Office and Boost Your Productivity


This 8COURSE BUNDLE includes:

  • Microsoft Excel 2016 (beginners) - learn the basics of spreadsheets

  • Microsoft Excel 2016 (intermediate) - take those spreadsheet skills to the next level

  • Microsoft Excel 2016 (advanced) - master spreadsheets

  • Microsoft Word 2016 - master documents

  • Microsoft PowerPoint 2016 - master presentations

  • Microsoft Access 2016 - master databases

  • Visual Basic for Applications (VBA) for Microsoft Excel - master spreadsheet automation

  • Microsoft Outlook 2016 - Master e-mail and calendar management


Over 500, 5 Star Reviews:


'Undoubtedly, this course covers a wide range of topics done in an extremely professional manner. This is worthy of every second and penny I invested in it. It helped me understand various contours of Microsoft Office.' - Muhammad Bashir


'Very clear and thorough. Super for beginners.' - Anna Wyk


'This is what I needed and what I was looking for. Excellent course.' - Roberto Regalado


'My experience with this course was absolutely beneficial to me. The lecturers are so good at explaining the course and not forgetting the exercises they set up for you is amazing it really helps and it gives you experience as you go along with them.' - Jennade Ramruthen


Improve Efficiency with Microsoft’s Premier Office Management Software

Designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of Microsoft Office from this 8 courses in one bundle.


Master Microsoft Excel, start at the beginning if you're brand new to spreadsheets or pick up at Intermediate or Advanced level. For those looking to go beyond normal data analysis you'll learn how to handle databases using Microsoft Access or automate mundane tasks in Excel using VBA.


Free Advanced Excel Training

If that wasn't enough this bundle will teach you how to utilize PowerPoint to create stunning presentations, use Microsoft Word to create documents that inspire and make administration a breeze through learning about mail merge.


** Recently added - unlock the power of Microsoft Outlook 2016 and dramatically improve you productivity and sanity through a clear inbox.**


Bundle Overview


This course is designed for individuals and office professionals who need to master the capabilities of the 2016 or 365 edition of Microsoft Office. With more than 60 hours of video lectures across 8 courses, this course will help you master MS Office 2016, reduce your MS Office frustration and help you claw back the precious time you spend getting lost in these powerful business applications.


  • Excel 2016 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.

  • Excel 2016 Intermediate: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns.

  • Excel 2016 Advanced: Take your Excel skills to the ultimate level with advanced charts, graphs, formulas and data analysis.

  • Word 2016: Create documents, embed videos and set up online collaboration on joint projects for school or work.

  • PowerPoint 2016: Make impactful presentations for your next business meeting using animation, audio/video and collaborative tools.

  • Access 2016 for Beginners: Become a master of data management, customer tracking and buying patterns.

  • Microsoft Essential VBAfor Excel: Learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency.

  • Master Microsoft Outlook 2016 the Easy Way: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.

When you complete this course, you’ll be well on your way to becoming a master of workplace efficiency with the tools available in Microsoft Office 2016.

Why Take This Course

  • Optimize you productivity at work or in your own business.

  • Get noticed by your boss and earn the respect of your colleagues. Become the office superstar by being the go-to expert on everything related to MS Office 2016.

  • Amazing value 8-courses in one bundle. You get professional quality training at a fraction of the normal price.


Why Simon Sez IT for Microsoft Office?

  • We know Microsoft Office. We've been teaching it for over 10 years and your expert instructors have taught thousands of people to learn Microsoft products.

  • We don't rush through content. We take the time to ensure you understand important principles before moving on.

  • Follow along. We provide downloadable practice files so you can practice as you learn.


** Updated May 2018: Outlook 2016 course added**

  • Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016
  • This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint
  • Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint
Comments are closed.