Excel Intermediate

By Codexcel http://www.codr.co.za

Wed Jun 15, 08:30 - Wed Jun 15, 16:30

Hackle Brooke Conference Centre

ABOUT

This course is for the Excel user that is already comfortable with the content covered. This is an intermediate course and includes the following:
  • Excel keyboard shortcuts
  • Excel functions and compound functions
  • Excel advanced tools and functionality
All of this is done from the perspective of a management accountant performing different tasks. The courses really depicts how much more efficient and effective the Excel user can be with utilizing Excels advanced functions and compound functions.
 
This includes a 3 hour Q&A session that can be scheduled in a free slot anytime within the first 2 months post the course. We understand that training is nothing without post course implementation This Q&A session is there to answer questions that have arisen from practical use and implementation and will help resolve any problems on a direct and personal basis.
 
The Excel learners will work in pairs in order to maximize learning. We have found that teamwork aids the learning process and duplicates the take home knowledge.
 
This is a one day course that runs from 8:30am till 4:30pm.
The course includes:
  • Hardcopy course material
  • USB flash drive with:
    • Sample templates
    • Template solutions
  • 3 hour follow up Q&A session
  • Lunch
  • Arrival snacks
  • Tea/coffee/drinks and snacks throughout the day
This course is limited to 10 Excel learners.
Each Excel learner is required to have their own laptop with Excel 2010 at a minimum.

WHO WE ARE

Who we are
  • A team of qualified professionals. Chartered Accountants and Engineers.
  • We all use Excel in our day to day lives. From data analysis for financial models to process automation for fortune 500 companies.

Your course instructor:

DAVID DANSKY
(CA)SA ACMA GCMA

Hi, I am a qualified Chartered Accountant (SA) and a Global Chartered Management Accountant (UK). I lectured at Wits for 2 years earlier in my career. I have also lived in the United States for 2 years and worked for a fortune 500 company. We were in charge of process automation for European statutory compliance. Of course we did this using Excel.

I founded Codexcel 1 year ago. I am now looking to expand and offer my service to the broader business community. I am certain that my offering is effective and will help your staff make better decisions.

WHAT WE DO

We teach staff, professionals and wanna be Excel gurus to use Excel like an IT professional.  We do this to bridge the gap between IT and finance. We teach ALL Excelians to “know what they don’t know” and to provide the resources to make this happen fast.

Our greatest value is teaching Excel users to automate business processes. Limiting the time it takes to perform a task in a more efficient way while providing accurate and reliable data to make effective decisions.

COURSE CONTENT

Basic Spreadsheet Tasks
-              Cell comments and textboxes
-              Keyboard shortcuts         
-              Splitting the screen         
-              Printing and page layout
                                            
Basic Excel Functions      
-              SUM and AVERAGE functions
-              COUNT, COUNTA and COUNTBLANK functions
-              MAX and MIN functions
-              IF function          
-              VLOOKUP and HLOOKUP functions
-              Math functions 
                                            
Basic Excel Tools
-              Tables                 
-              Conditional formatting
-              Data validation 
-              Protecting worksheets and workbooks
-              Ranges                
                                            
Advanced Excel Functions            
-              Working with numbers
               -              COUNTIF, SUMIF and AVERAGIF functions
               -              COUNTIFS, SUMIFS and AVERAGIFS functions
               -              SUMPRODUCT Function
-              Working with text           
               -              TRIM and VALUE functions
               -              Concatenating text
               -              Parsing text
-              Working with dates         
               -              NOW and TODAY functions
               -              YEAR, MONTH, DAY and WEEKDAY functions
               -              DATE and DATEVALUE functions
-              Reference functions       
               -              Cell references
               -              INDEX function
               -              MATCH function
               -              OFFSET function
               -              LOOKUP function
               -              INDIRECT function
               -              CHOOSE function
               -              Dynamic Range
               -              Hybrid functions for Dynamic Range
                                            
Advanced Excel Tools     
-              Working with Pivots        
               -              Create and edit a PIVOT
-              Data tools          
               -              Scenario Manager
               -              Goal Seek           
               -              Data Tables