Intermediate Excel Skills for Law Enforcement Inspections and Auditing Excel-201 (Live Online) – 3 hours CEP certificate provided

We're sorry, but all tickets sales have ended because the event is expired.
  • Intermediate Excel Skills for Law Enforcement Inspections and Auditing Excel-201 (Live Online)
     February 4, 2022
     10:00 am - 1:15 pm

Live Online February 4, 2022

Presented by LD Consulting

Course Description:  
Learn intermediate Microsoft Excel skills for law enforcement inspections and auditing to enhance your knowledge and improve your effectiveness while adding value to your position and your organization. Microsoft Excel is the industry-leading spreadsheet software program, a powerful data visualization and analysis tool used by most government organizations. This course is based on law-enforcement-related scenarios and is designed to give you an intermediate mid-level working knowledge of Excel specifically for Law Enforcement related inspections and auditing engagements. Excel functionality is introduced using easy-to-understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them. This class is the second in a series of Excel classes designed for law enforcement inspections and auditing professionals.

 

Excel-201 Course objectives: Who should take this course?

 

This class is for law enforcement professionals (sworn and non-sworn)

  • With some experience with Excel (see chart above)
  • Interested in or responsible for law enforcement business related-controls, compliance, and quality assurance activities
  • Interested in leveraging Microsoft Excel for inspections and auditing to make your job easier

Sessions will include an Excel template and step by step written instructions for all class exercises. Computer used during class must have camera and microphone for WebEx online sessions and Microsoft Excel software.  Participants should have Excel 2016 or higher installed on their computer prior to attending this workshop. Classroom location: In the comfort of your home or office!  LIVE Online course.QUESTIONS / CONCERNS:   Call:    Dan OlsonPhone: (602) 510-8481 Email:dan@ldconsultingllc.com    Web Site:LDConsultingllc.com      COST: REGISTRATION:  $110.003 hours CEP certificate provided.Class meets online Friday February 4th At 10:00 AM (CA. Time) ending at 1:15 For more information or to register on line go to https://www.ldconsultingllc.com/schedule
For more information or to register online go to https://www.ldconsultingllc.com/class-scheduleClass Flyer

If you are competent in using Excel for the following tasks, take this course! If not, take the 101 course. What is covered in the intermediate 201 course
  • Use basic ribbon functions
  • Create your own easy-to-use spreadsheets and workbooks from scratch and understand how they work!
  • Format cells, columns, and rows
  • Use number and data formats
  • Create and edit tables
  • Sorting / Filtering data
  • Creating drop-down menus
  • Create and format tabs
  • Printing  and auto-fill options
  • Combining data from multiple cells
  • Combining data from multiple sheets
  • Formulas and Functions
  • Data Subtotals
  • Custom sort
  • Conditional formatting
  • Random Sample
  • Stratified Sample

 

This class is for law enforcement professionals (sworn and non-sworn)

  • With some experience with Excel (see chart above)
  • Interested in or responsible for law enforcement business related-controls, compliance, and quality assurance activities
  • Interested in leveraging Microsoft Excel for inspections and auditing to make your job easier

Sessions will include an Excel template and step-by-step written instructions for all class exercises. The computer used during class must have a camera and microphone for WebEx online sessions and Microsoft Excel software.  Participants should have Excel 2016 or higher installed on their computer prior to attending this workshop.

 

Classroom location: In the comfort of your home or office!  LIVE Online course.

QUESTIONS / CONCERNS:   Call:    Dan Olson
Phone: (602) 510-8481 Email: dan@ldconsultingllc.com    Web Site:LDConsultingllc.com

COST: REGISTRATION:  $110.00

3 hours CEP certificate provided.

Class meets online Friday, February 4th At 10:00 AM (CA. Time) ending at 1:15

For more information or to register online go to https://www.ldconsultingllc.com/class-schedule

Class Flyer

Venue:  

,

Description:

Here is a little help getting connected:

When you click ‘Join Meeting’ in your email, it will open a page to engage in the meeting.

If you don’t have Webex installed, it will automatically download the file. You can click and install the file if you have permission to do so on your computer. This will give you the best viewing experience with the class.

If you wish to download the app and pre-install it, you can click here. Choose Webex Meetings and follow the installation prompts.

If you do have the software pre-installed, the web browser will detect it and ask if you want to open the meeting in the software. Click ‘Open Cisco Webex Start’ to get into the meeting.

If you cannot install or utilize the software, you can click on ‘Join from your browser’ and it will open the meeting.

It will prompt you for permission to access your camera and microphone. You will need to allow this to participate in the meeting.

You can then enter your name and email address and click ‘Next’ to join the meeting.

When you connect, you can control your microphone and video status from the bar at the bottom of the screen. While in the meeting, you can get the speaker’s attention by clicking on the button with the three vertical dots and selecting ‘Raise Hand’. By clicking on the middle button (person symbol) you can see the other participants in the session. You can also message the presenter or attendees during the session using the chat bubble (blue) as well.

Please mute your microphone when you connect. You can un-mute it when you have a question.

For additional tips for a good meeting, please click here.

 

For additional assistance or questions email: toby@ldconsultingllc.com