Improve your efficiency and expand your capabilities in just one fun and eye-opening day! One-day Advanced Training for Microsoft® Excel® was developed for Excel users who are ready to put this amazing software to work for amazing results.
Your expert instructor will use our exclusive hands-off training approach that guarantees you’ll learn—and retain—a maximum amount of information in a minimum amount of time!
Excel, the longstanding powerhouse of spreadsheet software, is one of the most commonly used business applications on the planet. As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This workshop will teach you the most advanced features and functions Excel offers—taking your level of proficiency from mid-level to advanced. After one day of training you’ll be amazed at how this powerful program can work for you.
This intensive day of training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experience or mid-level Excel user in order to get the most out of this incredible training.
Learning Outcomes
Upon completion of this workshop you will be able to:
- Navigating Excel so that you know where to find everything.
- Using formulas to handle difficult calculations quickly.
- Livening up your work with different fonts, colours and effects
- Setting up your sheet so that it looks professional on-screen and when printed out.
Workshop Duration
One Day
Course Outline
- Using the Advanced Filter and AutoFilter to display the information you need
- Controlling multiple ranges with AutoFill
- Extracting filtered ranges
- Using multiple criteria for creating advanced filters, databases and list management
- Time-saving keyboard shortcuts
- Setting up shared workbooks
- View users sharing a workbook
- Change the updated frequency
- Merging shared files
- Creating pull-down menus for shared workbooks
- Macro review: Running, stopping and pausing macros
- Assign macros to buttons and objects
- Starting Visual Basic® Editor (VBE)
- Using VBE to create new macros and edit existing ones
- Using variables in macros
- Creating interactive macros
- Debugging macros with the Step feature
- Editing existing macros from the macros menu
- Editing existing macros using Editor
- Streamlining your access to VBA modules with Project Explorer
- Where to find free Visual Basic code for macros
- Building complex formulas quickly and easily
- Using the Function Palette and cutting your work time in half
- Using key logic functions IF, AND, OR and NOT to make data more usable
- Creating conditional formulas
- Using MATCH, INDEX, VLOOKUP and HLOOKUP in large worksheets
- Manipulating text entries with Excel®’s extensive set of functions and formulas
- Using Goal Seek and Solver
- Working with the Analysis ToolPak
- Working with scenarios to analyze data and equations
- Working with view options
- Using auditing to create a visual map of your data
- Creating custom charts for added interest and relevance to your reporting
- Exploring database functions
- Working with data forms
- Creating data tables
- How to create and manage PivotCharts and Tables
- How to do a quick Internet search for information—right from your Excel spreadsheet
- Creating hyperlinks in your spreadsheet that will take users straight to a Web page
- Importing and exporting text files and XML data
- How to publish your Excel charts and data on the Web more quickly
Services
DO YOU NEED SUPPORT !
Phone:
Address:
1st floor, 35-B, Block A, HBFC Faisal Town, Lahore, Pakistan
