Microsoft Excel Novice To Advanced Training 7 Days (Full)

Amongst other things you'll learn how to:

1. Basics To Advanced In 7Days

2. Master Excel 2017's new dynamic tables, Graphs, 3. Functions, Macros etc

3. Enforce complex business rules using function-driven custom validations

4. Perform What-If analysis to model and compare business scenarios

5. Use advanced functions to solve real-world business problems

6. Eliminate errors using Excel's advanced formula auditing tools

7. Create intuitive user interfaces using form controls

Use Excel's three different file sharing methods for efficient teamwork

8. Record macros and then execute them from button controls

9. Understand and use all of Excel's security features

10. Design advanced Pivot Tables and Pivot Charts

Use your Excel skills to publish a complete web site from a workbook

11. Create and use dynamic and table-based range names

12. Companies who have taken Smart Method courses include:

AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays,American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others. ..