Event Date: 2019-12-18 10:00:00
Excel – Level 1 This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks, enter data, and format it for easier viewing, Perform calculations and find and correct errors, Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps and Print worksheets and charts Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)Course Taught With: Excel version 2016 (Microsoft Windows PC) Software and CoursewareNot Appropriate For: Macintosh versions of Excel Related Courses: Excel – Dashboards Excel – Data Analysis with PivotTables Excel – Level 1 Excel – Level 2 Excel – Level 3 Excel – VBA Programming Length: 1 day(s) Daily Start Time: 10:00 Eastern Time Daily End Time: 17:00 Eastern Time Registration Cutoff: 15 Days Prior to Class Start Price: $335.00 (U.S. Dollars) Location: 301 W. Bay Street, Suite 1400, Jacksonville, FL 32202 Training Format: Hands-on, Live Online Training with a Remote Instructor Certstaffix® Training classes are instructor-led live online training you attend in a local computer lab or from your home/office. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting. Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions. Our Remote Instructor-led classes offer: A real, live instructor teaching you from another location Hands-on learning with the software you are being taught Interaction with all students in the class at other locations Easy assistance from the instructor: To ask a question, you simply speak and all students and the instructor can hear you They can see your computer screen with permission They take control of your computer if you get stuck with permission Two Ways to Attend: 1. Attend From Your Home or Work You can attend any of our public classes from your home or work – all you need is a high-speed internet connection. We provide access to any needed software and lab environments during your class. We’ll ship you any course material about 1 week prior to your class start date. 2. Attend From One of Our Computer Labs You can also attend any of our public classes at our computer lab location at 301 W. Bay Street, Suite 1400, Jacksonville, FL 32202. You’ll get access to a fully set up learning environment for you to walk into and start class. We provide a computer and access to any needed software and lab environments. We’ll ship you any course material about 1 week prior to your class start date. Questions? Feel free to call or email us if you have questions about course content or how our training method works: Call Us: 888-330-6890Email Us We have additional Microsoft Excel Courses if this course doesn't fit your needs. Course Outline: Chapter 1: Set up a workbook 3 Explore the editions of Excel 2016 4 Excel 2016 4 Excel Online 4 Excel Mobile Apps 5 Become familiar with new features in Excel 2016 6Create workbooks 7 Modify workbooks 13 Modify worksheets 18 Merge and unmerge cells 23 Customize the Excel 2016 app window 26 Zoom in on a worksheet 26 Arrange multiple workbook windows 28 Add buttons to the Quick Access Toolbar 30 Customize the ribbon 33 Skills review 39 Practice tasks 40 Chapter 2: Work with data and Excel tables 43 Enter and revise data 44 Manage data by using Flash Fill 48 Move data within a workbook 51 Find and replace data 56 Correct and expand upon data 60 Define Excel tables 65 Skills review 69 Practice tasks 70 Chapter 3: Perform calculations on data 73 Name groups of data 74 Create formulas to calculate values 77 Sidebar: Operators and Precedence 88 Chapter 4: Change workbook appearance 111Format cells 112Define styles 118Apply workbook themes and Excel table styles 121Make numbers easier to read 127Change the appearance of data based on its value 130Add images to worksheets 138Skills review 142Practice tasks 143Chapter 9: Create charts and graphics 237 Create charts 238 Create new types of charts 248 Customize chart appearance 252 Find trends in your data 260 Create dual-axis charts 263 Summarize your data by using sparklines 264 Create diagrams by using SmartArt 266 Create shapes and mathematical equations 271 Skills review 277 Practice tasks 278Chapter 11: Print worksheets and charts 323 Add headers and footers to printed pages 324 Prepare worksheets for printing 330 Fit your worksheet contents to the printed page 331 Change page breaks in a worksheet 334 Change the page printing order for worksheets 335 Print worksheets 337 Print parts of worksheets 339 Print charts 343 Skills review 345 Public Class Policies and Conditions When you enroll into our public classes, on the registration form, you have acknowledged and agreed to our public class policies and conditions. This includes cancellation/reschedule/no show policies that are time sensitive. I understand: Certstaffix® Training classes are live, hands-on training with your instructor teaching from a remote location. If not familiar with this format see our Remote Instructor-led page. Certstaffix® Training is primarily a Business-to-Business training provider. In certain locations, we cannot accept enrollments from students who's tuition fees are being paid by themselves, not their employer. Read full details here Payment: If paying by check – Payment is due 15 days from this registration request. To request alternative payment terms, you must call 888-330-6890. If you have submitted a late registration, less than 15 days before your class start date, we require immediate payment. If we have not received your payment by the due date, we may reschedule/cancel your enrollment. We will inform you prior to making any changes to your registration. I can cancel or reschedule my registration without penalty or charge provided I give Certstaffix® Training notice of 14 days or more before the first day of my class. If I request to cancel or reschedule my registration less than 14 days before the first day of my class, I will be charged 100% the course fee and am not entitled to a refund. I have one (1) opportunity to use Certstaffix Training Make-Up policy to have those funds applied to a later class date. If I no show to my class, I will be charged 100% the course fee and am not entitled to a refund. I have one (1) opportunity to use Certstaffix® Training Make-Up policy to have those funds applied to a later class date. If attending in a computer lab: an additional seat fee of $100 per day will be charged to attend my makeup session. I cannot change my class location 14 days or less before the first day of class because Certstaffix® Training has shipped training materials and provisioned resources. Location changes requested prior to that timeframe are subject to availability and may incur an additional charge. Should Certstaffix® Training need to cancel my class due to insufficient enrollment, or postpone it due to events beyond their control, Certstaffix® Training will notify registered students as soon as possible. In such cases, the student may reschedule to a future class date at no additional charge or receive a refund for any money on account relating to that registration. Travel arrangements and costs are the sole responsibility of the student. Certstaffix® Training suggests obtaining refundable reservations. Certstaffix® Training classes are confirmed approximately 14 days before the start of the class. We cannot guarantee class commitments before that window of time. Certstaffix® Training will not be responsible for any cancellation costs incurred, including but not limited to, airline/mass transit tickets, hotel reservations and so on.
Certstaffix Training Jacksonville
301 W. Bay Street, Suite 1400
Events by Eventful