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 Courseware
Not Appropriate For: Macintosh versions of Excel
We have additional Microsoft Excel Courses
[https://www.certstaff.com/classes/category+category_id+167.html] if
this course doesn't fit your needs:
* Excel - Dashboards
[https://www.certstaff.com/trainingcatalog/course+id+Excel_2013_Dashboards.html]
* Excel - Data Analysis with PivotTables
[https://www.certstaff.com/trainingcatalog/course+id+Excel_2013_PivotTables.html]
* Excel - Level 1
[https://www.certstaff.com/trainingcatalog/course+id+excel-2016-level1.html]
* Excel - Level 2
[https://www.certstaff.com/trainingcatalog/course+id+excel-2016-level2.html]
* Excel - Level 3
[https://www.certstaff.com/trainingcatalog/course+id+excel-2016-level3.html]
* Excel - VBA Programming
[https://www.certstaff.com/trainingcatalog/course+id+Excel-2013-2016-VBA.html]
? Length: 1 day(s)
? Daily Start Time: 7:00 Pacific Time
? Daily End Time: 14:00 Pacific Time
? Registration Cutoff: 15 Days Prior to Class Start
? Price: $335.00 _(U.S. Dollars)_
? Location: 355 S. Grand Ave, Suite 2450, Los Angeles, CA
90071
? Training Format:
HANDS-ON, LIVE ONLINE TRAINING WITH A REMOTE INSTRUCTOR
Certstaffix® Training CLASSES ARE instructor-led live online
training
[https://www.certstaff.com/about/remote-instruction.html] 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 355 S. Grand Ave, Suite 2450, Los Angeles, CA 90071.
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-6890
Email Us [https://www.certstaff.com/about/contactus.html]
-------------------------
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 6
Create 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 111
Format cells 112
Define styles 118
Apply workbook themes and EXCEL TABLE STYLES 121
Make numbers easier to read 127
Change the appearance of data based on its value 130
Add images to worksheets 138
Skills review 142
Practice tasks 143
Chapter 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 278
Chapter 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 you are not familiar
with this training format, see our REMOTE INSTRUCTOR-LED page HERE
[https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fu5159956.ct.sendgrid.net%2Fls%2Fclick%3Fupn%3DFJtdl5L6mtgFfvDVwv3xn58t0iEA3DvpPNWDAdjIMllxtf58TV4HMwX7lIqmUTVJZnMRvzWaHBXUqSDqvm-2BkYw-3D-3DTBJq_JGKgkvOEuwPrlg7LrbWCAJUzQo3BFYiH1BVBiHvajsTo1an5SNv9VzwsH1C2Gm6my1C7TjBDYxwOl0VMguy-2BU6CILCsC5jTQ0gBXMF-2B7kn7vJalAs04fgL6P7gHE8-2F8pNk3JLbPBfcLjX78jC-2FuUfoYRFEoEy7G4GB8UXRmRu1nsqjc4SQbJ7Q-2F7EmVYXGIgsCWfUyvOvO7fz0TL1xt5TdVheTtW93LfK2mhr6P1JIQ-3D&data=02%7C01%7Cregistrations%40certstaff.com%7C710fa25302434e4f362408d81dfcd572%7C2e070d9d5520488baaca47498effec4b%7C0%7C0%7C637292319044596490&sdata=gEVPbXM%2Bxqq0BsAHzIorVL3ybIvkopYdCLp5ba4Om20%3D&reserved=0].
*
Our standard payment terms are net 15 days from a registration
request, but NO LATER THAN 15 DAYS BEFORE THE FIRST DAY OF THE CLASS.
To request alternative payment terms, you must call 888-330-6890.
*
If you have submitted a late registration request, less than 15 days
before your class start date, we require immediate payment. If we have
not received your payment by the due date on the invoice we sent you,
we may reschedule or cancel your enrollment. We will inform you before
making any changes to your registration.
*
You can CANCEL your registration without penalty or charge provided
you give Certstaffix Training notice of 18 DAYS OR MORE BEFORE THE
FIRST DAY OF YOUR CLASS.
*
If you request to RESCHEDULE your registration LESS THAN 18 DAYS
BEFORE THE FIRST DAY OF YOUR CLASS, you will be charged 100% of the
course fee, and you won't be entitled to a refund. You will have one
(1) opportunity to use the Certstaffix Training Make-Up policy to have
those funds applied to a later class date.
*
If you DON'T SHOW UP to your class, you will be charged 100% of the
course fee, and you won't be entitled to a refund. You will have one
(1) opportunity to use the Certstaffix Training Make-Up policy to have
those funds applied to a later class date.
*
IF YOU ARE ATTENDING CLASS FROM A CERTSTAFFIX TRAINING COMPUTER
LABS and you request to RESCHEDULE your registration LESS THAN 15
DAYS BEFORE THE FIRST DAY OF YOUR CLASS, or if YOU DON'T SHOW UP FOR
YOUR COURSE, AN ADDITIONAL SEAT FEE OF $100 PER DAY WILL BE CHARGED
FOR YOU TO ATTEND YOUR MAKEUP SESSION FROM THE COMPUTER LAB
LOCATION. You may attend your makeup session from your home or office
without any additional seat fee.
*
IF YOU ARE USING THE ONE MAKE-UP SESSION OF YOUR CLASS allowed by the
Certstaffix Training policy, and we have previously sent you course
materials, YOU WILL BE RESPONSIBLE FOR 100% OF THE COST OF ANY NEW,
OR AN UPDATED VERSION, OF THE COURSE MATERIALS USED DURING THE MAKE-UP
TRAINING.
*
Should Certstaffix Training need to cancel your class due to
insufficient enrollment, or postpone it due to events beyond our
control, Certstaffix Training will notify registered students as soon
as possible. In such cases, you may reschedule to a future class date
at no additional charge or receive a full refund for your class
registration.
*
Travel arrangements and costs are the sole responsibility of the
student. Certstaffix Training suggests obtaining refundable
reservations. Certstaffix Training classes are confirmed approximately
18 days before the start of the course. 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.
culture
courses
617
Views
28/07/2021 Last update